Forum Discussion

Automation2015's avatar
Automation2015
Level 4
10 years ago

Reporting-Ops Center

Hi Experts,

 

I was curious if we could fetch report for last 24 hours from ops center.Which should not include the restart tries and should fetch the latest backup for each client in last 24 hours.Ex:Client ABC failed at 11 .I retried at 12 and got successful.So tommorrow morning report  i should only get the report for client abc with successful status which started at 12.

 

Kindly suggest is it possible through ops center.

 

Regards

Automation

7.6
Backup and Recovery
NetBackup
UNIX
  • VoropaevPavel's avatar
    VoropaevPavel
    10 years ago

    Job retries are part of single job id. If job was successfull after retry overall job status will be 0.

    To eliminate child process failures for multiple stream backups, you can select only parent jobs.

    One of the reports i use for unique failures below, perhaps it might be helpful for you.

     

    SELECT
domain_Job.clientName as "Client Name",
domain_Client.hardwareDescription as "Client OS",
lookup_JobState.name as "Job State",
count(domain_Job.statusCode) as "Number of Failures",
domain_Job.policyName as "Policy Name",
domain_Job.statusCode as "Status Code",
lookup_JobStatusCode.name as "Status Code Description"

FROM
domain_Job, domain_Client, lookup_JobType, lookup_JobState, lookup_JobStatusCode

WHERE

-- BEGIN Joins --
domain_Job.type = lookup_JobType.id AND

domain_Job.statusCode = lookup_JobStatusCode.id AND

domain_Job.state =lookup_JobState.id AND

domain_Job.clientName = domain_Client.name AND
domain_Job.masterServerId = domain_Client.masterServerId  AND
-- END Joins --

domain_Job.statusCode > 0 AND -- Only errors and partials, modify to 1 to exclude partial backups

domain_Job.id = domain_Job.ParentJobID AND -- Only parents

domain_Job.type = 0 AND -- Only backup jobs

DATEDIFF(hour,UTCBigIntToNomTime(domain_Job.endTime), GETDATE()) <= 24 -- last 24 hrs

GROUP BY domain_Job.clientName,domain_Client.hardwareDescription, domain_Job.policyName, domain_Job.statusCode, lookup_JobStatusCode.name, lookup_JobState.name

ORDER BY domain_Job.statusCode

     

1 Reply

Sort By
  • VoropaevPavel's avatar
    VoropaevPavel
    Level 4
    10 years ago

    Job retries are part of single job id. If job was successfull after retry overall job status will be 0.

    To eliminate child process failures for multiple stream backups, you can select only parent jobs.

    One of the reports i use for unique failures below, perhaps it might be helpful for you.

     

    SELECT
domain_Job.clientName as "Client Name",
domain_Client.hardwareDescription as "Client OS",
lookup_JobState.name as "Job State",
count(domain_Job.statusCode) as "Number of Failures",
domain_Job.policyName as "Policy Name",
domain_Job.statusCode as "Status Code",
lookup_JobStatusCode.name as "Status Code Description"

FROM
domain_Job, domain_Client, lookup_JobType, lookup_JobState, lookup_JobStatusCode

WHERE

-- BEGIN Joins --
domain_Job.type = lookup_JobType.id AND

domain_Job.statusCode = lookup_JobStatusCode.id AND

domain_Job.state =lookup_JobState.id AND

domain_Job.clientName = domain_Client.name AND
domain_Job.masterServerId = domain_Client.masterServerId  AND
-- END Joins --

domain_Job.statusCode > 0 AND -- Only errors and partials, modify to 1 to exclude partial backups

domain_Job.id = domain_Job.ParentJobID AND -- Only parents

domain_Job.type = 0 AND -- Only backup jobs

DATEDIFF(hour,UTCBigIntToNomTime(domain_Job.endTime), GETDATE()) <= 24 -- last 24 hrs

GROUP BY domain_Job.clientName,domain_Client.hardwareDescription, domain_Job.policyName, domain_Job.statusCode, lookup_JobStatusCode.name, lookup_JobState.name

ORDER BY domain_Job.statusCode