2 Replies Latest reply on Oct 12, 2016 9:34 AM by ajwill

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

    ajwill

      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