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.

Source entity [NPM.RoutingTable] not found in catalog - how do i get the catalog or convert table names into SWQL names?

Hi all,

Im using sql studio to browse the DB, and i can see that the table is name as such [SolarWindsOrion].[dbo].[NPM_RoutingTable]

Converting that into SWQL i would of presumed "Orion.NPM_RoutingTable" but im getting the error

"{u'Message': u'Source entity [NPM.RoutingTable] not found in catalog', u'ExceptionType': u'SolarWinds.Data.Query.EntityNotFoundException', u'FullException': u'SolarWinds.Data.Query.EntityNotFoundException: Source entity [NPM.RoutingTable] not found in catalog\r\n "

is there a way to browse the catalog to view the right names?

my query below:

core_01_route_query = """

  SELECT

  NodeID,

  RouteDestination,

  RouteNextHop

  FROM

  Orion.NPM_RoutingTable

    WHERE

  NodeID = 35

"""

print swis.query(core_01_route_query)

Thanks