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

Chatee ahora con Soporte

Regresar

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Título

How do I identify the oldest record in the ChangeAuditor Database without running a report
Descripción

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.
Resolución

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)

)

)

Comentarios enviados

¿Este artículo solucionó su problema?

Seleccionar calificación

Contenido recomendado

Historial del artículo:: Creado el: 2/10/2015
Última actualización: 4/2/2024

Título