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?
@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"
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