The harvest user account login info

Document ID : KB000098897
Last Modified Date : 31/05/2018
Show Technical Document Details
Introduction:
I have auditor asking about the 'harvest' account in Harvest. They want to see any login history. What query would provide this information?
Environment:
CA Harvest SCM all versions and platforms
Instructions:
if you want to see login history for a specific user, the audit log is a better place to look.

This query would provide this information.

SELECT HARAUDITLOGVIEW.AUDITEVENTOBJID, 
HARAUDITLOGVIEW.ACTIONNAME, 
HARAUDITLOGVIEW.SUCCESSFAILURE, 
TO_CHAR(HARAUDITLOGVIEW.EVENTTIME, ‘mm/dd/yyyy hh:mi:ss’) EVENTTIME, 
HARAUDITLOGVIEW.USERNAME 
FROM HARAUDITLOGVIEW 
WHERE HARAUDITLOGVIEW.ACTIONNAME = 'Login user' 
AND HARAUDITLOGVIEW.USERNAME = 'harvest'  /* <--- userid you are searching for goes here */