Simple Question

Unanswered Question
Mar 8th, 2007

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.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Jayd000007 Thu, 03/08/2007 - 06:37

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?

Jayd000007 Fri, 03/09/2007 - 00:53

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

Steffen.Baier Fri, 03/09/2007 - 01:36

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

mdury Mon, 03/10/2008 - 10:41

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

Actions

This Discussion