Tranquil IT Forum

Good morning,

I'm trying to make a query that retrieves the version of a software program and the last connection date of the PC via the listening_timestamp field
However, this field only shows me the date 01/07, which corresponds to the migration date to Wapt Enterprise. When I go to one of the computers in the list and look at the listening_timestamp field in the hardware inventory, it correctly shows today's date.
I managed to work around the problem by using the last_seen_on field, but I'd really like to understand why and how?



I have the same problem with the predefined query "Connected Machines":


at one of the stations:



For your information, the request is:
select hosts.computer_name, hostsoftwares.name,hostsoftwares.version, hosts.listening_timestamp as "last_connection"
from hosts,hostsoftwares
where hostsoftwares.name ilike 'Cortex%%' and hosts.uuid=hostsoftwares.host_id
order by hosts.computer_name ASC

Hello Mathieu,
We need to change/delete/rename this column; the concept has changed with the switch to WebSockets. For your use case, I recommend using the value `last_update_status->date:`
Sincerely,
Denis

Hi Denis,

OK, thanks for the information, I'll modify my requests.

Mathieu