• Nice Nicholas!

    I use similar queries to prioritize what is going to be done during my maintenance windows.

    DBCC CHECK the DBs that haven't been done in a while or ever. Same goes for the restore testing.

    I also setup a "Reporting" sql agent job to send me emails every morning (If needed). One of the steps

    reports missing backups.

    Thanks for sharing!