Comments
-
Thank You!!!! Question: Do you have link or YouTube I can reference for training?
-
A bit more information: I wrote the following code, but it only works for SQL, not SWQL. SELECT Nodes.Caption AS [Node Name], Events.EventTime AS [Start of Downtime], (SELECT TOP 1 EventTime FROM Events AS EndEvent WHERE EndEvent.NetworkNode = Events.NetworkNode AND EndEvent.EventTime > Events.EventTime AND…