Where is the active user information stored in the Applications Manager database?

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Where is the active user information stored in the Applications Manager database?

Environment

Release : 9.4.x

Resolution

The user information is stored in the so_user_table. A simple select such as below to query the user name and if the user is active or not.

SQL>select so_user_name "USER", so_first_name, so_laste_name, so_active_flag "Active" from so_user_table;

There is also a report to track the user's log in activity for the past month. This can be viewed from the client gui by going to Object Admin>Development>Reports> UC4_CLIENT_LOGINS_REPORT>Show. The parameters can be altered to suit user's reporting needs.

Please note Broadcom Automic Support cannot provide custom sql reports. This information is provided to give basic insight on where the user information is stored. Please consult with a database administrator for specific query details.