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

Simple Question

I need to pull out "Name" and DN of all people on our company from the CCM 4.1 on a monthly basis. Is there any automatic way to do this, without actually connecting to the CCM, Enterprise Manager and doing this using SQL.

Thank you.

4 REPLIES
New Member

Re: Simple Question

Just came across a solution, using a LDAP Browser to extract thos information. Is any body using such tools? what do you guys use for the COmpany Phone book?

New Member

Re: Simple Question

com on Guys, anyone using LDAP to generate an Excel Phone Book?

New Member

Re: Simple Question

Use SQL Query Analyzer for this and more ;-)

SELECT DISTINCT Device.Name, Device.Description, NumPlan.DNOrPattern, DeviceNumPlanMap.Display, DeviceNumPlanMap.E164Mask

FROM Device INNER JOIN

DeviceNumPlanMap ON Device.pkid = DeviceNumPlanMap.fkDevice INNER JOIN

NumPlan ON DeviceNumPlanMap.fkNumPlan = NumPlan.pkid

WHERE (DeviceNumPlanMap.NumPlanIndex = 1)

Source:

http://ipvoicehelp.com/index.php?itemid=3

Regards

Steffen

New Member

Re: Simple Question

Great post Steffen, do you know how i could add "device Pool" to that report?

87
Views
10
Helpful
4
Replies