What I normally use (as example):
- take a QoS that is generated by each robot, example: QOS_CPU_USAGE
- verify that you executed the QoS view sql script (so your qos can be accessed by V_..)
At that moment you can execute a SQL query where you can check for robots that didn't publish this QoS the last xx hours: (example query)
---
select a.robot, a.origin, MAX(b.sampletime) as last_sampletime
from CM_NIMBUS_ROBOT a with(nolock)
inner join V_QOS_CPU_USAGE b with(nolock)
on a.robot = b.robot
group by a.origin, a.robot
having MAX(b.sampletime) <= DATEADD(hh, -1, getdate())
order by last_sampletime
---
- if this query returns what you want, you can add this query in sql_response and generate an alarm for each robot in the output. Or you can create a custom Jasper report and schedule this and mail yourself the output,...
Original Message:
Sent: 06-20-2019 06:18 AM
From: MADANRAJ SIVAGNANAM
Subject: nas
I have a question regarding nas actually . How to send an alarm for the people about the events that are not coming continuously in CA UIM or whenever the data is missing in CA UIM , events are missing in CA UIM I need to create a alarm and send them . Please share me the process or kb to do this so that I can send the alarms whenever data is not coming continuously or events are not coming continuously .