Time spent for group on the same Request ID

Time spent for group on the same Request ID

Hi,

I need a report with the time spent for group in the same Request ID.

For example:

On Request ID #2 for 30 minutes the Level 1 group was the responsible for this request, but at minute 31 the level 1 group assign Request ID #2 to Level 2 group.

So.. i need a report like below


Requet ID  |  Subject  |  Time Spent - Group 1  |  Time Spent Group 2


Thanks

SDP 9.1
MSSQL

                  New to ADSelfService Plus?