Hi,
I'm hoping that someone would be kind enough to help my modify this custom query please.
It displays all nodes within our environment with an uptime of greater than 30days, which is great except for the fact that Systemuptime is in seconds which makes it difficult to work with.
So
1) Could someone please help me add in a seconds to days conversion please? I know it would be 2592000/86400 but just not sure how to implement it into a query.
2) This is capturing All Nodes. Ideally we just want it to capture Servers which are recorded within our environment with a customproperty of Device_Type Server.
Any help would be greatly appreciated.
SELECT n.Caption, n.IP_Address, n.SystemUptime FROM orion.Nodes n
where n.systemuptime > 2592000
order by n.systemuptime desc