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