Send Knowledge Base Article
The article has been sent to your inbox successfully.
We never share your data
How to delete old audit data from the database after the upgrade
KB1584 | Last review: Apr 17, 2013 | Netwrix Auditor for Windows Server | 4.0 and above
|Question||When upgrading from NetWrix Server Configuration Change Reporter 3.0 to NetWrix Windows Server Change Reporter 4.0, the database retention setting available in the new product version will be inapplicable to audit data collected before the upgrade. How do I delete old audit data from the database?|
To delete audit data collected before the upgrade from the database, perform the following steps after the first data collection has run on the monitored servers:
DECLARE @Date datetime
Select @Date = MIN(Date) from Sessions where IsNull(ManagedObject, N'') <> N''
execute [dbo].[sp_netwrix_DatabaseMaintenance] @Date, 0
3. Execute this script. All audit data collected before the upgrade will be deleted automatically.
Was this information helpful?