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

Manage Nodes With NCM setting in Database

Deltona

Hi guys,

I've searched and search and searched some more but can't find the table in which this setting is stored.

Does anyone know where the change is being made?

TIA

/Deltona

Find more posts tagged with

Accepted answers

All comments

Deltona

BUMP

Deltona

BUMP

cvachovecj

The settings is stored in the NCM_NCMSettings table.

Jiri

Deltona

Are you sure?

I am not getting the list of nodes when running SELECT * FROM NCM_NCMSettings

All I get is the location of NCMIndexCatalogPath, Support Account Limitation in NCM Jobs, Vuln Last Error/Run.

cnorborg

I don't know if there is an explicit column in a table that says that. However, you can figure it out quite easily. In the "Nodes" table (or view) in NPM, you have your NodeID. In the NCM_NodeProperties table you have a couple columns "NodeID" (which is specific to NCM) and "CoreNodeID" which would be the same as the NodeID is in the NPM Nodes table. If you do a left outer join on them, if there isn't a NCM_NodeProperties.NodeID in the resulting table you know its not in NCM...

SELECT TOP 100 N.NodeID, CASE WHEN NCM.NodeID IS NULL THEN 'False' ELSE 'True' END AS InNCM

FROM Nodes N LEFT OUTER JOIN NCM_NodeProperties NCM ON (N.NodeID = NCM.CoreNodeID)

This query should illustrate it, rather than having the second column be the NCM_NodeProperties.NodeID (or NULL) I converted it to a true/false with the "CASE" statement..

HTH!!

Deltona

Hi Craig,

Thanks for the query. I have tested it and it works as explained.

Ultimately, what I'm after is a query that will add nodes to the NCM_NodePorperties table because NCM currently can't do this automatically.

It would be a SQL job that runs once a day. If a Node who's vendor = Cisco, and is not in the NCM_NodeProperties table, then the query would add that Node to NCM.

Does it make sense?

cvachovecj

Ok, then I would do the following using Orion SDK:

Find out which nodes are/aren't licensed by NCM. SWQL:

SELECT n.NodeId, n.Caption,n.NCMLicenseStatus.LicensedByNCM
FROM Orion.Nodes as n
Add these nodes to NCM using the following verb for one node:
AddNodeToNCM(NodeId)

Jiri

Deltona

Any chance this could be done using raw SQL queries?

Use of the SDK add a layer of complexity that I'd rather avoid.

prashantsingh

Hi @cvachovecj ,

Could you please let me know how to add multiple nodes in NCM using SDK.

Thanks

Prashant