Report request status changes (history)

Report request status changes (history)

We need a MSSQL query showing when the request status was changed, for a particular group and a particular request status.
 
Example:
Request status was "Open" on 15th Feb
Request status was "In Progress" on 18th Feb
Request status was "On Hold" on 20th Feb
Request status was "In Progress" on 25th Feb
Filters:



Group = "XYZ"
Request status is not "Closed"
 

                  New to ADSelfService Plus?