snaga

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…

Sorry but I do not find any way to upload here the exported report xml.