This is a script I run periodically to identify databases with no backup. I started running this because I once encountered a remote application that was creating databases which, caused a failure in a log backup job. So I’ve been running this ever since just in case a database is created out of left field or maybe was omitted from a backup job.