Would like to know when was last backed up Database?

-- List of all Backup of data
SELECT Database_Name, CONVERT( SmallDateTime , MAX(Backup_Finish_Date)) as Last_Backup, DATEDIFF(d, MAX(Backup_Finish_Date), Getdate()) as Days_Since_LastFROM MSDB.dbo.BackupSetWHERE Type = 'd'GROUP BY Database_NameORDER BY 3 DESC
-- Find the backup of Transaction Log files
SELECT Database_Name, CONVERT( SmallDateTime , MAX(Backup_Finish_Date)) as Last_Backup, DATEDIFF(d, MAX(Backup_Finish_Date), Getdate()) as Days_Since_LastFROM MSDB.dbo.BackupSetWHERE Type = 'l'GROUP BY Database_NameORDER BY 3 DESC