How to trigger alert if custom poller returns no results ?

uscallesen

I'm having a hard time figuring out how to trigger an alert if a custom poller fails to return any data. In this particular case I'm monitoring a MS DHCP server - if the DHCP service somehow gets messed up the poller will recieve no data when polling the OID - I'd really like to trigger an alarm whenever this behavior is seen..

I've allready tried triggering on "Status is empty" or "Status is less than x" but no alerts are triggered - what am I missing ??

Yann

Hi uscallesen,

Could you check what is the status's value of your custom poller in the database when your DHCP service is messed up?

This will help us to find how to setup the alert.

Open Database Manager (Start > All Programs > Solarwinds Orion > Advanced Features/Database Utilities > Database Manager)

Expand your database. Right-Click on the CustomPollers table and select Query Table.

Click on Refresh to execute the default query.

Check out the CustomPollerID of your Custom Poller and copy it.

Right-Click on the CustomPollerAssignment Table and query it.

Filter the results on the CustomPollerID by adding the below line to the default SQL query:

WHERE CustomPollerID="{xxxx-xxxxx-x--x-x-x-xxx}"

and click on Refresh.

Copy the CustomPollerAssignmentID of the Custom Poller assigned to your DHCP server.

Right-Click on the CustomPollerStatus_Detail (or _Hourly, _Daily or even CustomPollerStatus only if the service is actually down) table and query it.

Add the below line to the default query with the string you copied:

WHERE CustomPollerAssignmentID="{fsdfsdfsf-sfdsdfsf-sdfsdfsd-sdfsdf}"

and click on Refresh.

Check out the Status column and review the values when the DHCP server was down.

You can export the results with File > Export > Export to Excel Spreadsheet if you need help to find the value that is written to the database when the DHCP service is messed up.

If you got any question about the above steps, please ask :-).

HTH,

Yann