Audit Database

If you want to generate reports and run interactive search queries, you should configure Netwrix Auditor to store collected data to the SQL Server database (Audit Database). By default, each Monitoring Plan will use a dedicated database to store data. So, there are two types of database settings:

  • Global settings that apply to all Audit Databases:
    • Default SQL Server instance hosting all databases
    • SQL Server Reporting Services (SSRS) settings
    • Retention settings

    Usually, initial global settings are configured when you create a first monitoring plan. They become the defaults and appear on the Settings Audit Database tab. If you have not specified the default settings before, click Configure.

  • Specific settings for each dedicated database. You can configure specific database storage settings for each monitoring plan individually. For that, use a Monitoring Plan wizard or navigate to the monitoring plan's settings. Fine-Tune Your Plan and Edit Settings for details.

To review and update global Audit Database settings, navigate to Settings Audit Database.

Use Configure and Modify buttons to edit the settings.

Specify the following database storage settings:

Option Description

Default SQL Server settings

Specify SQL Server instance name and connection settings. See To configure default SQL Server settings for more information.

Database retention

Configure retention if you want audit data to be deleted automatically from your Audit Database after a certain period of time.

These settings cannot be modified for a certain plan. See To configure database retention for more information.

SQL Server Reporting Services settings

Define the Report Server URL and account used to upload data to Report Server. These settings cannot be modified for a certain plan. See To configure SSRS settings for more information.