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

SWQL Query lldpx

I have created Universal Device Pollers for lldpXMed OIDs. The issue I have is when I run a SWQL against these custom pollers, the information from each OID all show under Status. Is there a way to modify one of the pollers or swql query to populate different columns instead of showing all info under status.

OIDs

1.0.8802.1.1.2.1.5.4795.1.3.3.1.2

1.0.8802.1.1.2.1.5.4795.1.3.3.1.4

1.0.8802.1.1.2.1.5.4795.1.3.3.1.5

1.0.8802.1.1.2.1.5.4795.1.3.3.1.6

SELECT Status

FROM Orion.NPM.CustomPollerSatusOnNodeTabular

WHERE NodeID =${NodeID}

Find more posts tagged with

Accepted answers

All comments

adam.beedell

Got SAM?

puddinhead05

Yes

cnorborg

You should be able to do nested queries in the SELECT portion where you select which column you want using the AssignmentName field and rename the multiple STATUS results using "AS".

ie: something along the lines of

SELECT Q1.STATUS AS [Status1],

(SELECT Q2.STATUS AS [Status2] FROM Orion.NPM.CustomPollerStatusOnNode Q2 WHERE (Q2.NodeID = Q1.NodeID) AND (Q2.AssignmentName LIKE 'lldpVALUE2%')) AS [Status2]

FROM Orion.NPM.CustomPollerStatusOnNode Q1

WHERE (Q1.NodeID = ${Q1.NodeID}) AND (Q1.AssignmentName LIKE 'lldpVALUE1%')

I'm just doing this off the top of my head, so the syntax might be kinda wrong. I don't have those OIDS on my devices, but have done similar things on other UnDP's. Kind of a pain, but it can work depending on your data?

adam.beedell

You can add custom SNMP OID monitors in SAM that are a little more flexible (though you cant transform them as easily as with UDP), I tend to prefer the SAM method for most stuff, this looks like a decent example.

puddinhead05

When I run the queries as above I get an error "subquery returned more than 1 value". When the queries are not nested they both return the correct information. I am struggling to understand why the subquery is limited to one value.