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