07-17-2015 02:02 AM
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
07-17-2015 02:34 AM
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
07-17-2015 04:38 AM
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
07-17-2015 04:49 AM
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