resolved report

resolved report

Hi I am looking for a report that I can report on who resolved or closed a request.  I have got a report but I also want to select the date rang for the report.  The report that I have only show the resolved request that are created in a date range.

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

                  New to ADSelfService Plus?