Hello,
There have been a few posts about using custom pollers in alerts and to generate alerts. I took a few of them and was able to pull in the data and get an alert functioning the way I want but it only works about 1/2 the time.
Node Description: ${SQL:SELECT CPS.Status FROM CustomPollerStatus AS CPS INNER JOIN CustomPollerAssignment AS CPA ON CPS.CustomPollerAssignmentID = CPA.CustomPollerAssignmentID INNER JOIN CustomPollers AS CP ON CPA.CustomPollerID = CP.CustomPollerID WHERE CP.UniqueName = 'svDescription' and CPA.NodeID = '$@NodeID@';}
About half the time I get the proper node description, the other half I get a message with the querey in it. Any idea why it would do that?
I saw somewhere that some one had used a stored procedure to copy UnDP data to a custom property. Is something like that ok to do? I'm guessing that since I don't store the historical data the querey is coming back incorrectly but if that was the case, I thought that it would have filled in the node id.
Thanks!
