Comments
-
below query not working
-
SELECT [Nodes].Caption AS [Node] , [Nodes].DetailsURL AS [_LinkFor_Node] , [Nodes].Status AS [Status] , [Nodes].CustomProperties.Ownership AS [Owner] , ToLocal([AlertObjects].AlertActive.TriggeredDateTime) AS [Down Time] , CASE WHEN TOSTRING(FLOOR(HOURDIFF([AlertObjects].AlertActive.TriggeredDateTime,GETUTCDATE())/24)) <>…
-
We need monthly report hence what is the timeframe we need to change please guide the same