phone queries

Unanswered Question
May 13th, 2010
User Badges:

Can anyone tell me if there is a way to get all of the serial numbers of the phones with some kind of query. I coundn't find anything in the Call Manager for serial numbers and I also used Real Time Monitoring Tool but I had no luck. I need to get the serial numbers of the phones and I have 500 of them by next week and I hope there is an automated process that I can use. Thanks for your help!!!!

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
William Bell Thu, 05/13/2010 - 08:52
User Badges:
  • Purple, 4500 points or more

You would need to have a script/app that would go to the http server on the phones themselves and "scrape" the HTML.  The serial numbers are there. My approach was to use a script that pulls the registration status from CUCM and then polls the phones for the info.  7936/35/37 don't play well with this method.  Nor do any of the wireless handsets (which could be a pain if you are a health care provider).


I have not seen anything in the CM db that stores this, thought that would be a real nice piece of info for Cisco to provide.


HTH.


Regards,
Bill

afmmanicke Thu, 05/13/2010 - 14:14
User Badges:

I run this every now and again to update my inventory info.


First I have a csv file that has the phone type in the first column followed by the IP address (i.e.Cisco ATA 186, xxx.xxx.xxx.xxx)   I just do an empty query on the devices to get this list together.   I do this so I can keep the data segragated between ATAs and IP Phones, but it's probably not necessary in all cases.


After I have that list I do like Bill suggested and download the HTML to my PC via a Perl script.   From there I use more Perl to summarize the data into another CSV file.


Check out the attached.   It's probably not the cleanest coding, but it will work.


TONY

Attachment: 

Actions

This Discussion