Built-in reports for Data Sets

DATA SET Access: This report is based on a main entity of “object”. This means that the report has one line for each object (data set). So if you have an access command (Verb) with multiple objects, the command will appear in the report multiple times, once for each object.; The extra rows can be skipped if you check 'add distinct' in the Query-Report Builder for the report.; Note: This report does have customized column names to make the report more readable. By editing the report query and comparing with the report headers, you can see the differences.

Example: Instead of SQL Verb, the column is Action. And instead of DB Protocol, the column is Event Type.; If you like the built-in query and want to further customize the report, you can go to Report Builder to clone the report definition and customize the column headers.

DATA SET Access: This report is based on the Full SQL main entity and includes a pretty complete set of attributes for data set and record level access.

Recommendation: Clone this query and make the following modifications:

Move the timestamp to the first column.
Add the full SQL ID column to enable very detailed sorting if timestamp granularity is not fine enough.
Review the query conditions in the query. If you want to use the same report for other databases, such as IMS, you may want to make the DB Protocol field a Parameter instead of a value.