[SOLVED] Improvement computer not seen since 30 days
Published: Dec 6, 2023 - 09:26
Good morning,
I suggest adding sorting by PC name to the existing query, which would give:
I suggest adding sorting by PC name to the existing query, which would give:
Code: Select all
SELECT computer_name, computer_fqdn, productname, computer_ad_ou, wapt_version, last_seen_on , TO_DATE(last_seen_on,'YYYY/MM/DD'), uuid
FROM hosts
where TO_DATE(last_seen_on,'YYYY/MM/DD') < CURRENT_DATE - INTERVAL '30< DAYS'
order by hosts.computer_name ASC