How to determine if the Directory hit the maximum limit of user entries
- Start > All Programs > Microsoft SQL Server 2008 > click on the Connect button > expand the tree structure until you get to the Tables level:
- Highlight the dbo.Contact_Numbers table and right click on it, then select Top 1000 rows. You will see at the lower right corner the amount of users imported to the Directory.
NOTE: Before applying this steps, make sure that Directory Sync is enabled ( System Configuration > Directory Synchronization > Enable), that you have restarted the LDAP plugin service, and that you have closed the client console and logged back in.
How to determine which users are going to be present inside the Directory once the limit is reached
Basically, theAttendant Console will filter the user directory from CallManager sorting the entries by their pkid value. First come, first served. However the pkids are out of our control, and are also random. Take for example this output from an SSH connection to a Publisher:
admin:run sql select telephonenumber,userid,pkid from enduser order by pkid
telephonenumber userid pkid
=============== ======== ====================================
7005 luzuniga 072db6cd-4968-664f-07c6-e3b284c03682
7003 aformosa ae5e7d41-a66a-5f0d-b10c-50a8f445638c
1234 1234tome b517f6c5-ec3c-3e15-56d4-226bf4156b79
7005 cbucket c8f7be03-9028-0ad3-a871-3f35337e5c25
7335 willy dddd2b45-aad9-7218-a5e5-ff332e3ecb0
The output shows the order in which Attendant Console reads the user list from CallManager, and starts inserting them into the database. See how the username with extension 7005 is not alphabetically the first one, nor is it the lowest directory number, and it was not chronologically the first user inserted, but its pkid starts with 0.
Lets say my Attendant Console has a capacity of displaying maximum 3 users on a client Console. That means that Charlie Bucket and Willy won't be displayed at all. CUBAC has a maximum of 500 users, and CUDAC goes up to750. CUEAC, up to 100 000.
The SQL Query above can be used to determine the last entries that will not get inserted into CUxACs LDAP database.
NOTE: Before applying this steps, make sure that Directory Sync is enabled ( System Configuration > Directory Synchronization > Enable), that you have restarted the LDAP plugin service, and that you have closed the client console and logged back in.