We have a process where a ticket may be assigned to one technician for one part of the task, and then assigned to another technician for different part of the task, then a 3rd person closes all tickets as the final signoff.  We want all technicians to get credit for working on that task.  If I run a report for all of "my completed tasks" for the month, I currently only get credit for those still assigned to me when it closed.  Is there a way to query all of the tickets that I worked on, not just the ones still assigned to me when it closed?  Something like "ticket contains TechnicianID X, and is closed"

I am decent with SQL queries, but by no means a power user of SQL. Any help is appreciated.

Thank you so much!

Bryan