"Database Administration" Report in Privilege Management

The Database Administration report is an optional feature and will only be available if you check the Install audit database administration report box during the Reporting Pack installation.

To view the report, navigate to it from the Reporting root directory.

In your web browser, go to the URL https://hostname/ReportServer. If you are using a named SSRS instance, the URL is https://hostname/ReportServer_InstanceName:

  1. Click the BeyondTrust Privilege Management link where Reporting or Avecto Privilege Guard is the name of your Reporting database.
  2. From the top of the list, click the Admin link.
  3. Click the ErpEventsAdmin link.

The Database Administration report provides application event purge and exclusion functions. In some situations applications create an audit data volume that exhausts capacity. These functions allow you to respond to excess event data quickly.

Chart Description

Events generated over the last 12 months

Displays the number of events across all your applications for the last 12 months.

Events totals (over all time)

Displays the number of events in the database filtered by processes, events, user sessions, and host sessions.

Purging options

Purging data removes the data from the database using the Purging Options available from the report:

  • Purge data older than 6 months
  • Purge data older than 3 months
  • Purge data older than 1 month
  • Purge all data

Top 20 applications in database

The table displays the top 20 applications in the database by the number of events they generate.

Click Purge to purge the events from that application. Future events will still be captured.

Click Purge & Exclude to purge the events from that application and stop future events from being collected. Excluded applications appear in the table at the bottom and can be removed from the exclusion list.