configure down since columnn for nodes in modern dashboards

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

Parents Reply Children
No Data