How do I identify the oldest record in the ChangeAuditor Database without running a report
A Change Auditor Administrator may wish to find the oldest record in the Change Auditor database, however, running a report that would return all events, which would take too much time and resources because of the high number of records in the database.
The following SQL script, executed in SQL Management Studio will return the date of the oldest record:
FROM dbo.AuditEvent AS AET WITH(NOLOCK) WHERE AET._id IN (
SELECT _id FROM AuditEvent_IX_SeverityID WITH(NOLOCK)