working on deploying this now. working out some data integrity issues and i'm not using the built in reports. made my own. here is an example for any databases that haven't been backed up in the last 7 days.

select server_name as Server_Name, dbname as Database_Name, max(backup_finish_date) as Backup_End_Time, Backup_Type =

case type

when 'D' then 'Full backup'

when 'I' then 'Differential Backup'

when 'L' then 'Transaction Log Backup'

when 'F' then 'filegroup Backup'

when 'G' then 'Differential File backup'

else 'See Books Online'

end

from backupset_dim

where dbname not in ('master', 'msdb', 'ReportServer', 'ReportServerTempDB', 'pubs', 'Northwind', 'model')

and dbname not in (select dbname from db_exclude_dim)

and Type = 'D'

and backup_finish_date > '2009-01-01'

and server_name not in ('xxx', 'xxx4', 'xxx', 'xxx', 'xxx', 'xxx', 'xxx', 'xxx', 'xxx')

group by dbname, server_name, Type

having max(backup_finish_date) < getdate() -7

order by server_name, database_name