In the Manage Nodes view there is a Grouping named 'NCM - Licensed' . What table is this stored in or is this calculated? I'm interested in developing a report using this status.
We are running v7.3.2.
rgward
I am far from the powers of SQL, and there may quite possibly be a better way to get there, but this should get you started...
Orion Platform 2015.1.0, SAM 6.2.0, QoE 2.0, NCM 7.3.2, NPM 11.5, IVIM 2.0.0
SELECT TOP 1500 nd.[NodeID] ,[IP_Address] ,[Caption] FROM [SWNPMDB].[dbo].[NodesData] nd JOIN [SWNPMDB].[dbo].[NCM_NodeProperties] np ON nd.[NodeID] = np.[CoreNodeID]
I hope this helps.
-Will
Great! Thanks for the query wluther. Are you running 11.5? I don't see the NodesData table in 11.0.1. Is this the Nodes table in 11.0.1? If I interpret your query properly, all nodes in the NodeProperties table are Licensed by NCM, correct?
We are using: NPM 11.5 / NCM 7.3.2 / SAM 6.2
In NPM 11.0.1, I think the, now [NodesData], table was just called [Nodes]
The query in my previous post pulls all of the devices/nodes from NPM that are currently licensed in NCM, and does not show the others.
Thanks again for your help! On a side note, did you have to change all your Advanced SQL reports to use the NodesData table when you upgraded to 11.5? The name change to the Nodes table to NodesData worries me that we will have to change over 100 Advanced SQL reports.
I have the same problem, I can't find the field in any tables. The queries in this thread is opposite of what we are trying to accomplish. We want a list of devices that are in NPM but not in NCM which are flagged with "NCM Licensed" = Yes/No/Never.
While this could be done by showing NodeID's not matching NodeID's from the NPM <-> NCM Nodes table - it would be much easier to pull this field into the report. It has to exist somewhere as its referenced in several areas of the GUI. (manage nodes, edit node, etc)
this one gets you Node Id, Caption and License status but only runs in swql since it relies on Cirrus tables which are not available in SQL mode
SELECT a.NodeID, b.caption, a.LicensedByNCM
FROM Cirrus.NCMNodeLicenseStatus a join Orion.nodes b on b.NodeID = a.NodeID
