I have auditor asking about the 'harvest' account in Harvest. They want to see any login history. What query would provide this information?
CA Harvest SCM all versions and platforms
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.
TO_CHAR(HARAUDITLOGVIEW.EVENTTIME, ‘mm/dd/yyyy hh:mi:ss’) EVENTTIME,
WHERE HARAUDITLOGVIEW.ACTIONNAME = 'Login user'
AND HARAUDITLOGVIEW.USERNAME = 'harvest' /* <--- userid you are searching for goes here */