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?
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.