I'm trying to write a query to look for specific hostnames, the associated address and that status of the ip. I have everything but I can't find that table that translates the ip status from numeric to text value.
I'm trying to write a query to look for specific hostnames, the associated address and that status of the ip. I have everything but I can't find that table that translates the ip status from numeric to text value.
Hi Chris,
I can't help with that but maybe you can find the info here: SolarWinds Information Service v3.0 Schema Documentation
Combining IPaddress and Sysname sounds promising to me.
You can download and check out the SWQL Studio app as it should have the most up to date info regarding database fields in there.
It can be downloaded from: Releases · solarwinds/OrionSDK · GitHub
If all fails I suggest using the dedicated SDK forum: Orion SDK
Good luck & best regards,
Steffen
That table is documented in the wiki here:
IPAM 4.5.x API · solarwinds/OrionSDK Wiki · GitHub
The table contains these values:
Value | Name |
---|---|
0 | Unknown |
1 | Used |
2 | Available |
4 | Reserved |
8 | Transient |
16 | Blocked |
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.