DBA Activity Report Configuration

This topic describes the metadata that you can select to be included in a DBA Activity type report (see Report Types). DBA Activity reports can be generated on monitored Windows or Mac-based endpoints.

ITM On-Prem (ObserveIT) enables you to generate reports based on SQL queries that were executed by DBAs against production databases. For details, see Auditing DBA Activity.

For example, you might want to generate a report showing all sessions containing SQL queries in which a specific database user was looking for specific alert IDs in the Alerts database, during a specified time period.

For detailed instructions on the steps required to create a report, see Creating a Custom Report.

When creating a DBA Activity type report, you can specify types of columns for:

DBA Activity fields: as described in the table
Session fields: see Session Report Configuration
Endpoint fields: see Endpoint Report Configuration
User fields: see User Report Configuration

Type	Column	Description
DBA Activity	Date of First Slide (in Group)	Date (from server) of the first session slide that was captured in a group. When creating a report, you can specify how report results will be grouped. If for example, SQL Queries are grouped according to Database User, selecting this field will display an entry for each unique combination of Database User + SQL Query.
	Date of First Slide (in Group) (local endpoint time)	Date (from local endpoint) of the first session slide that was captured in a group. When creating a report, you can specify how report results will be grouped. If for example, SQL Queries are grouped according to Database User, selecting this field will display an entry for each unique combination of Database User + SQL Query.
	Play Video (Button)	Select to display the Video replay icon for playing back the session with the DBA Activity.
	SQL Query	The include list operator enables you to specify the SQL queries to be included in your report. Each value that you enter in the text field will be included in the report. A maximum of 440 characters is permitted for each value entered in the text field.
	Database Name	Name of the database on which the activity occurred.
	Database User	Name of the user who performed the SQL query.