Viewing a List of Licensed NCM Nodes

Issue:

On the Manage Nodes page (Settings > NCM Settings > Manage Nodes) the list of nodes cannot be sorted with the "Licensed by NCM" column.

Solution:

Please download and install SWIS studio from the following location: http://downloads.solarwinds.com/solarwinds/Release/Orion/OrionSDK-v1.3.zip
Execute the following query against the Orion Core and the Orion NCM databases:

SELECT Core.NodeID AS CoreNodeId,
                            Core.Caption AS CoreNodeName,
                            Core.IP_Address AS CoreNodeIPAddress,
                      (NCM.CoreNodeID>0) AS LicensedByNCM,
                      Core.Vendor,
                      Core.MachineType,
                      Core.Location,
                      Core.Status,
                      NCM.NodeID AS NcmNodeId
                FROM Orion.Nodes AS Core
                LEFT JOIN Cirrus.Nodes AS NCM
                ON Core.NodeID=NCM.CoreNodeID

You can add any 'WHERE' clause statement to filter out data. For example, you can filter out everything except 'Cisco':

WHERE Core.Vendor = 'Cisco'

No related articles were found.

Attachments

No attachments were found.

Visitor Comments

No visitor comments posted. Post a comment

Post Comment for "Viewing a List of Licensed NCM Nodes"

If this article does not provide the solution you need, please consider visiting our community forums on thwack or contacting SolarWinds Support. Please use the following form to provide comments that help us improve this KB article. Fields marked with an asterisk are required.