Forum Tranquil IT

Code : Tout sélectionner

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 %%')