History of login's to UMP

[Daniel Blanco]

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...

[Daniel Blanco]

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=[e-mail], 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=[e-mail], 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=[e-mail], 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?

[Kathy Maguire]

Daniel -

 

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

 

KB000034331 : UMP User Activity Report

[Daniel Blanco]

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