Hello everyone!
I was looking for a report in UCM to be able to display who has logged in and when to which Data Base but I could not find it. Does anyboday know if such report exists or if this needs to be created from scratch ?
Thanks !
Hello everyone!
I was looking for a report in UCM to be able to display who has logged in and when to which Data Base but I could not find it. Does anyboday know if such report exists or if this needs to be created from scratch ?
Thanks !
¡Buenas tardes David!
There is no single report for this purpose, only several different sources:
1. you can export user statistics from ARIS Connect UMC for the events login successful including timestamps as a CSV file if
2. the server administrator tool arisadm command sessions shows logins per DB, but without timestamps. You would need to repeat this call frequently to collect snapshots in a log file.
3. you can evaluate loadbalancer's httpd access logs in
\server\bin\work\work_loadbalancer_m\httpd\logs,
but they show only the client IP, not the user id.
Or you try to adopt Thierry's solution with an event driven macro logging user infos when they open a database (see Script Help EVENTID_DATABASE_CONNECTED)
Regards, Martin
¡Buenas tardes David!
There is no single report for this purpose, only several different sources:
1. you can export user statistics from ARIS Connect UMC for the events login successful including timestamps as a CSV file if
2. the server administrator tool arisadm command sessions shows logins per DB, but without timestamps. You would need to repeat this call frequently to collect snapshots in a log file.
3. you can evaluate loadbalancer's httpd access logs in
\server\bin\work\work_loadbalancer_m\httpd\logs,
but they show only the client IP, not the user id.
Or you try to adopt Thierry's solution with an event driven macro logging user infos when they open a database (see Script Help EVENTID_DATABASE_CONNECTED)
Regards, Martin
Guten Aben Martin!
It seems there is not an easy way to control this then - Thanks for your suggestion though!
¡Con mucho gusto, David!
Or you create a feature request on ARIS Ideas to extend the UMC user statistics.
Just my two cents: Consult with your data protection officer regarding GDPR implications, before you ever implement such logging. If you have any users in Germany, the local works councils will need to be consulted in such matters.