I ended up building a report in our reporting tool that I connected to RT’s DB. I wasn’t able to figure out how to do within RT without custom coding.
The way I connected the data to get what I was looking for… (caveat, this is how I was able to get it, I’m not sure if it’s accurate yet…)
Transactions.New Value = Users.id —> this is to get the new owner’s username from Users.name
Transactions.Old Value = Users.id --> to get the old username, I only used this for debugging and validating what I was seeing.
Transactions.ObjectId = Tickets.id --> to get the Ticket number and Subject line.
Then the where clause would be on the Transactions.New Value = username.
This returns all the transactions records that represent the action of updating the owner to the new username.
For some reason I haven’t figured out yet, it shows duplicate records for every single transaction, but this gave me enough info to answer the questions I was being asked.