Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

NCM database query is not returning any information

Hi,

There is a customer running Solarwinds Hybrid Cloud Observability (version 2024.2.1).

When I run following query -

curl -k -u '<username>:<password>' https://<url>/SolarWinds/InformationService/v3/Json/Query -H "Content-Type: application/json" -d '{"query": "SELECT NodeID, CoreNodeID, SysName FROM NCM.Nodes"}'

it returns:
{"results":[]}

The query works for Orion.Nodes and fails only for all NCM tables. I tried with Cirrus.Nodes as well, but it does not work.

Orion.OrionServers query provides:

{"HostName":"XXXX","ServerType":"MainPoller", "Details":"[ {\"HotfixVersionNumber\":null,\"Name\":\"SolarWinds Platform\",\"ShortName\":\"Orion\",\"Version\":\"2024.2.1\"},

...

{\"HotfixVersionNumber\":null,\"Name\":\"Network Performance Monitor\",\"ShortName\":\"NPM\",\"Version\":\"2024.2.1\"}, {\"HotfixVersionNumber\":null,\"Name\":\"Network Configuration Manager\",\"ShortName\":\"NCM\",\"Version\":\"2024.2.1\"},

...]}

How to make this query work on that system ?

Thanks in advance.

Somnath.

Find more posts tagged with

ncm function

ncm swql query

ncm troubleshooting

Accepted answers

All comments

cnorborg

You are sure you have added nodes to NCM, and are downloading configs from them and such? You can have nodes in NPM, but not in NCM.

If you go into "Edit Properties" or "Edit Node" on a node, then scroll down near the bottom, there is a dropdown box that says "Manage node(s) with NCM" that should be set to "Yes", and if so it would then expand the page to where you can give it credentials and such for the node.

somnathr

Thanks for the response. Will try to get that information and update.

cnorborg

If you do have nodes in NCM and that query still returns nothing. I'd check using both SWQL Studio, and I'd stick it in a resource on a page.

Probably the easiest way to add a resource would be to go manage your Dashboard, and add either a modern or a classic dashboard. If Modern, you'd then want to add a widget and do a table widget. Put in your SWQL query, add all the columns to the page, and see what it gives you.

If classic, add a resource of type "Custom Query", preview the page and edit the resource and put in your query. Then when you submit it you should see your results.

If either of these gives you the expected output, your problem is in your API connection most likely, or your coding. If not, the problem is in your NCM database.

ordrmahesh

Could it be an account permission issues here…like API is allowed to query only NPM databases and not NCM? Is there a way to confirm this from web console?

Lofstrand

The account have the same rights in the GUI as in the API. If the account has access to NCM in the webconsole, it will have access to NCM via the API.

But as @cnorborg said, do you have any nodes in NCM? Does the query work in SWQL studio?

somnathr

Looks like, NCM role was not configured properly. It was set to 'None'. When the customer changed it to Webviewer, we could access the NCM DB records.

Thanks everyone for your response and the help to address this issue. Appreciate it.