topic Re: dql query for server uptime in DQL

dql query for server uptime

akashsaini — Wed, 22 Jan 2025 06:26:38 GMT

Any one help dql query for system uptime?

Re: dql query for server uptime

Etienne1 — Wed, 22 Jan 2025 08:14:43 GMT

Hello,

you should try this

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

Re: dql query for server uptime

akashsaini — Wed, 22 Jan 2025 08:38:25 GMT

Thanks Etiennet,.

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

Re: dql query for server uptime

Etienne1 — Wed, 22 Jan 2025 08:40:35 GMT

you need to add osType in the fields

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

Re: dql query for server uptime

akashsaini — Wed, 22 Jan 2025 08:47:45 GMT

Thanks,

and can we filter out by management zone?

Re: dql query for server uptime

Etienne1 — Wed, 22 Jan 2025 08:55:40 GMT

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

Re: dql query for server uptime

akashsaini — Wed, 22 Jan 2025 09:16:35 GMT

Thanks all good