After a recent upgrade to NPM and NCM to 2020.2.6, the API no longer returns data from NCM. Interestingly enough the builtin SWIS query webpage.works just fine. Typical url would be:
solarwindsserver/.../swis.aspx
we have tried multiple tables such as this query:
SELECT NodeID, CoreNodeID FROM Cirrus.Nodes
SELECT NodeID, CoreNodeID FROM NCM.Nodes
There are no errors from the api, there are no errors in the swis information logs on the server. Where should I start looking?
The basic python script looks like
from solarwinds_api import SwisClient
#### Connect
sw = SwisClient("solarwindsserver",username, password)
#### Query NCM for nodeID
cirrus_node_results = sw.query("SELECT NodeID, CoreNodeID FROM Cirrus.Nodes")
print (cirrus_node_results)
# This does not return results
