Requester details

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'))








          • 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 ...
          • 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 ...
          • Contract Details

            SELECT mcdt.Contractid "Contract ID", mcdt.CONTRACTNAME "Contract Name", mcdt.comments "Description", contractcategory.Categoryname "Contract Type", LONGTODATE(mcdt.CREATEDDATE) "Created Time", LONGTODATE(mcdt.FROMDATE) "From Date", ...