Hi all,
I need to create a column in my dashboard (Modern dasbboard) showing the time for how long the node was down in hourse (example: down from 3 hours)
Ian using the following SWQL to get my dasborad
SELECT n.Caption,n.CustomProperties.GroupName AS CustomProperties_GroupName,n.Status,n.LastSystemUpTimePollUtc,n.IP_Address
FROM Orion.Nodes n
WHERE Status LIKE '%2%'
and (n.CustomProperties.GroupName LIKE '%Main%' or n.CustomProperties.GroupName LIKE '%DR%')

I would realy apprecate if you can help me chang the LastSystemUPTime column to somthin like down since.
Thanks
Mohanad