Query to find Service Template Associated to "All Accounts" (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306)
Kindly execute the query under Report -> New Query Report to get the list of Service Template Associated to All Accounts.
select sd.name "Service Name", rtl.templatename "Service Template Name", rtl.comments "Template description", rtf.description "Description field" from requesttemplate_list rtl
LEFT JOIN requesttemplate_fields rtf ON rtl.templateid=rtf.templateid
LEFT JOIN ServiceTempAccMapping b ON rtl.TEMPLATEID = b.TEMPLATEID
LEFT JOIN Categorydefinition cd ON rtf.categoryid=cd.categoryid
LEFT JOIN subcategorydefinition scd ON rtf.subcategoryid=scd.subcategoryid
LEFT JOIN itemdefinition id ON rtf.itemid=id.itemid
LEFT JOIN Servicedefinition sd ON rtl.parent_Service=sd.serviceid
where is_catalog_template='true' AND rtl.isdeleted='false' and accountid is NULL order by 1
New to ADSelfService Plus?
Related Articles
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 ...Query to get list of service request templates created with Tasks associated to it. (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Execute the given query below from Reports-->New query report select sd.name "Service Name", rtl.templatename "Service Template Name", rtl.comments "Template description", rtf.description ...Query to show service catalog template details (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) select sd.name "Service Name", rtl.templatename "Service Template Name", rtl.comments "Template description", rtf.description "Description field" from requesttemplate_list rtl LEFT JOIN ...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 ...