Query to get Requesters details for each account

Query to get Requesters details for each account

PGSQL & MSSQL:

Execute the query under Reports->New Query Report and export it to the desired format.

select au.user_id "User Id", au.first_name "First Name", au.last_name "Last Name", sdu.isvipuser "VIP User", sdu.employeeid "Employee ID",sdu.jobtitle "Job Title",aci.emailid "Email ID",aci.landline "Telephone",aci.mobile "Mobile", sdo.name "Site Name", ad.org_name "Account Name",timedef.displayname "TimeZone" from aaauser au 
inner join sduser sdu on au.user_id = sdu.userid 
inner join requester r on r.ciid = sdu.ciid 
inner join ci ci on ci.ciid = r.ciid 
left join sdorganization sdo on ci.siteid = sdo.org_id 
left join accountsitemapping asm on sdo.org_id=asm.siteid 
left join accountdefinition ad on ad.org_id=asm.accountid 
left join aaausercontactinfo auci on auci.user_id = sdu.userid 
left join aaacontactinfo aci on aci.contactinfo_id = auci.contactinfo_id
left join sduserprofile sduprof on sduprof.userid=sdu.userid
left join timezonedefinition timedef on timedef.timezoneid=sduprof.timezoneid where sdu.status='ACTIVE' and asm.accountid in ($Account);

Note: To get account specific results, please select the account from the drop down above in the query reports page.

      • Related Articles

      • Query to export All Requesters from All Accounts

        SELECT AaaUser.USER_ID,AaaUser.FIRST_NAME "FullName",AaaLogin.NAME "LoginName",AaaLogin.DOMAINNAME "Domain",AaaContactInfo.EMAILID "Email",DepartmentDefinition.DEPTNAME "Department",SDOrganization.NAME ...
      • Enable Account Details for basic technicians

        Account Details is an icon that is found right next to the Account drop-down in the application.  For 9.4 Builds By default Account Details tab is shown ONLY for SDAccountAdmin and SDAdmin roles.   1. Take a trimmed backup/MSSQL Backup/Server ...
      • Query to get Asset contract and its details

        SELECT mcdt.Contractid "URL Contract ID",        mcdt.customcontractid "Custom contractid in details page",        mcdt.CONTRACTNAME "Contract Name",       aao.NAME "Maintenance Vendor Name",        LONGTODATE(mcdt.FROMDATE) "From Date",       ...
      • API -Listing Account Specific Requesters

        1. Encode (Used for GET calls alone) the below values thereby replacing the Account Name as per yours : { "operation":{ "details":{ "accountname": "Sample Account", "sitename": "0" } } } 2. The site name value is set as "0", which will list the ...
      • Configuring Login Web URL and Login URI for an account

        What is a login URL and login URI under accounts? Login Web URL: A login URL is the locator of a resource (Which can be used to locate the address of a resource in the internet). Login URI: It is the identifier, which is used to identify any resource ...