There is a table, and view, in IC named LoginLogOutChangeLog and LoginLogoutChangeLog_viw that stores this information. To get the application name, the view references the ICApplications table. This table stores all of the Application Names from Session Manager. The columns of LoginLogoutChangeLog that store the data you are asking about are:
- ApplicationId
- ApplicationName (view only or joined to ICApplications)
- Action (1 = Login, 0 = Logout)
- ActionDateTime
- UserId
- Station
- ICServer (This is actually the PC name of the client accessing IC)
------------------------------
Sean Walls
------------------------------
Original Message:
Sent: 05-22-2019 15:20
From: William Martín Chávez González
Subject: PureConnect - Logged In - IC User reports
Good morning community:
In PureConnect (I3_IC) database, or in ICBM or in other reports we can query a login log that describes the list of users and the time they logged in in ICBM or another IC Applications? For example a log like this:
"user1 logged at 22nd, may, 2019, 8:00 AM in ICBM.
"administrator1 logged at 21st, may, 2019, 9:00 AM in Interaction Administrator".
Thanks.
#Reporting/Analytics
------------------------------
William Martín Chávez González
Global Networks Solutions S.A.
------------------------------