DX Infrastructure Management

Expand all | Collapse all

History of login's to UMP

Jump to Best Answer
  • 1.  History of login's to UMP

    Posted 07-25-2018 05:01 PM

    Is there a table or a log that keeps track historically of who and when folks logged into the UMP?

    I was asked for Audit purposes and I can't seem to find anything in the community here nor in support case files. 

    Anyone have any idea here?

    TIA...



  • 2.  Re: History of login's to UMP

    Posted 07-25-2018 05:32 PM

    Looking at the wasp.log the only entries that i think pertain to a user logging are these lines:

     

    Line 290827: Nov 30 00:02:19:755 INFO [http-bio-80-exec-10, com.ca.cabi4uim.service.SessionUserService] SUCCESSFUL AUTHENTICATION: SessionUser="SessionUser{userType=NIMBUS, userName=dblanco@alphaserveit.com, origins=null, accountName=null, accountId=null, locale=en}",sid="null",RemoteAddr="10.#.#.#",RemoteHost="10.#.#.#"

     

    Line 290828: Nov 30 00:03:25:747 INFO [http-bio-80-exec-15, com.ca.cabi4uim.service.SessionUserService] SUCCESSFUL AUTHENTICATION: SessionUser="SessionUser{userType=NIMBUS, userName=dblanco@alphaserveit.com, origins=null, accountName=null, accountId=null, locale=en}",sid="null",RemoteAddr="10.#.#.#",RemoteHost="10.#.#.#"

     

    Line 290829: Nov 30 00:03:29:706 INFO [http-bio-80-exec-10, com.ca.cabi4uim.service.SessionUserService] SUCCESSFUL AUTHENTICATION: SessionUser="SessionUser{userType=NIMBUS, userName=dblanco@alphaserveit.com, origins=null, accountName=null, accountId=null, locale=en}",sid="null",RemoteAddr="10.#.#.#",RemoteHost="10.#.#.#"

     

    Is this the only way if you have the wasp.log and look for the accounts login ID or email?



  • 3.  Re: History of login's to UMP
    Best Answer

    Posted 07-25-2018 05:37 PM

    Daniel -

     

    Does the following Knowledge Document provide you with the information you are looking for?

     

    KB000034331 : UMP User Activity Report



  • 4.  Re: History of login's to UMP

    Posted 07-26-2018 09:33 AM

    Thank you Kathy! This was what I was looking for. Just adding a few more SQL Queries that I modified:

     

    --Search for a specific Date Range
    SELECT *
    FROM "NimsoftSLM"."dbo"."umpSession" "umpSession"
    WHERE ("umpSession"."login">={ts '2017-01-01 00:00:00'} AND "umpSession"."login"<{ts '2018-07-26 00:00:00'}) ORDER BY "umpSession"."user_id"

     

    --Search by specific user ID
    SELECT login,logout,user_id,remote_addr FROM umpSession
    WHERE user_id like ('%dblanco%')
    ORDER BY login


    --The entire UMP User Login History Table: umpsession
    --select user_id, remote_addr,login,logout from umpsession

     

    --Full list of all UMP Users
    select screenName,emailAddress,loginDate,lastLoginDate from User_ order by screenName