need assistance with user audit

Products

• CA Harvest Software Change Manager
• CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

Need to have representation of users logged in currently or at peak. Query against DB only shows last logged in. Is there a way to represent logoff time in query?

Environment

Release : 12.6, 13.x

Component : CA Harvest Software Change Manager

Resolution

Currently there is no table/view that you can view/select to see the logout time of a user login. The only log out info is in the broker log file and somehow you would need to read/sort to get the logout time. There are some unsupported script that can monitor the user log in/out. For example, HLoginMon
https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=c7eb7b54-47fa-46cf-bd53-7e14b750fac4&CommunityKey=875def62-85de-4797-9dc1-7a31010427b8&tab=digestviewer#bmc7eb7b54-47fa-46cf-bd53-7e14b750fac4
As you may already aware, with action "Login user", and its event time, you could report on HARAUDITLOGVIEW to see who logs in at certain time, how many users logged in during certain time period etc