Query to List down Account and corresponding sites and its requesters (MSSQL & PGSQL)
*Tested in builds from PGSQL (14300) or MSSQL (14306)
*Applicable for 14500 builds
For Accounts and Site:
select adef.org_name "Account",sdo.name "Site Name" from accountdefinition adef
left join accountsitemapping asm on adef.org_id=asm.accountid
Left Join Sitedefinition sdef on asm.siteid=sdef.siteid
LEFT JOIN sdorganization sdo on sdef.siteid=sdo.org_id order by adef.org_id
To get the requester details of the corresponding Account / Sites.
For Requesters:
Goto Reports -> New custom report -> Select a module -> CMDB -> select User (filterby) -> Proceed.
Now choose Account / Site / CI name in the columns and run the report
New to ADSelfService Plus?
Related Articles
Query to export All Requesters from All Accounts (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Execute the below query under Reports > New Query Reports: SELECT AaaUser.USER_ID,AaaUser.FIRST_NAME "FullName",AaaLogin.NAME "LoginName",AaaLogin.DOMAINNAME "Domain",AaaContactInfo.EMAILID ...Query to find technicians with login enabled along with sites and account associated (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Please go to Reports-New Query reports and execute this query. select aau.User_id,aau.first_name "Technician Name", aal.name "Login Name", aal.Domainname "Domain",sdo.name "Associated ...Query to show technicians associated accounts, sites and Support groups - (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) 1.Technicians and associated Accounts/Sites: select aau.User_id, aau.first_name "First Name", sdu.lastname "Last Name", aal.name "Login Name", AaaContactInfo.EMAILID "Email Address",sdu.jobtitle "Job ...Query to find out who created Accounts (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) Execute the below queries under Reports->New Query Report. select org_id, org_name from accountdefinition ad where ad.org_name in('Requester Name', 'Palanivel Palras','Muhammad Nadeem Khan') Note down ...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 ...