report to see who picked up a ticket

Is there a query to get a report to see who in my Helpdesk support group has picked up a ticket within the last week?

MSSQL is our DB

thanks!