Last Database Backups for all databases

SELECT Bk1.server_name AS [Server_Name]
  ,Bk1.database_name AS [Database_Name]
  ,MAX(Bk1.backup_finish_date) AS [Last_Backup]
  ,MAX(CASE WHEN Bk1.type = 'D' THEN Bk1.backup_finish_date ELSE NULL END) AS [Last_Full_Backup]
  ,MAX(CASE WHEN Bk1.type = 'I' THEN Bk1.backup_finish_date ELSE NULL END) AS [Last_Diff_Backup]
  ,MAX(CASE WHEN Bk1.type = 'L' THEN Bk1.backup_finish_date ELSE NULL END) AS [Last_Log_Backup]
  ,Bk2.NAME AS [Backup_Set]
  ,DATEDIFF(d, (max(Bk1.backup_finish_Date)), GETDATE()) AS [Days_Since_Last_Backup]
FROM msdb.dbo.backupset AS Bk1
INNER JOIN msdb.dbo.backupset AS Bk2 ON Bk1.backup_set_id = Bk2.backup_set_id
GROUP BY Bk1.database_name ,Bk1.server_name ,Bk2.NAME
ORDER BY database_name;

Database Backups for all databases For Previous Week

SELECT CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS server_name
  ,msdb.dbo.backupset.database_name
  ,msdb.dbo.backupset.backup_start_date
  ,msdb.dbo.backupset.backup_finish_date
--,msdb.dbo.backupset.expiration_date
  ,CASE msdb..backupset.type
    WHEN 'D' THEN 'Full_Backup'
	WHEN 'I' THEN 'Diff_Backup'
    WHEN 'L' THEN 'Log_Backup'
    END AS backup_type
  ,round(msdb.dbo.backupset.backup_size / 1024 / 1024, 1) AS backup_size_mb
--,msdb.dbo.backupmediafamily.logical_device_name
  ,msdb.dbo.backupmediafamily.physical_device_name
--,msdb.dbo.backupset.NAME AS backupset_name
--,msdb.dbo.backupset.description
FROM msdb.dbo.backupmediafamily
INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
WHERE (CONVERT(DATETIME, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 7)
--AND msdb..backupset.type <> 'L'
ORDER BY msdb.dbo.backupset.database_name
  ,msdb.dbo.backupset.backup_finish_date;