Hi.
Here is one with Policy Name. Its not possible to have exclusion list as OpsCenter don't collect that kind of data.
SELECT DISTINCT
nbp.ClientHostname AS 'Client Name',
DJ.policyName AS 'Policy Name',
UtcBigIntToNomTime(dj.startTime) AS 'Start Time',
UtcBigIntToNomTime(dj.endtime) AS 'End Time',
dj.statusCode AS 'Status Code',
lookup_JobStatusCode.name AS 'Status message',
nbp.fileList AS 'Backup Selection'
FROM "nom_NBPolicy" nbp, "domain_Job" DJ, lookup_JobStatusCode
WHERE
dj.id = dj.parentJobId and lookup_JobStatusCode.id = dj.statuscode and nbp.PolicyName = dj.policyname and nbp.ClientHostname = dj.clientname and nbp.HostGUID = dj.masterServerId and
dj.clientname = 'SERVERNAME' and DATEDIFF(day,UTCBigIntToNomTime(dj.endTime), GETDATE()) <= 7
order by 3 DESC