Deleted content

queries related to deleted content.

Find Deleted Content

Find all the deleted content in the repository.  This works well as long as the dm_Clean job has not run.  A technique for undeleting content will be the subject of a future post.

select * from dmr_content where any parent_id is NULL and content_size > 0 order by set_time;