topic Re: Get List of Servers Recently Added in DQL

Get List of Servers Recently Added

t_thi — Wed, 05 Mar 2025 14:28:24 GMT

Hi all,

Fairly useless with DQL, so wondering if anyone know how we can grab a list of servers which have recently had OneAgent installed. This is something we can see in Deployment Status App, but I can't open it in other apps such as Notebooks to grab the DQL

Many thanks!

Re: Get List of Servers Recently Added

p_devulapalli — Thu, 06 Mar 2025 00:00:20 GMT

@t_thi Please try below and look for the start date in the lifetime field. lifetime field stores the first and last observation timestamp of an entity

fetch dt.entity.host | fieldsAdd lifetime | sort lifetime desc

Re: Get List of Servers Recently Added

t_thi — Fri, 07 Mar 2025 09:25:14 GMT

That's worked great thanks for your time and help @p_devulapalli!