Point 1:

It seems that this table backupset only contains information of the backups that where made to backup devices. At the company we make backups to file. when i make a backup like:

backup database sgt to disk ='c:\example.BAK' the name column of the table appears as NULL , why?