Which CCM0301 table contains Personal Address Book Info?

Unanswered Question
Mar 13th, 2009
User Badges:

I'm trying to pull Personal SpeedDial and Personal Address book info out of CCM 4.2. I can see the speed dial info in table dbo.SpeedDialNumber but which table has the PAB info?


  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
schemberg Mon, 03/16/2009 - 00:36
User Badges:

I don't know exactly, but I would exprect it to be part of the LDAP db.



Sascha Monteiro Mon, 03/16/2009 - 01:07
User Badges:
  • Silver, 250 points or more

Axel is right, it's all in the embedded dc directory (LDAP) :-(

I haven't looked at it that close, but I think your best way is creating a script that can pull down all details via ldap.

I am not sure if a BAT export gives you any details

stephan.steiner Mon, 03/16/2009 - 01:31
User Badges:
  • Silver, 250 points or more

login: Directory Manager

Password: your DC directory password

port: 8404 (note that ldap default is 389)

base path for all directory searches:


Path on top of that to search for:

ou=PersonalAddressBook, ou=azue_info,ou=user_info, ou=CCN

where you replace azue_info with _info where is the userid of the user whose personal directory you're interested in.

sn, givenName hold the name as with any ldap, and the numbers are in the fields telephoneNumber, mobile and homePhone.

If you want a user's properties as visible in ccmadmin, you search in ou=Users. Some of the attributes besides sn and givenName are mail, departmentNumber, telephoneNumber, manager.

Basically, the DC Directory admin will let you browse the contents of the directory and thus figure out search paths and object names.

mvtonytjo Tue, 03/24/2009 - 04:50
User Badges:

Hi Stephan,

Is your information specific to CM version 4?

Do you know where does the information of the Personal Directory store for CM version 5 onwards? A table in the database?




This Discussion