How to pick latest sla record while generating report on task_sla incase multiple SLAs exist.

[Mahesh Kumar2]

Hi All,

I am trying to create a report on task_sla table. I have selected assigned_to as groupBy in the report. for example: if there are 83 incidents, i am getting 86 records under one user. When i checked, there are multiple response SLAs present for some incidents it might be because of priority change or assignment group change. both SLAs are in completed state. So what filters we can apply to consider only latest SLA in such cases since final SLA belongs to latest Assigned to user and record is showing under him. Any idea how to achieve this?

[shloke04]

Hi @Mahesh Kumar2 ,

You will need to make use of a script here to achieve your requirement. Below blog talks about the same on how you can achieve this:

https://www.servicenow.com/community/platform-analytics-articles/how-to-create-a-report-that-shows-o...

[Mahesh Kumar2]

Thanks for the suggestion. If i follow above script, to create a report of all incidents(at least for last 2 years). It will loop all the incidents and loop again all associated SLAs to pick latest. It might impact system performance whenever the report is triggered as it is going into a dashboard. Is there any other way?