System Up Time

I created a healthdash within Orion. I was trying to see if there is an entity or SWQL script that searches for the following:

NODE --> Custom Properties - Site is equal to XXX

NODE --> Custom Properties - Device_Type is equal to Switch

System Up Time is equal to or greater than 1 year

Find more posts tagged with

custom_properties

dashboard

uptime

npm

Accepted answers

All comments

Something like this should be what you are after

SELECT n.Caption, n.Lastboot, n.CustomProperties.Site, n.CustomProperties.DeviceType
FROM Orion.Nodes n
WHERE n.LastBoot < adddate('year',-1,getutcdate()) AND n.CustomProperties.Site = 'xxx' AND n.CustomProperties.DeviceType = 'Switch'

If it is, please mark as answered, to help others find the solution

i added what you provided and change the veritable to the site to what I am trying to query and got an error.

Your custom property is called Device_Type not DeviceType. (At least according to the info you put at the top of the message).

You'll also need to change your filter for Site to match whatever site you want to use.

Quick Links