Retrieve information about a recent copy only backup?
Try querying without the "top 100":

SELECT *
FROM msdb.dbo.backupset
WHERE name = "abc"


OR

SELECT  bs.database_name,
                bs.backup_start_date,
                bmf.physical_device_name,
                  Ordinal = ROW_NUMBER() OVER( PARTITION BY bs.database_name ORDER BY bs.backup_start_date DESC ),*
          FROM  msdb.dbo.backupmediafamily bmf
                  JOIN msdb.dbo.backupmediaset bms ON bmf.media_set_id = bms.media_set_id
                  JOIN msdb.dbo.backupset bs ON bms.media_set_id = bs.media_set_id
          WHERE   bs.[type] = 'D'
                  AND bs.is_copy_only = 0


Reference: Where is database .bak file saved from SQL Server Management Studio?

As Avarkx said, add  NAME = 'abc Name' to your WITH so that it shows a name when you do a backup. Otherwise it shows NULL. Then run the select without the TOP 100.