Our NetWrix Logon Reporter database size is getting too large. How can we reduce the size and delete old events?
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:
- Launch NetWrix Logon Reporter, and open the Reporting tab.
- Click the Configure button for Advanced Reporting (SQL SRS).
- 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).
- Click Apply to save the changes.
The NetWrix Logon Reporter database size will be reduced during the next data collection process.