How do we make this work with 8.2 of the NQCCDB? There is a red
squiggly line under ModificationTime, DataSourceName,Computer,EventMsg,
EventID, Event1 and ParentEventID. What are the updated values?
Thanks.



set nocount on
Select dateadd(second,ModificationTime,'01-01-1970')
,DataSourceName
,Computer
,EventMsg
,ModificationTime
,EventID
from Event1
where
datediff(minute,dateadd(second,ModificationTime,'0 1-01-1970'),dateadd(HOUR,4,
GETDATE())) between 0 and 6
and Status = 0
and ParentEventID IS NOT NULL
set nocount off

WHICH GAVE AN EVENT IN THIS FORMAT IN A TEXT FILE:
2014-10-21 03:56:31.000,qdbserver.qdb,servername,One or more disks has
exceeded a threshold setting (D,1413863791,1404265


--
mcschall
------------------------------------------------------------------------
mcschall's Profile: https://forums.netiq.com/member.php?userid=4778
View this thread: https://forums.netiq.com/showthread.php?t=52052