Report to see what devices in NPM are also in NCM

you can run this against your database to get that:

SELECT
Caption, IP_Address, Vendor, MachineType
FROM Nodes
WHERE NodeID NOT IN (SELECT CoreNodeID FROM NCM_NodeProperties)

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

• LinkedIN: Loop1 Systems
• Facebook: Loop1 Systems
• Twitter: @Loop1Systems

Thanks, that worked great.

Another option you can use is in NCM.

Go into Node Management and then Group by NCM - Licensed. It will then show No and Yes groups. All in the No group are not currently in NCM.

How to also add a column which indicates all nodes and whether the NCM status is Yes, No or Never? I saw few reports which only divides them into 2 groups ( licensed or unlicensed).

Any help will be appreciated.

My team needs to know which devices are missing and whether they are to be ignored (never status) or to be added (if NO).