AnsweredAssumed Answered

Where is the information from the LDAP sync stored in the database?

Question asked by adam.snow on Dec 17, 2010
Latest reply on Dec 20, 2010 by adam.snow
Hello,

We sync all of our users in via the LDAP sync. In properties.xml there is a userAttributes section where you define what fields from LDAP you want synched in. Here is what we have:

<userAttributes>
<userName name="samAccountName"/>
<firstName name="givenName"/>
<lastName name="sn"/>
<fullName name="displayName"/>
<emailAddress name="mail"/>
<modifyTimeStamp name="modifyTimeStamp"/>
</userAttributes>


I am trying to figure out where the "fullName" gets stored in the database. In CMN_SEC_USERS there is a column called FULL_NAME, but it's blank. There are no errors in our LDAP sync, so I'm not sure if it is failing to sync in that field, or if it is stored somewhere else in the database. The field that we are pulling in from LDAP would have a value of something like this:

Doe, John S CTR USAF AFMC AFRL/CS-ABC

Not sure if there is a character limit or invalid character issue or something like that.

Thanks.

Outcomes