New User Report

Products

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

Issue/Introduction

Is there a way for me to be able to create a report that shows how many new users have been added say over the last 90 days?

Environment

CA Harvest SCM all versions and platforms

Resolution

The audit log can provide this information.  Here is an example query for Oracle:

SELECT ACTIONNAME,
TO_CHAR(EVENTTIME, 'yyyy-mm-dd hh:mi:ss') AS EVENTTIME,
USERNAME AS CREATEDBY,
RESOURCENAME AS USERNAME_CREATED
FROM HARAUDITLOGVIEW
WHERE EVENTTIME >= SYSDATE-90
AND ACTIONNAME = 'Create user'

And the same for SQL Server would be:

SELECT ACTIONNAME,
EVENTTIME,
USERNAME AS CREATEDBY,
RESOURCENAME AS USERNAME_CREATED
FROM HARAUDITLOGVIEW
WHERE EVENTTIME >= CURRENT_TIMESTAMP - 90
AND ACTIONNAME = 'Create user'

Additional Information

More information about the Harvest Audit Log is found here: Administrate Data - Audit Log