Devtest Users Last Login Info

Products

• Service Virtualization

Issue/Introduction

Is there a way by which we can get the last login(last used) info of a user who has performed any activity on registry? 

Environment

Devtest all versions

Resolution

  Use below query to retrieve the user login details. This query has to be executed on database used by registry component.

select MAX(TIMESTAMP_TS) LAST_LOGIN_DATE, USER_UNIQUE_ID USER_ID from ACL_AUDIT_LOG where activity_name='Logon'  group by  USER_UNIQUE_ID

  If there are multiple registries in your environment, we need to execute this query on each registry database to get the user logon details.