03-08-2007 03:36 AM - edited 03-14-2019 08:22 PM
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.
03-08-2007 06:37 AM
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?
03-09-2007 12:53 AM
com on Guys, anyone using LDAP to generate an Excel Phone Book?
03-09-2007 01:36 AM
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
03-10-2008 10:41 AM
Great post Steffen, do you know how i could add "device Pool" to that report?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide