This document was generated from CDN thread
Created by: James Maudlin on 20-05-2011 09:53:41 AM
When you setup LDAP Sync, it will pull over all of the users in LDAP
that exist under the base OU provided. While the LDAP Sync may take a
certain period of time, it will take a bit longer for all of the user
profiles to be created.
Here is how to tell when profile creation is complete:
<ol>
<li>
Get the total number of records from the GROUP_ table where type_ = 0</li>
<li>
Get the total number of records from the LAYOUT table where friendlyurl = '/reporting'</li>
</ol>
These two numbers off by roughly three (3) when the profile creation is
complete. This is because there are three groups for "test",
"ciscosysadmin", and "ciscocomplianceofficer" that will not have
corresponding records in LAYOUT where friendlyurl = '/reporting'. This
is by design, as these users do not need to have a reporting structure
tab given that they are admin users.
Here are examples of the queries and output from a lab system. Replace "WebEx Social_2_1" with the user name for your WebEx Social system:
<code>SQL> select count(*) from WebEx Social_2_1.group_ where type_ = 0;</code>
<code>
</code>
<code> COUNT(*)</code>
<code>----------</code>
<code> 24</code>
<code>
</code>
<code>SQL> select count(*) from WebEx Social_2_1.layout where friendlyurl = '/reporting';</code>
<code>
</code>
<code> COUNT(*)</code>
<code>----------</code>
<code> 21</code>
