SQL query for Regsitered IP Phones

[cisco_ipt]

Hi,

Is there a SQL query to check how many IP phones are registered in callmanager.

If I go to callmanager admin page it lists me all the phones including not registered phones.

BR

C

[mcnerney]

Another approach to seeing just the registered phones is to use the Real-Time Monitoring Tool.

[Daniel.M.Edwards]

If you want to get details You can always check the DeviceListX. It is an XML file you can get which includes a handful of useful data. While it included both registered and unregistered since it is XML you should be able to filter it down pretty easy.

https://[CCMServer]/CCMAdmin/reports/devicelistx.asp

For more information on report:

http://www.cisco.com/en/US/customer/products/sw/voicesw/ps556/products_programming_usage_guide_chapter09186a008062ff36.html