Comments
-
Creating a table widget to display the current value and the value 24 hours ago for a UnDP assigned to a node.
-
Thank you KMSigma for this tip. However, the ordered by clause changes CureentValue and RawSataus to be the same. In this query what does the ordered by clause do?
-
I fixed it with this change to the original query. SELECT TOP 1 [OnNode].Node.Caption , [OnNode].Node.DetailsUrl , [OnNode].ID , [OnNode].CustomPollerName , [OnNode].CurrentValue , [OnNode].CustomPollerStatistics.DateTime , [OnNode].CustomPollerStatistics.RawStatus FROM Orion.NPM.CustomPollerAssignmentOnNode AS [OnNode]…
-
Yes, I commented out these two lines and now it works. SELECT TOP 1 [Node].Caption , [Node].DetailsUrl , [Node].CustomPollerAssignmentOnNode.ID , [Node].CustomPollerAssignmentOnNode.CustomPollerName , [Node].CustomPollerAssignmentOnNode.CurrentValue --, [Assign].CustomPollerStatistics.DateTime -- ,…
-
Yes, thank you very much
-
Yes, the last 24 hours would be good. I need to compare two values, the current value and the last 24 hours value.
-
Cool, that worked Thank you
-
Thank you for this information. However, how would I format this SWQL statement for use in the alert email message?
-
Cool, I may use this as we have a user that would like the same thing. I use the same room alerts and this is how I have been able to get the Fahrenheit reading for the internal Temperature. Hope this helps.
-
Yes, for a server that is up.