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

Mahesh Kumar2
Tera Expert

‎01-10-2024 11:00 PM

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?

0 Helpfuls
  • 250 Views
2 REPLIES 2

shloke04
Kilo Patron

‎01-11-2024 12:08 AM

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...

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke
0 Helpfuls

Mahesh Kumar2
Tera Expert
In response to shloke04

‎01-11-2024 12:49 AM

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?

0 Helpfuls