cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

SUMMARY - Intralink Delete History?

Highlighted
Regular Member

SUMMARY - Intralink Delete History?

All delete history is saved in the pdm.PDM_PIDELETE table.
With the following sql script you'll get a list of all deleted objects,
when they were deleted and most important who did it.
(could be a very long list, depending on your working habits in
Intralink)

set PAGES 0
set LINES 500
set TRIMSPOOL on
set HEAD off
set VERI off
select PIDPINAME||','||PIDPITYPENAME||','||MODIFIEDON||','||MODIFIEDBY
from pdm.PDM_PIDELETE


Use this line if you need to look for a specific object
select PIDPINAME||','||PIDPITYPENAME||','||MODIFIEDON||','||MODIFIEDBY
from pdm.PDM_PIDELETE where PIDPINAME='<objectname>'


Thanks to Thomas Oberhem and Abby Dawkins