cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
299
Views
10
Helpful
4
Replies

Simple Question

Jayd000007
Level 1
Level 1

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 4

Jayd000007
Level 1
Level 1

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?

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

Steffen.Baier
Level 1
Level 1

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

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

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: