Como la HAT no es la mejor herramienta del mundo, flexible si es, he modificado la consulta por defecto de las 100 últimas instancias para ir a un dia y hora en concreto, ya que realizar búsquedas de mensajes de hace mucho tiempo es una tarea ardua. Aqui os la copio:
-- MODIFICAR DIA, MES, AÑO y HORA
SELECT top 100
[Service/Name], [Service/Type],
[ServiceInstance/State],
dateadd(minute, @UtcOffsetMin, [ServiceInstance/StartTime]) as [StartTime], -- can't use 'as [ServiceInstance/StartTime]' since this prevents SQL from using index on that column (conflicts with ORDER BY)
dateadd(minute, @UtcOffsetMin, [ServiceInstance/EndTime]) as [EndTime], -- can't use 'as [ServiceInstance/EndTime]' since this prevents SQL from using index on that column (conflicts with ORDER BY)
[ServiceInstance/Duration],
[ServiceInstance/ExitCode],
[ServiceInstance/ErrorInfo],
[ServiceInstance/Host],
[Service/AssemblyName],
[ServiceInstance/InstanceID],
[ServiceInstance/ActivityID],
[Service/ServiceGUID],
[Service/ServiceClassGUID]
FROM dbo.dtav_ServiceFacts sf WITH (READPAST)
WHERE day(sf.[ServiceInstance/StartTime]) = 14 and
month(sf.[ServiceInstance/StartTime]) = 12 and
year(sf.[ServiceInstance/StartTime]) = 2006 and
datepart(hh, sf.[ServiceInstance/StartTime]) = 17
ORDER BY sf.[ServiceInstance/StartTime] desc