Create Custom Alert with Custom snmp OID for Fortigate SLA

Hi,

I want to create an alert for the Performance SLA of Fortigate.

These are the SLA on fortigate page:

I create three custom OID snmp query with the Orion Universal device poller where I extract the SLA Name, SLA port, and if it is up or down.

I see this on the database manager:

So I see all the values that I extract in the Status column...

Now I'm trying to create a custom alert but I need to merge the data, for example If "SLA_8.8.8.8" and "port3" and is "DOWN" generate an alert... This is what I do but I don't think it works:

Are there any detailed guides on how to do this? What am I doing wrong? is it possible to cross-reference the three snmp queries?

Thanks in advance for the help

Find more posts tagged with

Alert

orion

Accepted answers

All comments

bobmarley

I do my custom poller alerts a little different. Here is an example. The node name part could be All Objects and it would work fine.

DS99

Ok, but you have three different pollers that insert the data in the same column? As my case in the "Status" column?

Because I must merge the data between these.

bobmarley

Maybe try pulling up your alert conditions and pull put the SWQL code and try running it in SWQL Studio (Not Database Manager) You can get the query from here

Once you have the query run it and see if you are getting results. It could be something as simple as you are trying Row ID of 1 and it is actually 1.0

The table that alert is working from is Orion.NPM.CustomPollerStatusOnNodeTabular so here are all of the rows and the results. If you can't cetr the alert to work through the GUI then try making a Custom SWQL alert

SELECT TOP 1000 CustomPollerAssignmentID, CompressedRowID, RowLabel, AssignmentName, CustomPollerID, NodeID, DateTime, Rate, Total, RawStatus, Status, Description, RowStatus, RowID, DetailsUrl, DisplayName, InstanceType, Uri, InstanceSiteId
FROM Orion.NPM.CustomPollerStatusOnNodeTabular