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?
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: