search cancel

UIM UMP User Activity Report


Article ID: 34331


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


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.


Release: UIM 8.x to 20.1
Component: UMP


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):


Save and restart the wasp.

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

You will be able to view all LIVE users there.


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.

Related Articles:

UMP login / logout and admin functions performed auditing

UIM 20.3.x

UIM 20.3.x - Auditing Operator Console logins