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

Need help with SWQL or SQL query .. Need to query Universal custom poller to provide the basis (for example = 1) for selecting another custom poller result using the first

I am trying to create an sql or swql query that allows me to query a specific customer node poller for a specific result, then query the results to pull another custom poller value(s) by node. I can do either independently, which is easy enough, but how can I with the same query, reevaluate using the first set of results, to then get my final results ?

SELECT TOP 100 [Nodes].NodeID , [Nodes].DisplayName , [Nodes].NodeDescription , [Nodes].MachineType , [Nodes].ObjectSubType , [Nodes].DetailsURL , [Nodes].Interfaces.InterfaceID , [Nodes].Interfaces.FullName , [Nodes].CustomPollerAssignmentOnNode.CustomPollerName , [Nodes].CustomPollerAssignmentOnNode.CurrentValue , [Nodes].CustomProperties.No_ENOC_Monitoring

FROM Orion.Nodes WHERE [Nodes].MachineType = 'PacketLight Networks Ltd.' AND [Nodes].CustomProperties.No_ENOC_Monitoring = 'False' AND [Nodes].NodeDescription LIKE 'PL-1000r%' AND [Nodes].CustomPollerAssignmentOnNode.CustomPollerName LIKE 'detect13' AND [Nodes].CustomPollerAssignmentOnNode.CurrentValue = '1'

Then I want to query the results for the list of nodes that meet this criteria;

FROM Orion.Nodes WHERE [Nodes].MachineType = 'PacketLight Networks Ltd.' AND [Nodes].CustomProperties.No_ENOC_Monitoring = 'False' AND [Nodes].NodeDescription LIKE 'PL-1000r%' AND [Nodes].CustomPollerAssignmentOnNode.CustomPollerName = 'channel13' with the node, custom pollerid and [Nodes].CustomPollerAssignmentOnNode.CurrentValue

I've been working this for several days looking at many thwack articles, and have been extremely unsuccessful. Hoping there is help out there.

Thanks,

Ned

Find more posts tagged with

Accepted answers

All comments

nedfields

Ultimately looking to create a dashboard perfstack or plot chart by node, that can show (Light level db data) for each optical channel that it handles over time.

node1/channel13 -5db

node2/channel13 -8db

adam.beedell

This question is a little hard to read, I think you've had some line breaks get eaten up

I was going to provide this answer based on your question: This'll be either a straight JOIN, or a JOIN or a subquery, or a subquery in a WHERE

That answer is still legit, but looking at your queries I think this is actually just a WHERE, I dont immediately see the need for a second step. If you just combined together the SELECT blocks and the WHERE blocks that looks like it'd suffice