PureConnect

 View Only
Discussion Thread View
  • 1.  PureConnect - Logged In - IC User reports

    Posted 05-22-2019 15:20
    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.
    ------------------------------


  • 2.  RE: PureConnect - Logged In - IC User reports

    Posted 05-24-2019 09:07
    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
    ------------------------------



Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources