Last full, differential and log backup per database

1SELECT d.name AS database_name, d.recovery_model_desc,2       MAX(CASE WHEN b.type = 'D' THEN b.backup_finish_date END) AS last_full,3       MAX(CASE WHEN b.type = 'I' THEN b.backup_finish_date END) AS last_diff,4       MAX(CASE WHEN b.type = 'L' THEN b.backup_finish_date END) AS last_log5FROM sys.databases d6LEFT JOIN msdb.dbo.backupset b ON b.database_name = d.name7WHERE d.name <> 'tempdb'8GROUP BY d.name, d.recovery_model_desc9ORDER BY last_full;