msdb.dbo.backupfile

msdb.dbo.backupfilegroup

msdb.dbo.backupmediafamily

msdb.dbo.backupmediaset

msdb.dbo.backupset

Join them together and pull out the pieces of information which are rellivant to what you want to show.