Hi

We have used below report to show us the Response and Resolution SLA this Quarter as per a previous forum post. After the latest upgrade to 8211 we get some weird figures that I believe is not correct. Both Response SLA and Resolution % is the same and it keeps on being the same everyday.

 

Priority	% Resolution Overdue	% Response Overdue	% Resolution Met	% Response Met
	Low	1.709401	1.709401	98.290598	98.290598

select pd.priorityname "Priority",CAST((sum(case(isoverdue) when 1 then 1.0 else 0.0 end)*100)/count(wo.workorderid) AS VARCHAR(20)) "% Resolution Overdue",CAST((sum(case(is_fr_overdue) when 1 then 1.0 else 0.0 end)*100)/count(wo.workorderid) AS VARCHAR(20)) "% Response Overdue",CAST(((count(wo.workorderid) - sum(case(isoverdue) when 1 then 1.0 else 0.0 end))*100)/count(wo.workorderid) AS VARCHAR(20)) "% Resolution Met",CAST(((count(wo.workorderid) - sum(case(is_fr_overdue) when 1 then 1.0 else 0.0 end))*100)/count(wo.workorderid) AS VARCHAR(20)) "% Response Met" from workorder wo left join workorderstates wos on wo.workorderid = wos.workorderid left join prioritydefinition pd on pd.priorityid = wos.priorityid where createdtime >= <from_thisquarter> and createdtime <= <to_thisquarter> group by pd.priorityname