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
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)
insert into sdldapfieldmap values (7, null, 'Organization', 'company', true);
5. Restart the services.
6. Import the users.
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 ...