Simple Question

Unanswered Question
Mar 8th, 2007
User Badges:

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
Jayd000007 Thu, 03/08/2007 - 06:37
User Badges:

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
User Badges:

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

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

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
User Badges:

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

Actions

This Discussion