cancel
Showing results for 
Search instead for 
Did you mean: 

Failure alerts for specific clients

Simon78
Level 3

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 2

puneet102
Level 4

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

Dollypee
Moderator
Moderator
   VIP    Certified

@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