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
How to close associated incident requests of change request automatically
This post describes the use of a python script to close change that are in a specific stage using Custom Schedules. Use Case: There may be a scenario where number of Change Requests that have got closed and the associated incident is still in open ...
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 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 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 ...