T-SQL Script: Get Last Backup Date for All Databases

SELECT 
    d.name AS DatabaseName,
    MAX(b.backup_finish_date) AS LastBackupDate
FROM sys.databases d
LEFT JOIN msdb.dbo.backupset b ON b.database_name = d.name AND b.type = 'D'
GROUP BY d.name
ORDER BY LastBackupDate;