Ops Center Report

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

3 Replies
Highlighted

Hi. I think you can use

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

Highlighted

Hi, Thanks for

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

Highlighted

Hi. Here is one with Policy

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