User last connect date and time in Syclo Work Manager 6.1 on SMP

[sravanthi_polu]

Hi Experts,

We are trying to find out last connect date and time of the user from Work Manager application.We have checked in /n/syclo/adimn , but the options verified only contains the date and time when the user has first registered or logged in to the app from device.Kindly let us know if there are any other options to get the required information.

Thanks in advance.

Regards,

Sravanthi.

[jorismermans]

Hi Sravanthi,

Another option is to check in DB table /SYCLO/SYSLOG001 in backend, filter by CREATED_BY and select the record with the latest timestamp..

Data is retained for e.g. 30 days or longer(depends on scheduled report /SYCLO/CORE_SYSSTAT_PURGE_PROG)

Regards,

Joris

[bill_froelich]

In the SMP3 database there should be a table named agentry_cluster_user_audit that I believe will contain what you are looking for. Check that out as a starting point.

--Bill