Script Download: CheckBackuptoSingleFile.ziphttp://gallery.technet.microsoft.com/scriptcenter/Check-database-backups-a38c64a7
We can use Get-OSCBackupToSingleFile to identify the database backups appended to existing backup devices and then list the affected databases. By default, this script uses Windows Authentication to connect to your SQL Server. If you want to use SQL Server Authentication, just uncomment some code in this script.
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery