How to import user additional fields using LDAP

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?

        Resources

            • 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 -> ...
            • 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 ...
            • Active directory unable to sync

              Error in logs : Error trace : 15:24:14:746]|[02-09-2022]|[com.adventnet.servicedesk.asset.discovery.IpUtil]|[INFO]|[640]: Java PING Result for the workstation : 10.64.72.13.  Result of ping : false.| ...
            • Query to show account additional fields _ Details required

              We Need to know whether that is a common account additional fields or add attribute under individual account.   So please send us the following screenshots.   1. Admin-> Account additional fields list view page.   2. Accounts->Edit account and show ...