I have been frequently asked when the last time a DEV or QA database was refreshed from PROD.
select
h.restore_date,
h.destination_database_name,
b.backup_finish_date,
b.type,
b.server_name
from msdb.dbo.RestoreHistory h
join msdb.dbo.BackupSet b on h.backup_set_id = b.backup_set_id
order by restore_date desc
