[SOLVED] Improvement computer not seen since 30 days

[Gaetan]

Good morning,

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

[dcardon]

Hi Gaëtan,

how are things going up there in the southwest?

Thanks for the update. We've updated the SQL query template internally; it should be updated online soon if it isn't already.

See you soon,

Denis