Last date users have logged into Applications Mananger

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Is there a sql or report to find a list of users and their last time they logged into Applications Manager?

Environment

Applications Manager 9.x

Resolution

While an out of the box Report is not available, the following sql can be run:

select so_user_name, so_last_activity from so_user_table;