Orion.node table

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'

Hi vijay09,

You can visit this url to see a full scheme definition on github;

SolarWinds Information Service v3.0 Schema Documentation Index

In particular, Orion.Nodes is in this url:

SolarWinds Information Service v3.0 Schema Documentation

I hope it helps you.