SQL - List Last Database Backup Date

There is one server with a bunch of databases with some being backed up. I needed to see which ones were being backed up.

Here is the script I used:

Select dtb.name as [Database Name], (select max(backup_finish_date) from msdb..backupset 
where type = 'D' and database_name = dtb.name
) AS [Last Database Backup Date] ,
(select max(backup_finish_date) from msdb..backupset 
where type = 'L' and database_name = dtb.name
) AS [Last Log Backup Date] 
FROM
master.dbo.sysdatabases AS dtb