— Please run the query and redirect output to

select ‘DUMPDB_BACKUP_STATUS’ as DUMPDB_BACKUP_STATUS,’,’,@@servername AS SERVERNAME,’,’,b.dbName,’,’,b.processName,’,’,b.startTime,’,’,b.endTime,’,’,b.duration,’,’,b.size,’,’,b.status
from dba.dbo.backup_processes b, master.dbo.sysdatabases d
where d.name = b.dbName
and b.processName = ‘DUMPDB’
group by b.processName,b.dbName
having b.startTime between dateadd(day,-15,convert(date, max(b.startTime), 23)) and dateadd(day,-1,convert(date, max(b.startTime), 23))
order by b.processName,b.dbName,b.startTime
select ‘DUMPDB_BACKUP_STATUS’ as DUMPDB_BACKUP_STATUS,’,’,@@servername AS SERVERNAME,’,’,name,’,’,’NO_DUMPDB’,’,’,null,’,’,null,’,’,null,’,’,null,’,’,null
from master.dbo.sysdatabases
where name not in (select distinct dbName from dba.dbo.backup_processes where processName = ‘DUMPDB’)

select ‘ADSMINC_BACKUP_STATUS’ as ADSMINC_BACKUP_STATUS,’,’,@@servername AS SERVERNAME,’,’,b.dbName,’,’,b.processName,’,’,b.startTime,’,’,b.endTime,’,’,b.duration,’,’,b.size,’,’,b.status
from dba.dbo.backup_processes b, master.dbo.sysdatabases d
where d.name = b.dbName
and b.processName = ‘ADSMINC’
group by b.processName,b.dbName
having b.startTime between dateadd(day,-15,convert(date, max(b.startTime), 23)) and dateadd(day,-1,convert(date, max(b.startTime), 23))
order by b.processName,b.dbName,b.startTime
select ‘ADSMINC_BACKUP_STATUS’ as ADSMINC_BACKUP_STATUS,’,’,@@servername AS SERVERNAME,’,’,name,’,’,’NO_ADSMINC’,’,’,null,’,’,null,’,’,null,’,’,null,’,’,null
from master.dbo.sysdatabases
where name not in (select distinct dbName from dba.dbo.backup_processes where processName = ‘ADSMINC’)