Query to get all the requests associated to a change (MSSQL & PGSQL)
Tested in builds PGSQL (14300) or MSSQL (14306)
Postgres Query:
select chd.ChangeID "Change ID",
chd.title "Change name",
wo.workorderid "Request ID",
wo.title "Request Subject" from incidentcausedbychange incach
left join ChangeDetails chd on incach.changeid = chd.changeid
left join workorder wo on incach.WORKORDERID = wo.workorderid
New to ADSelfService Plus?
Related Articles
Query to show Problems, its associated incidents and change_ (MSSQL)
Tested in Build MSSQL (14306) SELECT woproblem.PROBLEMID AS "Problem ID", woproblem.TITLE AS "Problem Title", "priodef"."PRIORITYNAME" AS "Problem Priority", "urgdef"."NAME" AS "Problem Urgency", "statdef"."STATUSNAME" AS "Problem Status", ...
Query to show requests and its associations with Problems, Changes and Projects (MSSQL)
Working on Builds: 14500 and above Database: MSSQL SELECT wo.WORKORDERID AS "Request ID", pim.problemid "Associated Problem ID", icm.changeid "Associated Change ID", wtp.projectid "Associated Project ID", CASE WHEN (wo.is_catalog_template) = 'false' ...
Query for request attachment details (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Requests with Attachment, its name and path SELECT ad.ORG_NAME AS "Account", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", ti.FIRST_NAME AS "Technician", sa.ATTACHMENTNAME "Attachment ...
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 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 ...