Is there any way to get the list of deleted files daily from CA SCM ?
Document ID : KB000012723
Last Modified Date : 14/02/2018
 Show Technical Document Details
Question:

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

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() - 1 AND GETDATE()
AND HARAUDITLOGVIEW.ACTIONNAME  = 'Delete version'