Ops Center Report

Hi.

I think you can use this.

Just replace SERVERNAME and/or GETDATE()) <= 7 to the days to look back.

 

SELECT DISTINCT
nbp.ClientHostname AS 'Client 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 2 DESC

 

Br Morten

Hi,

Thanks for information,

Now it is showing to path in report.

Also Is it possible to include (policy / Client) exclusion list in report?

Regards,

Atharava13

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