Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Network Performance Monitor (NPM) > Knowledgebase Internal > 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

Tags

Classifications

Internal Use Only