How can I setup alerting for specific job failures i.e. from a specific client.
I currently use OpsCenter Analytics for reporting & alerting; but the alerts are for all clients, how can I limit alerts for only a sub-set of clients on backup failures only.
Can this be achieved via opscenter or does it have to be done on a per client basis using BLAT on Windows?
Defnitly, it is possible to create various alerts from opscenter. you can check the link (OpsCenter Alert conditions) for the various alerts and their description.
Check Adding an alert policy
to add a new alert policy.
Simon78 try this query:
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"
FROM domain_Job,domain_MasterServer,lookup_jobtype
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(day,UTCBigIntToNomTime(startTime), GETDATE()) <= 1
group by "Client Name","Status Code","Master Server","Policy Name"
order by networkName,clientName ASC
