Query to List of backup's by Database

Below query gives the list of all the backup's taken on the server.


SELECT sysdb.name DBName, bkup.description, physical_device_name , bkup.backup_finish_date,

case

when type='D' then '** FULL **'

when type='I' then 'DIFFERENTIAL'

when type='L' then 'LOG'

end as Backup_Type,

(STR(ABS(DATEDIFF(day, GetDate(),(backup_finish_date))))) as 'Days_Ago',

ceiling(bkup.backup_size /1048576) as 'Size Meg' ,

cast((bkup.backup_size /1073741824) as decimal (9,2)) as 'Gig',

server_name, sysdb.crdate

, first_lsn, last_lsn, checkpoint_lsn

FROM master.dbo.sysdatabases sysdb LEFT OUTER JOIN msdb.dbo.backupset bkup ON bkup.database_name = sysdb.name

left join msdb.dbo.backupmediafamily Fam on fam.media_set_id=bkup.media_set_id

where backup_finish_date > DATEADD(DAY, -5, (getdate())) -- Last 5 days

--AND sysdb.name = DB_NAME'

-- and bkup.backup_finish_date>='11/02/2017'

ORDER BY sysdb.name, bkup.backup_finish_date desc