You can query the BackupSet and BackupMediaFamily tables in the msdb database:SELECT

CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,

bu.database_name,

bu.backup_start_date,

bu.backup_finish_date,

bu.expiration_date,

CASE bu.type

WHEN 'D' THEN 'Full'

WHEN 'L' THEN 'Log'

WHEN 'I' THEN 'Diff'

ELSE bu.type

END AS backup_type,

bu.backup_size,

bm.logical_device_name,

bm.physical_device_name,

bu.name AS backupset_name,

bu.description

FROM msdb.dbo.backupmediafamily AS bm

INNER JOIN msdb.dbo.backupset AS bu ON bm.media_set_id = bu.media_set_id

WHERE (CONVERT(datetime,bu.backup_start_date, 102) >= GETDATE() - 7)

AND bu.type <> 'L'

ORDER BY

bu.database_name,

bu.backup_finish_date