1 of 1 people found this helpful
I recommend you work out the query you want using SWQL Studio (you can download an installer from https://github.com/solarwinds/OrionSDK/releases/latest ) before building your API calls.
SWQL does not support the SELECT * construct. You must list the specific properties you want returned. You can see this list graphically in SWQL Studio and also double-click on an entity to have SWQL Studio generate a query that selects all properties.
There is a way to ask the API for a full list of properties for an entity - this is how SWQL Studio builds its tree. That query looks like this:
SELECT Name FROM Metadata.Property WHERE EntityName='Orion.Nodes' AND IsNavigable=FALSE
Finally, custom properties on nodes are accessed through the "CustomProperties" navigation property. So your query might look like this:
SELECT NodeID, Caption, Status FROM Orion.Nodes WHERE Nodes.CustomProperties.Company = 'solarwinds'
3 of 3 people found this helpful
You can visit this url to see a full scheme definition on github;
In particular, Orion.Nodes is in this url:
I hope it helps you.