Solved: Phone count per floor

phifdd4305 · ‎12-28-2015

I need to get a count of phones per floor per building. I can identify the location by the IP address that each phone is registered to but not sure how to export that using BAT. Any ideas on how to accomplish this?

Chris Deren · ‎12-28-2015

The easiest way is to perform a search of the devices in CUCM, if you have more than 250 phones that show up you can edit the URL where it states =250 to something larger, i.e. 3000. Then copy the content of the search and past into Excel as text values. After that you can perform simple sorting based on the IP address column. This works great for these types of jobs.

View solution in original post

Jaime Valencia · ‎12-28-2015

IP address is not exported in any BAT report as it's only contained in runtime memory, BAT only works with the info contained in the DB, you would need to pull that info (there are plenty of threads on how to get the IPs from CUCM) and then match the info from BAT Vs the IPs.

HTH

java

if this helps, please rate

Chris Deren · ‎12-28-2015

The easiest way is to perform a search of the devices in CUCM, if you have more than 250 phones that show up you can edit the URL where it states =250 to something larger, i.e. 3000. Then copy the content of the search and past into Excel as text values. After that you can perform simple sorting based on the IP address column. This works great for these types of jobs.

phifdd4305 · ‎12-28-2015

Awesome! Thanks Chris, I was not aware that you could manipulate the url with a specific number to display. I thought you were bound to the drop down options. This is great!