Reporting - "Last connection" field

Share your SQL query ideas for reporting in the WAPT Enterprise console here
Forum Rules
Community Forum Rules
* English support on www.reddit.com/r/wapt
* French community support is available on this forum
* Please prefix the topic title with [RESOLVED] if it is resolved.
* Please do not edit a topic that is tagged [RESOLVED]. Open a new topic referencing the old one.
* Specify the installed WAPT version, full version, and build number (2.2.1.11957 / 2.2.2.12337 / etc.) as well as the Enterprise/Discovery edition.
* Versions 1.8.2 and earlier are no longer supported. The only questions accepted regarding version 1.8.2 are related to upgrading to a supported version (2.1, 2.2, etc.).
* Specify the server OS (Linux/Windows) and version (Debian Buster/Bullseye - CentOS 7 - Windows Server 2012/2016/2019).
* Specify the OS of the administration/package creation machine and the machine with the problematic agent, if applicable (Windows 7/10/11/Debian 11/etc.).
* Avoid asking multiple questions when opening a topic, otherwise it may be ignored. If there are multiple topics, open separate topics, preferably one after the other and not all at the same time (i.e., do not spam the forum).
* Include code snippets, screenshots, and other images directly in the post. Links to Pastebin, Bitly, and other third-party sites will be systematically removed.
* As with any community forum, support is provided voluntarily by members. If you require commercial support, you can contact Tranquil IT's sales department at 02.40.97.57.55
Locked
lutech
Messages: 4
Registration: February 22, 2022 - 10:27

July 6, 2022 - 11:19

Hello,

I'm trying to identify the SQL field "Last Connection" (image attached) so I can create a report listing the last connection dates of the PCs.

Thank you.
Attachments
2022-07-06 11_17_43-Clipboard.png
2022-07-06 11_17_43-Clipboard.png (17.99 KB) Viewed 11455 times
User avatar
t.heroult
Messages: 307
Registration: December 8, 2020 - 10:13 AM

November 4, 2022 - 1:59 PM

Good morning
Right-clicking on the tab bar gives you a list of displayable items and their names; that should help.
2022-11-04 13_57_36-.png
2022-11-04 13_57_36-.png (15.67 KB) Viewed 10135 times
Server: WAPT Enterprise 2.6.1.17786 on Debian
Consoles: Windows 10 & 11
Infrastructure: Windows

Did you know? When parrotfish undergo smoltification, their osmoregulation mechanism is reversed!
User avatar
dcardon
WAPT Expert
Messages: 1929
Registration: June 18, 2014 - 09:58
Location: Saint Sébastien sur Loire
Contact :

November 8, 2022 - 4:22 PM

Hello everyone,

this value update is likely to change soon. WebSocket updates have been moved to RAM-only mode to avoid overly frequent updates. We'll see if we can maintain batch synchronization of the column every few minutes to ensure backward compatibility.

Regards,

Denis
Denis Cardon - Tranquil IT
Share your experiences on WAPT! Send us your blog and article URLs in the "Your Opinion of the forum, and we'll feature them on the WAPT
Locked