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. 

          • 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 ...
          • Scheduling AD/LDAP import

            Steps to schedule an automatic import using AD/LDAP server: Requesting you to login as an admin to the SDP MSP application. Add the domains using "Windows Domain Scan" option under specific accounts.  Now navigate to Account Details>>Active ...
          • Query to show user additional fields along with requests

            MSSQL: SELECT wo.WORKORDERID AS "Ticket Number", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", technician.attribute_302 "Technician Business Unit", aau.FIRST_NAME AS "Requester", ...
          • How to diff of two Date& Time fields using FAFR

            If you have two date and time additional fields or default fields, and if you want to capture the difference between those two fields in Hours and minutes, then use the below script to capture the value in an additional field, Under the respective ...
          • Import and update Requester from CSV (Comma Separated Value) Files

            Import Requester from CSV (Comma Separated Value) Files You can also add requesters by importing from CSV files. To import requesters from CSV file   Step 1: Locate the CSV file Click Import from CSV link in the Requester List page. The Import ...