Now I am not sure how many of you would benefit from this but I thought i would share as it is so very useful to us.
Basic infrastructure is Cisco Switches, Mitel VoIP phones, NPM/NCM and CDP Inventory enabled.
To easily find which switch a phone was last seen on to add to the suppprt call notes (1st line support use+).
Add the extension number and search..and you get the below.
Switch Name, Port, Last Seen Date etc from CDP neighbour info.
This is a report in SQL Reporting Services. The code behind it is.
Create a datasource to your NCM database.
The query for this report is as below:
(anything with DCC is a custom field -so please amend to your needs)
/*
Testing only - you need to create a Parameter for @Extension
Declare @Extension int
Set @Extension = 31576
*/
SELECT TOP (100) PERCENT
dbo.Nodes.CoreNodeID,
dbo.Interfaces.NodeID,
dbo.Nodes.NodeCaption,
dbo.Nodes.DCC_Area_Code,
dbo.Nodes.dcc_Area_Description,
dbo.Nodes.DCC_Site_Code,
dbo.Interfaces.InterfaceName,
dbo.Interfaces.InterfaceAlias,
RIGHT(REPLACE(dbo.Cisco_CDP.RemotePlatform, ' ', ''),LEN(dbo.Cisco_CDP.RemotePlatform) - CHARINDEX('DN', dbo.Cisco_CDP.RemotePlatform) - 2) AS Extension,
dbo.Cisco_CDP.LastDiscovery,
dbo.Cisco_CDP.FirstDiscovery, dbo.Cisco_CDP.ifIndex, dbo.Cisco_CDP.RemoteDevice, dbo.Cisco_CDP.RemoteIPAddress, dbo.Cisco_CDP.RemoteVersion,
dbo.Cisco_CDP.RemotePlatform, dbo.Interfaces.InterfaceDescription
FROM dbo.Cisco_CDP
INNER JOIN
dbo.Interfaces ON dbo.Cisco_CDP.NodeID = dbo.Interfaces.NodeID
AND dbo.Cisco_CDP.ifIndex = dbo.Interfaces.InterfaceIndex
INNER JOIN
dbo.Nodes ON dbo.Cisco_CDP.NodeID = dbo.Nodes.NodeID
WHERE
(dbo.Cisco_CDP.RemotePlatform LIKE '%Mitel%')
AND (RIGHT(REPLACE(dbo.Cisco_CDP.RemotePlatform, ' ', ''),LEN(dbo.Cisco_CDP.RemotePlatform) - CHARINDEX('DN', dbo.Cisco_CDP.RemotePlatform) - 2) = @Extension)
ORDER BY dbo.Interfaces.NodeID
For Mitel CDP neighbour info you get the VoIP number in the 'dbo.Cisco_CDP.RemotePlatform' field, which what you see when you do a sh cdp nei detail
Check your inventory data - it is 100x easier to search this way than via NCM for this info quickly.
I hope someone will benefit from this