[cisco-voip] How Do You Count Phones in the Call Manager?

[Robert Singleton]

On Thu, 2007-09-13 at 12:25 -0400, Miller, Steve wrote:
> Any way to count physical phones?.....or even a combination of
> physical or phones programmed in software?

I sometimes use a combination of three counts.

1. SQL

A query will return how many devices in the configuration database have
names with SEP or ATA in them: 

SELECT Name from Device WHERE (Name LIKE 'SEP%' OR Name LIKE 'ATA%')

This will list them all and you can then count the returns. You could
count within the query with:

SELECT COUNT(Name) from Device WHERE (Name LIKE 'SEP%' OR Name LIKE 'ATA
%')

This will return only the count of records that match, not the whole
list of them.

You could shorten the query further to 

SELECT Name from Device
or
SELECT COUNT(Name) from Device

You would get all devices, which would include gateways, huntlists and I
presume soft phones, though I don't have any here to check out.

2. Network scan

You can also use a ping scanner such as nmap to see what phones are up.
This implies that your phones are not on the same subnet as everything
else, which is a fairly reasonable assumption for QoS purposes, but is
not a guarantee. It works for my network and in my case, I do 

nmap -sP 172.28.XX.2-254

where XX is the branch number. -sP tells nmap to only ping, not try to
port scan each host. The range at the end excludes the router and
broadcast addresses in the subnet.

3. Performance Monitor

On the Publisher and Subscribers, there are lots of CallManager
counters, including "RegisteredHardwarePhones" and
"RegisteredOtherStationDevices". In my case, all the hardware phones are
79XX phones and all the other station devices are ATAs and FXS ports on
gateways. Remember that in most instances, all the phones should be
registered to the subscriber(s) and if you have more than one
subscriber, you will have to monitor the counters for each of them.

Hope that helps!

Robert