So basically I am after who resolved what this week or last week or specific date rang.
The below is the report I have but is only showing the created requests.
select wo.workorderid "Request id",(re.first_name) "Technician",
case when woh.operation='RESOLVED' then 'Resolved'
when woh.operation='CLOSE' then 'Closed'
when woh.operation='UPDATE' then 'Modify' else null end "Operation" from workorderhistory woh
left join workorder wo on woh.workorderid=wo.workorderid
left join aaauser re on woh.operationownerid=re.user_id
INNER JOIN HelpDeskCrew ON re.USER_ID=HelpDeskCrew.TECHNICIANID where woh.operation in ('RESOLVED','CLOSE') and
dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.createdtime/1000),'1970-01-01 00:00:00') >= convert(varchar,'2018-10-19 00:00',21) and dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.createdtime/1000),'1970-01-01 00:00:00') <= convert(varchar,'2018-10-25 23:59',21) order by 2,3