Solarwinds IPAM 4.6.0 SWIS v3 API Issue

Hi,

We recently upgraded Solarwinds IPAM module from 4.3.2 to 4.6.0 HF3, post the upgrade SWIS v3 API call to IPAM.Subnet and IPAM.GroupNode are not fetching any records(empty result set). I am unable to fetch available IP address for the Subnet/s using IPAM.IPNode because of the null/no value against column/property IPAM.IPNode.Subnet.DisplayName. Looks like a link is missing between IPNode and Subnet/GroupNode using SWIS API.

Please let me know if anyone faced a similar issue and resolved this.

Regards,

Poornesh

Find more posts tagged with

ipam 4.6

Accepted answers

All comments

tdanner

Can you post the query that is not returning the expected results?

poornesh

Please find the queries that are not returning any results after the upgrade

SELECT TOP 1 I.IPAddress FROM IPAM.IPNode I WHERE I.Status=2 AND I.Subnet.Address='10.38.22.0'

SELECT S.SubnetId FROM IPAM.Subnet S WHERE S.Address='10.38.22.0'

SELECT G.GroupId FROM IPAM.GroupNode G WHERE G.Address='10.38.22.0'

jm_sysadmin

All three queries return results for me when I use a subnet that makes sense here. I am on Orion Platform 2017.3 sp5, IPAM 4.6

Occasionally when stuff like this happens I rerun the Configuration wizard to attempt a repair.

poornesh

What I found out is that the queries are returning expected results if I use DOMAIN\USERNAME but If I use USERNAME@DOMAIN the queries returns empty result set.