cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Message: Invalid object name 'dbo.IPAM_GroupNodeReportView

Is there a work around or alternative to getting a Subnet list from IPAM ?

End goal is to programmatically get a list of subnets defined in IPAM

Running into the exact same bug documented on Aug 2

https://github.com/solarwinds/OrionSDK/issues/89

Also can duplicate error from SWQL Studio

results = swis.query("SELECT Description, DisplayName, Address, AddressMask FROM IPAM.Subnet")

File "/Library/Python/2.7/site-packages/orionsdk/swisclient.py", line 24, in query

{'query': query, 'parameters': params}).json()

File "/Library/Python/2.7/site-packages/orionsdk/swisclient.py", line 59, in _req

resp.raise_for_status()

File "/Library/Python/2.7/site-packages/requests/models.py", line 935, in raise_for_status

raise HTTPError(http_error_msg, response=self)

requests.exceptions.HTTPError: 400 Client Error: Invalid object name 'dbo.IPAM_GroupNodeReportView'. for url: https://somewhere.com:17778/SolarWinds/InformationService/v3/Json/Query

[Finished in 1.0s with exit code 1]

Tags (1)
0 Kudos
3 Replies
Level 7

Looks like the UG and SolarWinds support has gone silent on this.

Has anyone looks at an alternative to automate getting a SolarWinds Subnets out of IPAM ?

Thinking I could spend a day digging through the schema and use a SQL query but really don't want to invent a one off for a broken API. 

0 Kudos

you should have a view called IPAM_GroupNodeReportView

Here is a SQL scripts for its creating

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[IPAM_GroupNodeReportView]') AND OBJECTPROPERTY(id, N'IsView') = 1)

BEGIN

  DROP VIEW [dbo].[IPAM_GroupNodeReportView]

END

GO

CREATE VIEW [dbo].[IPAM_GroupNodeReportView]

AS

Select g.*

from IPAM_GroupNodeView g

where ((Distance = 1 and ((GroupTypeN= 😎 or GroupTypeN =  64)) or  (GroupTypeN != 😎 and (GroupTypeN != 64))

0 Kudos
Level 7

Checked the database. There is no dbo.IPAM_GroupNodeReportView table either, does this come from a report that neeed to be schedukled in the UI ? 

Screen Shot 2017-10-09 at 11.21.50 AM.png

0 Kudos