Checking who added whom to what group in CA Harvest SCM

Products

• CA Harvest Software Change Manager

Issue/Introduction

This article gives a method for CA Harvest SCM admins to check adding members to groups history. 

Environment

CA Harvest SCM all versions

Resolution

On SCM broker machine, from command prompt

hsql -b <brokername> -prompt
Please enter your CA Harvest SCM username and password.
USERNAME:  *******
PASSWORD:  *******
Enter SQL command:
SELECT HARAUDITLOGVIEW.AUDITEVENTOBJID,
  HARAUDITLOGVIEW.ACTIONOBJID,
  HARAUDITLOGVIEW.SUCCESSFAILURE,
  HARAUDITLOGVIEW.ACTIONNAME,
  HARAUDITLOGVIEW.EVENTTIME,
  HARAUDITLOGVIEW.USROBJID,
  HARAUDITLOGVIEW.USERNAME,
  HARAUDITLOGVIEW.RESOURCEOBJID,
  HARAUDITLOGVIEW.RESOURCENAME,
  HARAUDITLOGVIEW.EVENTDESCRIPTION
FROM HARAUDITLOGVIEW
WHERE HARAUDITLOGVIEW.ACTIONNAME = 'Create user group membership'