jmpenney01

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.