CMDBuild Forum

User Last Login data (time)

Users
#1

Hi Community,

Is it possible to find the value “LastLogin” in the CMDBuild database? I would like to know the table name and filedname containing this value.

Kind regards,

Frans Erich

#2

May be "_Session"."LoginDate"?

1 Like
#3

Thanks again Marina, Bit this holds only the information of the current date. I’m looking for the last session dates of all users. So I can see who is using the application and who is not.

#4

you can see which users logged in by using this query on _EventLog (e.g. all users’ sessions from 01-12-2023)

SELECT * FROM public."_EventLog" WHERE “_EventLog”.“User” != ‘system’ AND “_EventLog”.“User” != ‘anonymous’ and “_EventLog”.“Timestamp” > ‘2023-12-01’
ORDER BY “Timestamp” DESC

2 Likes
#5

Thank you very much Oriche. This is exactly what I’m looking for.