nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Alerting against Universal Device Pollers

kreases

I am trying to set up an alert using two Universal Device Pollers, the reason being the table I am using has status for Cascade, PSU and Internal Fans and I need to split these into three different alerts. To do this I am trying to use the GrpIndx poller to isolate each one however I can't seem to get it to work.

If I use the following it doesn't work,

I am trying to check against the 'state' UDP ignoring 3 = removed and 5 = normal status

If I use just that I get alerts for Fans, PSU and Cascade status but to make the email alerts relavent to one type of hardware I am trying to also check against the GrpIndx UDP 6 = Fan (Cascade = 8, PSU = 4).

Is this possible, if so how, any help would be appreciated.

Thanks.

Find more posts tagged with

Accepted answers

All comments

Tensibai

Hi,

The resultant WHERE condition of your statement is:

WHERE
(
(CustomPollers.UniqueName = 'State') AND
(CustomPollerStatus.RawStatus <> 3) AND
(CustomPollerStatus.RawStatus <> 5) AND
(
(CustomPollers.UniqueName = 'GrpIndex') AND
(CustomPollerStatus.RawStatus = 6))
)

Stated like it it can't even work because PollerName can't be = to State and GrpIndex at the same time.

I think you may be able to achieve that using a custom SQL query but iI'm not sure on how to link the two pollers together in the query.

Can you provide details about the pollers ?

kreases

Here are the details of the two pollers mentioned in my post,

State

GrpIndx

Hope this is what you wanted.

Tensibai

Hi,

I think I've been able to get what you need with some tweaking.

first of all, You can get the label in the same poller as the label and the data is in the same table.

I did a sample UnDP and alert matching your needs.

You can get it here:

http://luna.iabis.net/~tensibai/twhack/s5Chas-For-Kreases.zip

I did not test it because I've no s5 chassis here, but it should work with NPM 10.1.

To explain a little more what I did:

The query has been written based on a standard one from Orion and extended to filter on the CustomPollersLabels table wich should be filled by the UnDP.

Feel free to ask details, I do not have the time right now to explain it with detail in this post but I'll try to do a little doc about it.

Small edit for an idea:

If you with to have multiples alerts on each part of the chassis doingthe same action you may use only one alert and use the lable in the action (mail, eventlog, etc.) and so you can get rid of the filtering in the trigger (easiest to maintain in long time)

I did it for a F5 load balancer returning the state of two links in which my action message is:

${AssignmentName} changed state to ${SQL:SELECT CustomPollerLabels.Label FROM CustomPollerAssignment INNER JOIN CustomPollerStatus ON CustomPollerAssignment.CustomPollerAssignmentID = CustomPollerStatus.CustomPollerAssignmentID LEFT OUTER JOIN CustomPollerLabels ON CustomPollerStatus.CustomPollerAssignmentID = CustomPollerLabels.CustomPollerAssignmentID AND CustomPollerStatus.RowID = CustomPollerStatus.RowID Where ((CustomPollerStatus.CustomPollerAssignmentID = '${CustomPollerAssignmentID}') AND (CustomPollerStatus.RowID = '${CustomPollerStatus.RowID}'))}: ${SQL:SELECT CustomPollerStatus.Status FROM CustomPollerStatus INNER JOIN CustomPollerAssignment ON CustomPollerAssignment.CustomPollerAssignmentID = CustomPollerStatus.CustomPollerAssignmentID WHERE (( CustomPollerAssignment.CustomPollerAssignmentID = '${CustomPollerAssignmentID}' ) AND (CustomPollerStatus.RowID = '${CustomPollerStatus.RowID}'))}

wich gives me something in the vent log like:

gtmLinkStatusAvailState on f5-dmz- changed state to LINK-A : yellow

kreases

Sorry about the delay in responding but so busy this time of the year.

I have imported both the UNDP and the Alert you sent but not sure what I was supposed to see once I had done that as the UNDP just displays the operating status which I already have with the pollers I have previously set up, it doesn't show anything else.

The Alert when imported didn't show anything apart from the alert name 'Test', there wasn't a Trigger condition or action.

Consequently I have removed both, thanks anyway

Tensibai

I may have asked before but which version of NPM are you running ?

I'm running 10.1 wich allow custom SQL trigger in alerts. I'm not sure it can be usable in prior versions, and maybe editing it wipe out the custom query

The poller is not very specific, it is just configured to fill in the CustomPollerLabel Table wich the alert trigger rely on. (using the Label option when you right click on the poller definition).

And right I didn't fill any action in the alert. The primary purpose was to give you a 'base' to start with.

Let me know if you want to investigate more on this point.