Sample code:

declare

@max_backup_set_id int,

@db_name varchar(50)

select

@db_name = '<db_name>'

select

@max_backup_set_id = max(backup_set_id)

from

msdb..backupset

select

b.physical_device_name

from

msdb..backupset a

join msdb..backupmediafamily b

on a.media_set_id = b.media_set_id

where

backup_set_id > (@max_backup_set_id - 10000) and

type = 'D' and

database_name = @db_name and

b.physical_device_name not like 'VDI%' and

( b.physical_device_name like '%Full.LSbak' OR

b.physical_device_name like '%Full%bak' ) and

backup_finish_date > dateadd(hh,-(7*24),getdate())

order by

backup_finish_date DESC