08-31-2017 02:08 AM
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?
09-17-2017 05:09 AM
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.
01-31-2018 09:42 AM
@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