Requester details
This report is used to find the Requester 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", SDUser.JOBTITLE "JobTitle", 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 LEFT JOIN HelpDeskCrew ON SDUser.USERID=HelpDeskCrew.TECHNICIANID LEFT JOIN AaaLogin ON AaaUser.USER_ID=AaaLogin.USER_ID WHERE ((HelpDeskCrew.TECHNICIANID IS NULL) AND (SDUser.STATUS = 'ACTIVE'))
New to ADSelfService Plus?
Related Articles
How to populate requester details in request additional field
Requirement: Populate requester additional field information into request additional field. Usecase: Let us consider a scenario where certain employee details are imported from the Active Directory into User - Additional Fields. The business ...How to populate requester details in request additional field.
This sample script is to populate the requester details in a request additional field. Based on the requester name selected, we can fetch the user additional field informations using Field and Form Rules (FAFR) and populate the content in request ...API -Listing Requester details based on Requester name
1. Encode the below value, thereby replacing the Account, Site Name, followed by the Requester name in "Searchstring": { "operation": { "details": { "accountname": "Sample Account", "sitename": "Sample Site", "searchstring": "Alex Smith" } } } 2. ...Populate requester details in request additional field using business rule - Deluge
This sample script is to populate the requester details in a request additional field. Based on the requester name selected, we can fetch the user additional field information and populate the content in request additional field. Refer to this link ...How to populate requester details in request additional field using business rule.
This sample script is to populate the requester details in a request additional field. Based on the requester name selected, we can fetch the user additional field information and populate the content in request additional field. Use Case: Let us ...