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
Select the change auditor DB
Right click and choose new query
Type the below query
SELECT _date_hh
FROM AlertHistoryPress execute
This will give you a list of all the event dates in the database starting with the oldest.