How to find projects which have been restored from backups

Running this SQL query from the VenioPCD will check the MasterAuditLog table for restored projects. The project name will be in the DisplayLog field.




select * from tbl_lg_MasterAuditLog where Module = 'Backup Restore' and DisplayLog like 'Restore project%'