Create an Administration Commands Execution report

Procedure

  1. In the Queries-Reports pane, use the menu to select the Access domain.
  2. Click new to open the New Query builder.
  3. In the Query Name section, in the Query Name field, type Administration Commands Execution.
  4. Use the Select main entity menu to select FULL SQL.
  5. Click Next.
  6. In the Selected Columns section, select the following Entity: Attribute pairs then click copy to add them to the report.
    • Client/Server: Analyzed Client IP
    • Client/Server: DB User Name
    • Client/Server: Server IP
    • Client/Server: Source Program
    • Client/Server: Service Name
    • FULL SQL: Full Sql
    • FULL SQL: Timestamp
  7. Click Next.
  8. In the Sort Order section, accept the default Sort results by column setting and click Next.
  9. In the Conditions section, click add condition to add the following condition: Command: SQL Verb with the operator IN GROUP and group Administrative Commands.
  10. Click Save.
  11. Click Add to My Custom Reports to add the report to the Reports > My Custom Reports navigation item.