How to check oldest event in Database? (4244408)

Please follow below steps to check oldest event in Change Auditor DB:

1. Login to SQL server where Change Auditor DB is hosted.

2. Open SQL server Management Stuido

3. Choose Change Auditor DB and click New Query.

4. Paste following query and execute:

Select MIN(AET.TimeDetected)

FROM dbo.AuditEvent AS AET WITH(NOLOCK) WHERE AET._id IN (

                            SELECT _id FROM AuditEvent_IX_SeverityID WITH(NOLOCK)  

                            where [_date_hh] = (

                                                              SELECT MIN([_date_hh])

                                                              FROM AuditEvent_IX_SeverityID WITH (NOLOCK)

                                                              )

                           )

This will tell you date and time from when till today, you have events.