How to reduce the NetWrix Logon Reporter database size

Our NetWrix Logon Reporter database size is getting too large. How can we reduce the size and delete old events?
Email It to Me Print this Page
Question Our NetWrix Logon Reporter database size is getting too large. How can we reduce the size and delete old events?
Answer

You can reduce the database size by setting the SQL database retention period that allows controlling the amount of data stored in your SQL database. In accordance with this setting, the database size is automatically updated during the event collection process.

To configure the SQL database retention settings, do the following:

  1. Launch NetWrix Logon Reporter, and open the Reporting tab.
  2. Click the Configure button for Advanced Reporting (SQL SRS).
  3. In the Reports Settings dialog, select the Store audit data in the database for check box, and specify the number of days (for example, 30 days).
  4. Click Apply to save the changes.
The NetWrix Logon Reporter database size will be reduced during the next data collection process.
Was this information helpful?