Technician

Technician

This report is used to find the Technician complete details. 


SELECT AaaUser.USER_ID,
       AaaUser.FIRST_NAME "FullName",
       AaaLogin.NAME "LoginName",
       AaaLogin.DOMAINNAME "Domain",
       AaaContactInfo.EMAILID "Email",
       DepartmentDefinition.DEPTNAME "Department",
       SDOrganization.NAME "Site",
       AaaContactInfo.LANDLINE "Phone",
       AaaContactInfo.MOBILE "Mobile" FROM AaaUser
LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID
LEFT JOIN AaaUserContactInfo ON AaaUser.USER_ID=AaaUserContactInfo.USER_ID
LEFT JOIN AaaContactInfo ON AaaUserContactInfo.CONTACTINFO_ID=AaaContactInfo.CONTACTINFO_ID
LEFT JOIN DepartmentDefinition ON UserDepartment.DEPTID=DepartmentDefinition.DEPTID
LEFT JOIN SiteDefinition ON DepartmentDefinition.SITEID=SiteDefinition.SITEID
LEFT JOIN SDOrganization ON SiteDefinition.SITEID=SDOrganization.ORG_ID
INNER JOIN SDUser ON AaaUser.USER_ID=SDUser.USERID
INNER JOIN HelpDeskCrew ON SDUser.USERID=HelpDeskCrew.TECHNICIANID
LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID
WHERE (SDUser.STATUS = 'ACTIVE')





                  New to ADSelfService Plus?

                    • Related Articles

                    • Technician group

                      This report is used to get the associated groups of the technicians. SELECT AaaUser.FIRST_NAME "FullName", (SDOrganization.NAME) "Site", (qd.queuename) "Group" FROM AaaUser LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID LEFT JOIN ...
                    • Request violated by technician

                      This report used to find the technician who violated the request. If the request/incident already has a violation and is reassigned to another technician the new technician assumes the violation instead of the technician that the violation occurred.  ...
                    • Technician change from history

                      This report is used to find who changed the Technician and how many technician handled the request.  To make any changes to a query, refer to the KB article below. ...
                    • Can we restore a deleted technician as it appears under deleted users?

                      Once a technician user account is deleted, the same user account cannot be added back. When a technician is deleted, we do not delete all the traces of the user. For historic purposes, the user will be available in certain records. create a new user ...
                    • How to Generate Technician API Key

                      Click on Technician profile(top right corner in the UI)>>Generate API key You can also specify validity of the API key being generated by selecting the options below.