Just wrote a report which is capable to list all of your not yet discovered Cisco nodes on the network.
Simple compare the NPM node list to the NCM CDP neighbor node list and generate a list of the missing Devices.
Sorry but I do not find any way to upload here the exported report xml.
Might you find time to describe how the report is built so we can attempt to duplicate it?
If you were to make screen shots of the report's build pages, we could attempt to follow them and see how it works in our environments.
Swift packets, @snaga !
Rick Schroeder
Here is the SQL query I used, then you can create your own report style if needed.
Basically it lists all CDP neighbor devices from NCM which is not exist in NPM as node!
A small finetune to dismiss also the Cisco and SIP phones from the list.
SELECT RemoteDevice,RemoteIpAddress FROM [dbo].[NCM_Cisco_CDP] left join [dbo].[Nodes] on [dbo].[NCM_Cisco_CDP].RemoteDevice LIKE [dbo].[Nodes].SysName + ‘%’ where Sysname is NULL and RemoteDevice not like 'SEP%' and RemoteDevice not like 'SIP%';
I'd hoped I'd be able to help, but I'm out of my depth here. Reach out to some of the SWQL experts; I'm sure someone will have the answer to your question.
Once you have it, please post it here so others may use it, since I think it's a nice idea.
Thanks!
