The most recent content from our members.
Here is my code: SELECT A.Caption, A.NodeID, B.CustomPollerAssignmentID, C.CustomPollerAssignmentID AS ID2, C.CompressedRowID, A.Vendor, C.Status FROM Orion.Nodes A JOIN Orion.NPM.CustomPollerAssignmentOnNode B ON B.NodeID = A.NodeID JOIN Orion.NPM.CustomPollerStatusOnNodeTabular C ON C.CustomPollerAssignmentID =…
Hi all, I'm trying to find a way to convert a TOSTRING value to a number so that in my reporting I can display "order by" correctly and not in text. ,case when ack.timestamp is null then 'N/A' else tostring(minutediff(ah.TimeStamp,ack.timestamp)+0) end as [Minutes Until Acknowledged] Thank you! A
It looks like you're new here. Sign in or register to get started.