How to import user additional fields using LDAP
In order to import additional fields or map any other fields in AD to the system fields, a row needs to be updated with the appropriate values
You can follow the below steps
1. Take a trimmed backup of the database.
4. Run the below query
insert into sdldapfieldmap values (7, null, 'SD_FIELD_NAME', 'AD_FIELD_NAME', true);
- The number 7 should be incremented for every row
- SD_FIELD_NAME is the field name in the application (Ex:Organization)
- AD_FIELD_NAME is the AD attribute name (Ex: company)
For example,
insert into sdldapfieldmap values (7, null, 'Organization', 'company', true);
5. Restart the services.
6. Import the users.
New to ADSelfService Plus?
Related Articles
Import additional fields from the Active Directory.
1.) You may need to first add additional fields under Admin\Users Additional-Fields \Common Additional-Fields if not already done. 2.) The configured additional field will appear in the "Import from Active Directory" window under Admin \ Active ...Script to Populate User Additional Field under Incident Template using FAFR
The script load the Requester Name under Incident Additional field ( As a pick list), by choosing the requester name under additional field the script populates the user additional field value. * Kindly create two additional fields under Admin -> ...How to populate requester details in request additional field
Requirement: Populate requester additional field information into request additional field. Usecase: Let us consider a scenario where certain employee details are imported from the Active Directory into User - Additional Fields. The business ...Criteria for User Account overwrite in Active Directory User Imports
While performing a user import from Active Directory, Criteria 1: ObjectGUID - If the ObjectGUID of a user account in ServiceDesk Plus MSP matches with the user account in Active Directory, then the record in ServiceDesk Plus MSP will be ...Query to retrieve Account details along with additional attributes, postal address and additional fields data
TESTED IN BUILDS: 14700 (Postgres) QUERY 1 - Without Account Additional Fields: select ad.ORG_NAME As "Account", org.description AS "DESCRIPTION", ad.LOGIN_WEBURI AS "LOGIN WEB URL", ad.LOGIN_URI AS "LOGIN URI", ad.SUPPORT_EMAIL AS "SUPPORT EMAIL", ...