Finding who added a new user to Harvest

Products

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

Issue/Introduction

We need to be able to find out which user added a new user to the Harvest database.

Environment

CA Harvest SCM ll versions and platforms

Resolution

Here is a quick query that will answer the question:
 
For Oracle database:

SELECT HARUSER.USROBJID,
  HARUSER.USERNAME,
  CREATOR.USERNAME AS CREATORNAME,
  TO_CHAR(HARUSER.CREATIONTIME,'mm-dd-yyyy hh:mi:ss') AS CREATIONTIME
FROM HARUSER
INNER JOIN HARUSER CREATOR
ON HARUSER.CREATORID = CREATOR.USROBJID
WHERE HARUSER.USERNAME = 'testuser1'  /* <--- Type the userid of the user you want to know about here */

For SQL Server database:

SELECT HARUSER.USROBJID,
  HARUSER.USERNAME,
  CREATOR.USERNAME AS CREATORNAME,
  HARUSER.CREATIONTIME
FROM HARUSER
INNER JOIN HARUSER CREATOR
ON HARUSER.CREATORID = CREATOR.USROBJID
WHERE HARUSER.USERNAME = 'testuser1'  /* <--- Type the userid of the user you want to know about here */
 

Additional Information

More information on the Harvest Audit Log can be found here: Administrate Data - Audit Log