Home Service Manager

Out the Box Report - Incident KPI

Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭
Reviewing the report there is a column for “Not Met Target Resolution Time”. 
This has always been blank for me but expected as we did not have any SLA information set. 
I setup SLA's for Resolution Date in my lab but when checking the report it is still blank. 
Reviewing the SQL statements it appears to be targeting 

Where (I.Status = 'IncidentStatusEnum.Resolved' OR I.Status = 'IncidentStatusEnum.Closed')
AND I.ResolvedDate IS NOT NULL
AND (I.ResolvedDate > I.TargetResolutionTime)

But when I check the columns TargetResolutionTime is blank down the board. 

Is this due to SLA Target being saved in the MT_System$SLA$Instance$TimeInformation table?

Comments

Sign In or Register to comment.