Hello,
Is there any way to discover all NPM devices that aren´t marked with "YES" in NCM ?
If you have both systems integrated, go into Settings > NCM Settings > Add or Manage Nodes, then set the filter for Licensed by NCM. From there, select the No to see the devices that are not marked.
Go to 'manage nodes' under settings in the web console. you should find a drop down option there called ncm_licensed or something like that
Thanks a lot for all answers.
Is there any way to do this search by a sql query ?
Depending on the version there might be, but you potentially have to join tables from both the NPM and NCM database to compare the node information. It's simpler by using the options given by myself and HolyGuacamole
If you're on NCM 7.3.1 or above, here is the setting to see what's managed by NCM or not. Group nodes by NCM - Licensed.