AD auto import shows technicians name instead of System
Cause of the issue : The schedule report and ad sync is using the same thread pool , so if a report has used the thread and then AD sync runs on the same thread incorrect user is updated in logs.
Workaround : Execute the following update query in the database,
update task_input set pool_id=(select threadpool_id from threadpool where threadpool_name='reports') where task_id in( select task_id from TaskEngine_Task where task_name='ScheduledReportTemplate');
Notes : Please take the backup before running the given query. Also monitor the AD sync for some time .
If the issue recreates need the following query outputs :
select * from task_input where task_id=(select task_id from TaskEngine_Task where task_name='ScheduledReportTemplate');
New to ADSelfService Plus?
Related Articles
How to import users from AD under a site value configured in different attributes of AD
Applicable for build - 14306 and above. SDP MSP uses attribute values while importing from AD. By Default , the officesite name in AD config is mapped to SDP MSP Site field. In case users wants to use different field for the same purpose, use its ...Script to create worklog automatically based on technicians leave
You need to install Python to achieve the below. You can follow this link to install Python. (A) Create two incident additional fields with Date/time property as below: 1) Start Date 2) End Date Associate these additional fields in your Request ...AD Scheduled Import : Option to verify AD attribute mapped to the Fields in SDP MSP
Option to verify AD attribute mapped to the Fields in SDP MSP in scheduled AD import. Once the setting is configured while doing a manual import, the same configuration will be mapped for scheduled AD import as well. Kindly use the below query to ...Issue when trying to import users from ActiveDirectory to ServiceDeskPlus MSP
Trace : '"Normal PING failed for the workstation : dc.internal:636. Result of ping : Ping request could not find host dc.internal:636. Please check the name and try again." Reason : Connectivity failed between application server and AD. Kindly ask ...Query to list account wise technicians and their respective support group details
Tested in: 14610 Compatible with: Both Postgres and MSSQL DB. Query 1: To return technicians and respective support group details from all accounts: SELECT ad.ORG_NAME AS "Account Name", au.FIRST_NAME AS "Technician Name", qd.QUEUENAME AS "Support ...