Creating a custom report

Learn how to create your own custom report in Guardium® Insights SaaS.

1. In the Reports page, click New report. If you are viewing an individual report, click New.
2. Choose the Report category:
   • Classification
   • DB activity
   • DB exception
   • Full SQL
   • Policy violation
   • Vulnerability assessment
   • Assets
   Each report category offers different data points, as listed here.

   Note: You cannot modify the report category after a report is generated. To generate a report of a different type, you need to create a different report.
3. In the Reports page:
   1. Click the Report name field and specify a unique report name.
   2. Tags are used to categorize reports. To add a tag for the report, click Tags and then select one or more of the default report tags. Alternatively, type in your own tag. When you finish typing the tag name that you want, click its checkbox to select it for the report.
   3. Click Description to add a description for the report.
   4. Optional: Change the time range from the default of 3 hours. (Available time ranges are described here).
   5. Add columns by selecting the column headers (where each column header represents a data point):
      1. Select the columns that you want to see in the report (reports can have a maximum of 25 columns total). When you select columns to add to the report, they are added to the report in the order in which you select them.
         Tip: Use the case-insensitive Search field to narrow the list of column headers. The list of columns is filtered as you type.
      2. After selecting the column headers, click Add.
         Note: At any point after adding columns, you can add more columns by clicking Add columns. You can change the order of the columns by dragging them.
         Each column that you add is listed in the left panel. Each column has a menu with the relevant actions for the data type:
         • Delete: Deletes the column from the report. All data types.
         • Rename: Click to rename the column for this report only. All data types.
         • Use default name: Click to revert to the original header (if the column was renamed). All data types.
         • Create variant: Creates a variant.
         • Set function: Lists the aggregation functions. You can select one function at a time per row. To change the selection, click another option. You can add a column multiple times with different functions. (If a column is defined twice identically, the system responds with an error when you try to save or apply the changes.) To clear a selection, click the x next to the function name, for example .
           • Count: All data types. Replaces the column value with the number of occurrences of the specific column value. For example, 25 rows have the timestamp 2021-03-11 10:04:59.0. The value in the Count (Exception timestamp) column is 25, and not the timestamp.
           • Sum: Numeric data only. Aggregates the rows that have identical data except for the column, and displays the sum of all values (of the aggregated rows) in this column.
           • Average: Numeric data only. Aggregates the rows that have identical data except for the column, and displays the average of all values in this column (of the aggregated rows).
           • Lowest: Numeric data and dates only. Aggregates the rows that have identical data except for the specific column, and displays the lowest of all the values in this column (of the aggregated rows).
           • Highest: Numeric data and dates only. Aggregates the rows that have identical data except for the specific column, and displays the highest of all the values in this column (of the aggregated rows).
      3. Depending on the data, the final report might have duplicate rows, for example, one user, from one source address, to one destination address, and the same exception type. If you want to hide the duplicate rows, select Hide duplicate rows. If you select to hide the duplicate rows, you can select Add column to indicate number of duplicate rows to add a column that indicates the number of duplicate rows.
      4. Click Apply to view the report. You can continue to modify the report until you have the set of data you want.
   6. Optional: Add filters to the report.
   7. To save the report permanently, click Save As.
   8. Verify the name and optionally a description, and click Save).