Query to get all the requests associated to a change (MSSQL & PGSQL)

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?