CMDBuild Forum

User activity logs?

Systems Engineering
#1

Hi,

Is there a way to monitor user activity logs? The type of activity I want to monitor is who creates / updates / deletes assets.

Maybe the postgres _EventLog table contains this information?

Thank you

Olivier

#2

Hi,

Have you considered the history tables of each class? IIRC they are called CLASSNAME_history. I think this is used to to show the history data in the interface, although I have not looked at this in detail since the changes made in 3.x.

Hth

Mark

#3

Thanks Mark, this is of interest but this is not exactly what I am looking for.
I am just interested in an overview of user activity over a period of time without having to go to each class’ history.

I found that I can see which users logged in by using this query on _EventLog (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

image

At least it gives me an indication users’ activity

Best wishes

Olivier