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
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 M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?