Defining Column Details for a Report

Originally, our report table included six columns: Source IP, Destination IP, Protocol Number, Protocol Name, Port Number, and Bytes Transferred.

To define columns for your customized report:

1. Click Add column.

   To find out what columns you used, take a look at your Report Writer report output or go to the Report Writer and activate the Select Fields tab.

2. Add Source IP, Destination IP, Protocol ID, Port Number and Bytes columns.

   Note: To find out what columns you used, consult an archived Report Writer report or go to the Report Writer and activate the Select Fields tab.

   1. Make sure you have Netflow Flow By Conversation History selected both in the drop-down list and below it.
   2. Select Source IP in the Database column name area.
   3. Select Destination IP in the Database column name area.
   4. Select ProtocolID in the Database column name area.
   5. Select Bytes in the Database column name area.
3. Add Application Name and TCP/UDP Port Name columns.
   1. Make sure Netflow Flow By Conversation History is selected in the drop-down list and below it, select Netflow Application.
   2. Select Application Name and TCP/UDP Port Name in the Database column name area.
4. Add the Protocol Name column.
   1. Make sure Netflow Flow By Conversation History is selected in the drop-down list and below it, select Netflow Protocol.
   2. Select Protocol Name in the Database column name area.

   The Add column screen with all required columns looks like this:

   

5. Click ADD COLUMN to add selected columns.
6. Drag and Drop the columns to achieve the requested order.
7. Specify units and aggregation of bytes.

   Note: To check aggregation settings in the obsolete report, consult the Select Fields tab in the Report Writer.

   1. Click Advanced in the Bytes column .
   2. Select Data Unit in the Add display settings list.
   3. In the Units of measurements, select Bytes (1000). This defines the units shown on the report.
   4. In the Units in my database list, select B.
      
      Note: Make sure you select correct units used in your database. Selection of incorrect units results in incorrect data displayed in the report.
   5. In the Data aggregation list, select Sum.

      

8. If you want to edit the look of a column for the report, click the Advanced button next to it. You can adjust for example the column title (Display name), hide the column in the resulting report or add further display settings (icons, units, etc.).

   To find out these details in the Report Writer, activate the Field Formatting tab and review the information provided for individual fields.

9. Define how items should be sorted in the report:

   We would like to have items in the resulting report sorted by the bytes column, the lowest value being first and the highest value being last.

   Note: If you want to check the aggregation settings in the original Report Writer report, go to the Report Writer and consult the Select Fields tab.

   1. Go to the Sort results by area.
   2. Select the column according to which results should be sorted. For our report, select Bytes - NetFlow Flow by Conversation History.
   3. Define the sorting direction. Select Descending here.
      Sorting directions:
      • Ascending: smallest values are shown first, and the sorting proceeds to highest values.
      • Descending: highest values are shown first, and the sorting proceeds to smallest values.

      

10. Define how many items you want to see in the table.
    1. Go to the Filter results area.
    2. Select the Show only the top option.
    3. Enter the value 5.

       

       Note: In the Report Writer, you can find this information in the Top XX tab.

11. Click PREVIEW REPORT.

    If there are any columns that you do not want to see in the report, remove them by clicking the appropriate X in the header or hide them:

    1. Click Advanced for the appropriate column.
    2. Select the Hide this column in the resulting table option.
12. Click SUBMIT.