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
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:
from orion.nodes n
where n.customproperties.nyt_patch_schedule = '9999NR'
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.