declare @last_full_backup table (database_name sysname, last_lsn numeric(25,0))  
declare @last_diff_backup table (database_name sysname, last_lsn numeric(25,0))  

declare @hostname sysname, @groupid int =14 
select @hostname = '\\' + substring(@@SERVERNAME, 1, CHARINDEX('\', @@SERVERNAME)-1) + '\X$\'

insert into @last_full_backup (database_name, last_lsn)
select database_name, MAX(last_lsn) 
from msdb.dbo.backupset b 
INNER JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
where type = 'D'  and is_copy_only = 0 
group by database_name
order by database_name

insert into @last_diff_backup (database_name, last_lsn)
select database_name, MAX(last_lsn) 
from msdb.dbo.backupset b 
INNER JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
where type = 'I'  and is_copy_only = 0 
group by database_name
order by database_name


select @@servername as ServerName, @groupid as DBGroupID, b.database_name as DBName, type as [BackupType], b.backup_finish_date, REPLACE(m.physical_device_name, 'X:\', @hostname)
from msdb.dbo.backupset b 
INNER JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
join @last_full_backup lfb
on b.last_lsn = lfb.last_lsn and b.database_name = lfb.database_name
where type = 'D' and is_copy_only = 0
union
select @@servername as ServerName, @groupid as DBGroupID, b.database_name as DBName, type as [BackupType], b.backup_finish_date, REPLACE(m.physical_device_name, 'X:\', @hostname)
from msdb.dbo.backupset b 
INNER JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
join @last_diff_backup lfb
on b.last_lsn = lfb.last_lsn and b.database_name = lfb.database_name
where type = 'I' and is_copy_only = 0
union
select @@servername as ServerName, @groupid as DBGroupID, b.database_name as DBName, type as [BackupType], b.backup_finish_date, REPLACE(m.physical_device_name, 'X:\', @hostname)
from msdb.dbo.backupset b 
INNER JOIN msdb.dbo.backupmediafamily m ON b.media_set_id = m.media_set_id
join @last_full_backup lfb
on b.database_name = lfb.database_name
where b.last_lsn >= lfb.last_lsn  and type = 'L' and is_copy_only = 0
order by backup_finish_date