dql query for server uptime

[akashsaini]

Any one help dql query for system uptime?

[Etienne1]

Hello, 

you should try this

fetch dt.entity.host
| fieldsAdd lifetime
| fields uptime = lifetime[end] - lifetime[start], entity.name, id

[akashsaini]

Thanks Etiennet,.

We also require OS type information (Like -Windows and Linux)

[Etienne1]

you need to add osType in the fields 

fetch dt.entity.host
| fieldsAdd lifetime
| fields uptime = lifetime[end] - lifetime[start], entity.name, id, osType

[akashsaini]

Thanks,

and can we filter out by management zone?

[Etienne1 · Accepted solution]

Yes, change [PROD] ALL by the name of your management zone

fetch dt.entity.host
| filter matchesvalue(managementZones,"[PROD] ALL")
| fieldsAdd lifetime
| fields uptime = lifetime[end] - lifetime[start], entity.name, id, osType

[akashsaini · Accepted solution]

Thanks all good