Ops Center Report

[Atharava13]

Dear All,

I have Netbackup 7.6.0.3 Ops Center.

I am trying to include "backup selection path " column in (success / Failure) backup report.

Is it possible to include this? and where this option.

Regards,
Atharava13

[M_henriksen]

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

[Atharava13]

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

[M_henriksen]

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