New User Report
Article ID: 129562
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'
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'
Feedback
Yes
No
Powered by
