Adding two more columns to existing script (backup summary)
You should be able to tweak this for your needs

SELECT bs.database_name AS DbName
    ,CAST(bs.backup_size / 1024.0 / 1024 / 1024 AS DECIMAL(10, 2)) AS BackupSize_GB
    ,bs.backup_start_date AS Backup_StartDate
    ,bs.backup_finish_date AS Backup_EndDate
    ,bs.NAME AS BackupName
    ,bmf.physical_device_name AS DeviceName
FROM msdb.dbo.backupset bs
JOIN msdb.dbo.backupmediafamily bmf ON bs.media_set_id = bmf.media_set_id
WHERE bs.database_name = 'DB_Name'
  AND  bs.NAME = 'BackupSetName'
ORDER BY bs.backup_start_date DESC