cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

Failure alerts for specific clients

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?

2 Replies
Highlighted

Re: Failure alerts for specific clients

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.


Thanks
Puneet Dixit

Re: Failure alerts for specific clients

@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