This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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]

  • 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

  • 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. 

  • 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= 8) or GroupTypeN =  64)) or  (GroupTypeN != 8) and (GroupTypeN != 64))