Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

SQL query for Regsitered IP Phones

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

2 REPLIES
Bronze

Re: SQL query for Regsitered IP Phones

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

New Member

Re: SQL query for Regsitered IP Phones

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

295
Views
0
Helpful
2
Replies
CreatePlease login to create content