We are looking for a MSSQL query report that returns both the group currently assigned to the request and the group who initially received the request (= first entry point). 

Example workflow:

Group A => Group B => Group A => Group C => Group D

The query should return:

current group = Group D

first group = Group A (not Group C because that is the previous group, not the first group)

Who has a suggestion?

Best regards,
Demetrius