The report generator can help you out as well. Here's a report that lists all deleted files, sorted by file extension. @[ListDeleted] §Name [All deleted files sorted by file type] §Company [CADForum] §Description [This query will list all deleted files, sorted by file extension.] §Version [1.1] §Ar...

I have a SQL script that runs each day that sends an email to users that have files checked out greater than 3 days. If you use this as shown below you will need to create a new table to log when emails are sent. Mine is listed as reporting.dbo.EmailsDelivered below. /* Email Checked Out Summary Th...