[SOLVED] List machines not seen since a certain date

[sfonteneau]

Code: Select all

SELECT h.uuid,h.computer_fqdn,install_date::date,version,h.listening_timestamp::timestamp,h.connected_users from hostsoftwares s
left join hosts h on h.uuid=s.host_id
where
 s.key='WAPT_is1'
and
 h.listening_timestamp<'20190115'                                    

Modify h.listening_timestamp<'20190115' for a specific date

[Mathieu]

Hello,

I wanted to know if this query works correctly for you because for a little while now I have been getting an error during execution.

[sfonteneau]

Indeed, it no longer works after an update

listening_timestamp no longer exists, so I used last_seen_on

Code: Select all

SELECT h.uuid,h.computer_fqdn,install_date::date,version,h.last_seen_on::timestamp,h.connected_users from hostsoftwares s
left join hosts h on h.uuid=s.host_id
where
 s.key='WAPT_is1'
and
 h.last_seen_on<'20230101'                     
 

[julien.guyonnet]

Good morning,

For a dynamic date 'D - 45 days'

Code: Select all

h.last_seen_on<TO_CHAR(CURRENT_DATE - 45, 'yyyymmdd')

Is it possible to use this query to filter the inventory tab?