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

Accessing custom poller data via the API?

gstewart

I'm curious if it's possible to access the data returned from an NPM custom poller via the API?

I can see the custom poller configuration via SWQL, but am stumped on a way to query the datastore programatically.....

Many thanks for any guidance.

Find more posts tagged with

Accepted answers

tdanner

The current values for custom pollers are in Orion.NPM.CustomPollerStatus. Historical values are in Orion.NPM.CustomPollerStatistics. Are you looking for help writing the query or help writing a program to run a query and consume the output?

All comments

tdanner

gstewart

aha! Ok cool, yup I can see the data. Awesome. Thanks.

Ok, since I've got you here, how does the CustomPollerAssignmentID (in the Orion.NPM.CustomPollerStatus table) relate to the CustomPollerID (in the Orion.NPM.CustomPollers table)?

gstewart

d'oh, perhaps I should have looked at: Orion.NPM.CustomPollerAssignment.

Woot! Got everything I need. Many thanks.

gstewart

Ok,... sorry, almost there... labels? how on earth are labels assigned to the poller results? I don't see anything in CustomPollerStatus, CustomPollers or CustomPollerAssignment?

RichardLetts

CustomPollerLabels?

gstewart

lol, that would've been a [facepalm] moment... but nope, that doesn't exist....

RichardLetts

hmm... well it's in the database and produces results with my version of SWQL studio:

SELECT CustomPollerAssignmentID, RowID, Label FROM Orion.NPM.CustomPollerLabels

gstewart

Well that's bizarre; it's missing from mine, and when I attempt that call I get a timeout.... wonder if my SWQL Studio version is behind...

This is from 1.7:

Source entity [Orion.NPM.CustomPollerLabels] not found in catalog.

2013-08-23 14:31:13,801 [92] ERROR SolarWinds.InformationService.Core.InformationService - Exception running query:

SELECT CustomPollerAssignmentID, RowID, Label FROM Orion.NPM.CustomPollerLabels RETURN XML RAW

2013-08-23 14:31:13,801 [92] ERROR SolarWinds.InformationService.Core.InformationService - Exception for Operation: <s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://www.w3.org/2005/08/addressing" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">

<s:Header>

<a:Action s:mustUnderstand="1">http://schemas.solarwinds.com/2007/08/informationservice/InformationService/QueryXml</a:Action>

<a:MessageID>urn:uuid:d309d423-d02f-4f7f-9919-f5ae953e3960</a:MessageID>

<a:ReplyTo>

<a:Address>http://www.w3.org/2005/08/addressing/anonymous</a:Address>

</a:ReplyTo>

</i18n>

<a:To s:mustUnderstand="1">net.tcp://127.0.0.1:17777/SolarWinds/InformationService/v3/Orion/ssl</a:To>

<o:Security s:mustUnderstand="1" xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">

<u:Timestamp u:Id="_0">

<u:Created>2013-08-23T18:31:13.645Z</u:Created>

<u:Expires>2013-08-23T18:36:13.645Z</u:Expires>

</u:Timestamp>

tdanner

I went through the history to see what was going on here. Orion.NPM.CustomPollerLabels was added to the Information Service schema in NPM 10.5, and only to the SWISv3 schema. , if you are on NPM 10.5 or later, check that you are connecting to SWISv3.