UIM UMP User Activity Report

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

UMP user login and logout audit history activity. There is no out-of-the-box/canned report but you can query the UMP tables and obtain a solid basic report.

Environment

Release: UIM 8.x to 20.1
Component: UMP

Resolution

For example:

SELECT "umpSession"."user_id", "umpSession"."login", "umpSession"."logout" FROM "CA_UIM"."dbo"."umpSession" "umpSession" WHERE ("umpSession"."login">={ts '2019-10-14 00:00:00'} AND "umpSession"."login"<{ts '2019-10-21 00:00:00'}) ORDER BY "umpSession"."user_id"

For UMP login/logout information, please refer to the umpsession and User_ tables, e.g.,

select user_id, remote_addr,login,logout from umpsession order by logout ASC

select screenName,emailAddress,loginDate,lastLoginDate from User_

For a report on inactive users that have not logged in over the past 90 days you can test using a query like this:

select screenName,emailAddress,loginDate,lastLoginDate from User_ where lastLoginDate < '2020-04-17 00:00:00'

Additional Information

For tracking LIVE users, please refer to:

C:\Program Files (x86)\Nimsoft\probes\service\wasp\webapps\ROOT\WEB-INF\classes

portal-ext (PROPERTIES FILE)

Below is the Live Users parameter which you will need to add to the existing file (at the bottom):

live.users.enabled=true

Save and restart the wasp.

Then go to UMP -> Portal -> Control Panel -> Monitoring

You will be able to view all LIVE users there.

Other:

Query User_ table for last login for active users

select screenName,jobTitle,loginIP,loginDate,lastLoginDate

from User_

where lastLoginDate >= '2020-04-01 00:00:00' and status != '5'

Note that in Liferay that in the status column for a user, their status is signified as 0 = active and 5 = deactivated.