How do I identify the oldest record in the ChangeAuditor Database without running a report (4219921)

立即与支持人员聊天

反馈已提交

本文是否解决了您的问题？

选择评级

标题

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:

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)

)

)

反馈已提交

本文是否解决了您的问题？

选择评级

建议的内容

标题