Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Network Performance Monitor (NPM) > Create an alert on a Universal Device Poller (UnDP) when two values are returned

Create an alert on a Universal Device Poller (UnDP) when two values are returned

Table of contents

Updated May 26, 2017

Overview

This article provides steps to create an alert on a Universal Device Poller (UnDP) when two values are returned.

Environment

All NPM versions

Steps

  1. Create a Universal Device Poller.
  2. Create a new alert in the Orion Web Console.
  3. Check the data from the database. Run the following query using the name of the polling engine to identify the custompollerid. For example, upsAdvBatteryCapacity is the name of the polling engine, substitute the name of the polling engine in the following query, where UniqueName='InsertNameofyoupollerhere'.
    SELECT * FROM [dbo].[CustomPollers]
    where UniqueName ='upsAdvBatteryCapacity'

    Similar data will then be returned: CustomPollerID: a519ce64-33c3-490c-b0f8-04982911cd3e

  4. Run the following query. Replace the value of the custompollerid returned from the first query:
    SELECT * FROM [dbo].[CustomPollerAssignment] 
    where custompollerid ='a519ce64-33c3-490c-b0f8-04982911cd3e'
    All the polling engine assignments will then be listed.
  5. Run the following query using the custompollerassignmentid to obtain the raw data returned:
    SELECT * FROM [dbo].[CustomPollerStatistics_Detail] where CustomPollerAssignmentID = '7A47BC3E-2FCC-4209-9F5E-060A0909BDFD'
    The following table shows the value returned and the rowid for each value. You can also use the rowid to select the value that needs to be triggered. For example rowid = 1

 

Last modified
08:17, 13 Jun 2017

Tags

Classifications

Public