I am wondering can I safely assume that 'Nodes' table will contains exactly same set of 'Nodes' as 'NCM_Nodes' table?
Did you recently upgrade to NPM 11.5.2? I'm getting an invalid object NCM_Nodes error when installing NCM 7.4. As far as I know, I didn't see any NCM_Nodes entries on the netperfmon DB.
No they will not contain the same # of rows...this is because NCM is an option on the nodes and only the ones that have "Yes" selected to be managed by NCM will show in the NCM nodes table...all nodes will show in the Nodes table
-JC
HI,
The NCM_Nodes tables contains a list of nodes that have been set up to allow managing of configurations here is the NCM guide that will exaplin what NCM does in great detail.
http://www.solarwinds.com/documentation/orionNCM/docs/orionNCMAdministratorGuide.pdf
The nodes table contains everything you monitor with your Solarwinds instance all nodes this is really the central location of solarwinds id say.
further information you can join the on the nodes table with the NCM table if you want to gather more information that that particulate node and do some fancy stuff (this is SQL)
like this:
select * from ncm_nodes as ncm
inner join nodes as n on CoreNodeID = n.NodeID
