SOI Alerts to be Cleared/Acknowledge via DB Query

[Anon Anon]

Hi Friends,
We have come across a requriement where we have integraded a third party adapter to SOI. Now adapter sends major and critical alerts to represent severe conditions and minor alert to represent a normal condition (as SOI dont have concept of normal alerts currently)

We want that when minor alert for a particular model from that third party adapter arrives SOI console, it should clear any previous related major/critical alert.

I am of the opinion to run a action which will be a DB query which will connect to SOI DB and clear major/critical alert from SOI DB - Alerts table, as and when minor alert arrives.

Can someone guide me whether or not I am thinking loguically and is the option feasible.

If not , what other options can be considered in such case because to me , by default action on SOI alert are limited to particular alert and cannot work on other alert i.e if an alert arrive, we can clear/ack etc that particular alert but cannot do the same for other alerts

thanks
Sumit

[KieronConnelly]

Hi there,

I don’t believe database updates would work. SOI caches the alerts in memory so would not sync with a direct database update.

SOI uses the status of ‘Normal’ to clear alerts, so if you cannot set this status at the connector, you could override it at the Mid Tier Connector?

Cheers.

From: Community Programs Team [mailto:[e-mail]]
Sent: 13 September 2012 10:42
To: [e-mail]
Subject: [SOI Alarms, Alerts, and Events] SOI Alerts to be Cleared/Acknowledge via DB Query

Hi Friends,
We have come across a requriement where we have integraded a third party adapter to SOI. Now adapter sends major and critical alerts to represent severe conditions and minor alert to represent a normal condition (as SOI dont have concept of normal alerts currently)

We want that when minor alert for a particular model from that third party adapter arrives SOI console, it should clear any previous related major/critical alert.

I am of the opinion to run a action which will be a DB query which will connect to SOI DB and clear major/critical alert from SOI DB - Alerts table, as and when minor alert arrives.

Can someone guide me whether or not I am thinking loguically and is the option feasible.

If not , what other options can be considered in such case because to me , by default action on SOI alert are limited to particular alert and cannot work on other alert i.e if an alert arrive, we can clear/ack etc that particular alert but cannot do the same for other alerts

thanks
Sumit
Posted by:sumitjain
--
CA Communities Message Boards
219960307
[e-mail]<mailto:[e-mail]>
https://communities.ca.com

[Anon Anon]

thanks mate for the information.

Apologies I did not get whey you say : "SOI uses the status of ‘Normal’ to clear alerts, so if you cannot set this status at the connector, you could override it at the Mid Tier Connector"

The third party adapter (from a non CA product) we are using have been developed by a vendow using the logic from catalyst connection .

My enhancement request for representation of normal alerts within SOI has already been approved so I believe going forward we would be able to send normal alerts (insted of minor alerts) to represents things have normalised for third party alerts.

But what we are struggling with at the moment is to auto clear major/critcal alerts based on minor alert we are receivng . Is there any action we can configure from SOI frontend which clear down (or even acknowledge for that matter) related major/critical alert on arrival of minor alert.

Now that you have told me that Alerts are retained in cache, I think I should be dropping the idea of DB query.

thanks
Sumit

[KieronConnelly]

To clarify, SOI does support Normal events today (The valid values are 0 (Normal), 1 (Minor), 2 (Major), 3 (Critical), 4 (Down)) – and if an alert at either Minor, Major, Critical or Down receive a corresponding Normal alert, that clears the alert condition from SOI. I suspect the confusion is that sometimes folks request the ability to display normal events in the SOI console (to see what cleared) - we do not support the display of Normal events in the standard alert queue but cleared alerts can be seen in the Alert History tab.

So, in summary, if you want to clear an Alert, send an alert with the same alert id but a severity of Normal and it will be cleared.

From: Community Programs Team [mailto:[e-mail]]
Sent: 13 September 2012 10:59
To: [e-mail]
Subject: RE: [SOI Alarms, Alerts, and Events] SOI Alerts to be Cleared/Acknowledge v

thanks mate for the information.

Apologies I did not get whey you say : "SOI uses the status of ‘Normal’ to clear alerts, so if you cannot set this status at the connector, you could override it at the Mid Tier Connector"

The third party adapter (from a non CA product) we are using have been developed by a vendow using the logic from catalyst connection .

My enhancement request for representation of normal alerts within SOI has already been approved so I believe going forward we would be able to send normal alerts (insted of minor alerts) to represents things have normalised for third party alerts.

But what we are struggling with at the moment is to auto clear major/critcal alerts based on minor alert we are receivng . Is there any action we can configure from SOI frontend which clear down (or even acknowledge for that matter) related major/critical alert on arrival of minor alert.

Now that you have told me that Alerts are retained in cache, I think I should be dropping the idea of DB query.

thanks
Sumit
Posted by:sumitjain
--
CA Communities Message Boards
219960325
[e-mail]<mailto:[e-mail]>
https://communities.ca.com

[Anon Anon]

thanks a ton mate. I will test the solution and mark your answer as accpeted .

Yes I was from the group who use to think that since SOI dont display normal alerts they dont stand a chance to clear things down and at the same time remained confused how come spectrum alerts get cleared in SOI!!!
thanks for clarifying my logic.

cheers,
Sumit

[Anon Anon]

Hi Friend,

I an trying to locate AlertD from SOI GUI within USM Properties and USM Notebook details of an alert but cannot find it although I can see alert id listed when I do a db query to <SOI_DB> Alerts table.

If there any way I can see alert id on SOI console.
Third party adapter at the moment I believe is confusing alert id with Mdr element id and failing to work for clear alerts


thanks
Sumit

[Anon Anon]

Hi Friend,

I an trying to locate AlertD from SOI GUI within USM Properties and USM Notebook details of an alert but cannot find it although I can see alert id listed when I do a db query to <SOI_DB> Alerts table.

If there any way I can see alert id on SOI console.
Third party adapter at the moment I believe is confusing alert id with Mdr element id and failing to work for clear alerts


thanks
Sumit