Generate a list of files deleted today

Products

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

Issue/Introduction

Is there any way to get the list of deleted files daily from CA SCM ? 

Environment

Harvest Software Change Manager v12.x and higher

Resolution

We can only get the information that can provided by audit functionality. 

For Oracle:

SELECT HARAUDITLOGVIEW.ER2RESOURCENAME AS REPOSITORYNAME,
  HARAUDITLOGVIEW.ER3RESOURCENAME AS ITEMNAME,
  HARAUDITLOGVIEW.RESOURCENAME    AS ITEMVERSION,
  HARAUDITLOGVIEW.EVENTTIME,
  HARAUDITLOGVIEW.ACTIONNAME,
  HARAUDITLOGVIEW.USERNAME
FROM HARAUDITLOGVIEW
WHERE HARAUDITLOGVIEW.EVENTTIME BETWEEN SYSDATE - 1 AND SYSDATE
AND HARAUDITLOGVIEW.ACTIONNAME  = 'Delete version'

For SQL Server:

SELECT HARAUDITLOGVIEW.ER2RESOURCENAME AS REPOSITORYNAME,
  HARAUDITLOGVIEW.ER3RESOURCENAME AS ITEMNAME,
  HARAUDITLOGVIEW.RESOURCENAME    AS ITEMVERSION,
  HARAUDITLOGVIEW.EVENTTIME,
  HARAUDITLOGVIEW.ACTIONNAME,
  HARAUDITLOGVIEW.USERNAME
FROM HARAUDITLOGVIEW
WHERE HARAUDITLOGVIEW.EVENTTIME BETWEEN GETDATE()  AND GETDATE() + 1
AND HARAUDITLOGVIEW.ACTIONNAME  = 'Delete version'

Additional Information

For more information about the Harvest Audit Log, see the online documentation: Administrate Data - Audit Log