Learn how to create your own custom report in Guardium®
Data Security Center.
Before you begin
Data Compliance DDR This content is
available through the IBM
Guardium Data Compliance and Guardium Data
Detection and Response modules
To open the reports page, select
in the
main menu. Open this menu by clicking the main menu icon (
). You can also access the reports by
selecting View all reports in the Favorite reports
card in the Guardium
Data Security Center overview page.
Procedure
- In the Reports page, click New report. If you
are viewing an individual report, click
New.
- 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.
- In the Reports page:
- Click the Report name field and specify a
unique report name.
- 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.
- Click Description to add a description for the
report.
- Optional: Change the time range from the default of 3 hours. (Available
time ranges are described here).
- Add columns by selecting the column headers (where each column header represents a
data
point):
- 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.
- 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).
- 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.
- Click Apply to view the report. You can continue to modify the report
until you have the set of data you want.
- Optional: Add filters to
the report.
- To save the report permanently, click Save As.
- Verify the name and optionally a description, and click
Save).
What to do next
You can delete a custom report by using the delete icon on the Reports page. When you
delete a report, the investigation links for the report are also deleted. You can work further
with the report, as described in Working with a single report.
.