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

DYnamic inventory for ansible

I would like to create a dynamic inventory in ansible using solarwinds SWQL . I am having issues pulling the Orion.nodes and sorting for a Orion.nodesCustomProperties .

SELECT N.DNS FROM Orion.Nodes as N
JOIN Orion.NodesCustomProperties as CP on N.NodeID = CP.NYT_PATCH_SCHEDULE
JOIN Orion.Nodes as C on CP.NYT_PATCH_SCHEDULE=C.DNS WHERE CP.NYT_PATCH_SCHEDULE = '9999NR'

my query any help will be great

Find more posts tagged with

Comments

mesverrum

I'm not following what you are trying to do, use joins instead of where conditions? I think what you are trying to do is probably best done this way:

select n.dns

from orion.nodes n

where n.customproperties.nyt_patch_schedule = '9999NR'