Finding switchports for a list of phones

Answered Question
Oct 24th, 2008
User Badges:

We are in the process of upgrading from CUCM 4.1(3) to 6.1(2), and while we are doing that, we are also splitting our single cluster into two to segregate traffic for our contact center per recommendation of Cisco and our UCCE implementation partner (also moving from ICM 6.0 - 7.2 and IPQM 3.5(4) - IP-IVR 5.0).


Unfortunately, our contact center and non-contact center users are mixed among our closet access switches (16 closets).


We have a list of 300-400 MAC addresses of contact center phones (those registered with the ICM JTAPI user), and need to search each closet stack to correlate those MACs with their associated switchport so we can change the VLANs for those ports to point to our new cluster.


Can anyone suggest any slick ways of getting this done? Anyone have any scripting they would be willing to share?


Thank you!

Correct Answer by CHRIS CHARLEBOIS about 8 years 6 months ago

If I were faced with that, I would tackle with a very creative Excel spreadsheet. If you log your telnet session while you do a show arp, you can capture the MAC addresses in a text file and then import them into Excel. Use a vlookup funtion to check if each MAC address is in one list or the other.


I have in the past used Excel to generate router and switch configs when making massive changes like these, but that requires a great deal of creative Excel work.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
CHRIS CHARLEBOIS Fri, 10/24/2008 - 13:02
User Badges:
  • Silver, 250 points or more

If I were faced with that, I would tackle with a very creative Excel spreadsheet. If you log your telnet session while you do a show arp, you can capture the MAC addresses in a text file and then import them into Excel. Use a vlookup funtion to check if each MAC address is in one list or the other.


I have in the past used Excel to generate router and switch configs when making massive changes like these, but that requires a great deal of creative Excel work.

Farrukh Haroon Sat, 10/25/2008 - 05:44
User Badges:
  • Red, 2250 points or more

If you are using CiscoWorks LMS it has a IP Phone/User tracking feature built-in to it.


You can also make a script to logon to each switch and gather the show mac-address-table output. The show arp is not always useful because it could be that the host is not active at that moment (sending any IP traffic) and the grat. arp bit timed out. Also you won't find the arp entries on a L2 device like a closet switch (assuming switched access layer design). Once you have all the MACs in one file you can start searching.


There are other tools out there also which help you to track LAN users (Just do a google search if you wish to use one).


Regards


Farrukh

Actions

This Discussion