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'