New User Report

book

Article ID: 129562

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

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

Environment

CA Harvest SCM all versions and platforms

Resolution

Try this:
 
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'