How do I write an Archive/Purge query to purge audit records older than 90 days?
If todays date is 9/21/2012, you will need to use RSA_Date < ‘6/21/2012’
There is no automated way to do this inside of Auditor currently, so someone will need to manually do this every day. However, if you want to run a process in SQL to automate it with a job instead, you can do so with a WHERE clause:
RSA_Date < (GETDATE() – 90)
SQL has a GETDATE() function that returns today.