Good Afternoon Everyone,
I have a question that hopefully is an easy one. We recently implemented an upgraded OpsCenter server at version 7.6 running Windows Server 2008 R2.
Everything is up and running and our 3 backup hosts (multiple sites) are reporting in normally.
My question is as follows:
When I create a custom failed job report, it lists all failed job except for the jobs that failed due to the backup window closing.
I checked the configuration of the report on our old OpsCenter 7.1 server and it is identical.
Even if I choose a standard report for failed jobs, the backup window closed failures do not show. I can run a separate report for the backup window being closed which does show those jobs.
Is this a normal function now in 7.6 as I would have thought a failed job report would list all failures regardless of type of failure
thank you in advance of any insight
Hi, Are you running opscenter Analytic? If yes, here's query to display all failed jobs
SELECT networkName as 'Master Server',
max(UTCBigIntToNomTime(domain_Job.startTime)) as 'Start Time',
clientName as 'Client Name',
policyName as "Policy Name",
statusCode as "Status Code"
WHERE domain_MasterServer.id = domain_Job.masterserverId
and domain_Job.scheduleName not like '%hour'
and domain_Job.scheduleName not like '%ERROR'
and domain_Job.scheduleName != 'online'
and lookup_jobtype.name = 'Backup'
and statusCode not in (0,1) and policyName NOT LIKE 'SLP_%' and type IN (0,22,28)
AND DATEDIFF(hour,UTCBigIntToNomTime(startTime), GETDATE()) <= 24
group by "Client Name","Status Code","Master Server","Policy Name"
order by networkName,clientName ASC
I am also suddenly experiencing this issue for our backup domain running 18.104.22.168
Here's the equivalent sql query report: