03-17-2016 03:25 AM
In the main Monitor overview page for OpsCenter there is a report showing the top 7 policiesby failed jobs, I would like to be able to create a similar report but can not find a canned report I can modify to do that. We have the full version with Analytics enabled but I am no SQL programmer. Does anyone have a report they created I can us?
Thank
Jeff
03-17-2016 06:49 AM
Hi Jeff, you can try this one.
SELECT TOP 7
dj.policyname as 'Policy Name',
dj.statusCode as 'Status Code',
count(dj.statuscode) as 'Failed Jobs'
FROM domain_jobarchive dj
WHERE DATEDIFF(hour,UtcBigIntToNomTime(dj.endTime), GETDATE()) <= 24
and dj.statuscode not in (0,1)
group by dj.statuscode,dj.policyname
order by 3 DESC
Regards Morten