I’m having a hard time retrieving IPAM data from the REST API and the Python OrionSDK, specifically I am trying to query the IPAM.Subnet endpoint to create new subnets and make IP reservations but I keep getting empty results list.
I might be querying the wrong endpoint or I have the wrong schema, is there a way I can get help on this issue ?
Version: Orion Platform HF5, IPAM HF1, NCM HF1: 2019.4
REST call to /SolarWinds/InformationService/v3/Json/Query?query=SELECT+DisplayName+FROM+IPAM.Subnet
return the same results as well:
Solved! Go to Solution.
I am running the same version of IPAM, however I do not see the column name of DisplayName. Maybe you need to reference FriendlyName. I might also suggest using StatusName rather than Status, unless there is a reason to use the integer value. Other than that, I am able to retrieve data with the same query in SWQL.
You may need to put some WHERE clause in as well, my data returns Nulls for the remainder of the data, for some FriendlyName.
I tried referencing FriendlyName and DisplayName but got the same results. I am new to solarwinds and I might be using the wrong schema.
how can i see all the columns in IPAM.Subnet?
the schema I'm using is here: https://solarwinds.github.io/OrionSDK/schema/IPAM.Subnet.html
If you install the SDK, it includes SWQL studio. Or on the main server you can connect to the Database using Database Manager. I do see the item DisplayName, but the only way I could get it to pull from the query was to use "with Inherited Properties".
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.