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










          New to M365 Manager Plus?
          New to M365 Manager Plus?
            New to RecoveryManager Plus?
            New to RecoveryManager Plus?
              New to Exchange Reporter Plus?
              New to Exchange Reporter Plus?
                New to SharePoint Manager Plus?
                New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial
                    Start your free trial

                      • Related Articles

                      • 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", ...

                      • Purchase details

                        SELECT po.POCUSTOMID AS "PO Number", MAX(po.PONAME) AS "PO Name", MAX(po.TERMS) AS "PO Terms", LONGTODATE(MAX(po.DATEORDERED)) AS "Ordered Date", MAX(pos.STATUSNAME) AS "PO Status", MAX(poa.FIRST_NAME) AS "Purchase Requester", MAX(po.SHIPTO) AS "Ship ...

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

                      • Converting a requester to a technician

                        Please follow the below steps to convert a requester to a technician. Step 1 (If the requester is already added under MSP Requester): 1) Log in as an administrator. 2) Go to Admin tab>>MSP Details>>MSP Requester(Left hand column). 3) Click on the ...

                      • Purchase order approval details

                        SELECT po.POCUSTOMID AS "PO Number", max(po.PONAME) AS "PO Name", max(poa.FIRST_NAME) AS "Purchase Requester", longtodate(max(po.DATEORDERED)) AS "Ordered Date", longtodate(max(po.DATEREQUIRED)) AS "Required Date", max(pos.STATUSNAME) AS "PO Status", ...
                      Related Products