Return
-
Title
Check how far back in time events are present on the Change Auditor live DB -
Description
How to check how far back in time the events on change auditor are stored on the CA database. -
Cause
There isn't a simple option to run on the CA client to check this other than run a search on all events that can take a very long time and is limited to 50000 events. -
Resolution
The solution is on a simple SQL query to run on the SQL Management studio against the Change Auditor database
1. Select the change auditor DB
2. Right-click and choose 'new query'
3. Type and execute the below query:
SELECT _date_hh
FROM AlertHistory;
This will give you a list of all the event dates in the database starting with the oldest.