Retrieve community version posts
Published: January 15, 2020 - 3:43 PM
Good morning,
A small but useful query to retrieve the machines with the Community version agent.
Sincerely,
Matthieu Courtois
A small but useful query to retrieve the machines with the Community version agent.
Code: Select all
SELECT h.uuid,h.computer_name,install_date::date,version,h.listening_timestamp::timestamp,name from hostsoftwares s
left join hosts h on h.uuid=s.host_id
where
s.key='WAPT_is1'
AND (name ilike 'WAPT%%Community%%' OR name ilike 'WAPT %%')
Matthieu Courtois