solarwinds / OrionSDK

SDK for the SolarWinds Orion platform, including tools, documentation, and samples in PowerShell, C#, Go, Perl, and Java.
https://thwack.com/OrionSDK
Apache License 2.0
401 stars 143 forks source link

IPAM_Subnets and IPAM_GroupNode not showing data #308

Open jordaj2 opened 2 years ago

jordaj2 commented 2 years ago

The two tables exposed by SWISS (IPAM_Subnets and IPAM_GroupNode). In the SQL database I can see nearly 6000 objects in the IPAM_Group table, but the corresponding group when I view it in SQL Studio returns 0 results: It is the same for the IPAM_Subnets table. I am able to create subnets using SWQL Studio and using the SDK: Those same subnets that I create I am able to see in the IPAM UI and I can also see in the SQL database, but I am unable to see using the OrionSDK (no results are shown InkedSWIS_IPAM_Subnet_no_rows_returned_LI )

wjch-krl commented 2 years ago

What user are using to retrieve the data from SWIS? Is it the same one you are using in the Orion Web UI? What type of user is that (e.g. Orion Admin, IPAM Power User etc.…)? what are using to log-in (Orion account, active directory account etc...)?

Generally, IPAM's UI is using those SWIS tables to visualize data (and Orion UI in general is using SWIS rather than directly querying DB), so if you are seeing data from the web-console, you should be able to see it from the SDK as well (as long as the same user is used)

jordaj2 commented 2 years ago

correct it is the same user.

wjch-krl commented 2 years ago

What about the other questions?

What type of user is that (e.g. Orion Admin, IPAM Power User etc.…)? What are using to log-in (Orion account, active directory account etc...)?