Create a report of nodes not reachable for more then 60 days

Question

Hello,

Is it possible to create a report that shows nodes not reachable for more then 60 days.

Kind regards,

John

JaroslawLadyga · Answer

Hi, try below SWQL query for data source (I modified the one I found in my environment) of the report:

SELECT

n.Status as [STATUS],

n.Caption as [NODE],

n.IPAddress as [IP],

n.DetailsUrl,

n.LastSystemUpTimePollUtc as [LAST POLL],

n.PollInterval as [POLL INTERVAL in sec],

n.Vendor as [VENDOR],

n.ObjectSubType as [METHOD]

FROM Orion.Nodes AS n

WHERE DAYDIFF(n.LastSystemUptimePollUtc, GETUTCDATE())>60

AND n.Status = 12 -- 12 states for UNREACHABLE

ORDER BY n.LastSystemUptimePollUtc ASC

You may fit the fields as you wish.