Issue with Duplicate SLAs

[nabil]

Hello,
I am encountering an issue with SLAs: I have approximately 60,000 duplicate SLAs on incidents and changes between October and November.

All SLA definitions appear to be correctly configured, as well as the pause and stop conditions.

For now, I need to delete all duplicate SLAs. Do you have any suggestions on how to proceed with this action?
Best regards

[AshishKM]

Hi, 

Idealy if the SLA are not active and leave them as it is, plan only for active incidents.

Otherwise, you can plan to delete all duplicate SLA record which created later and keep the first one for each incident record. 

Write a Fix Script code for bulk delete, 

•    First retreive all incident record create during the given duration.
•    Iterate the result set
•    Within the interation check if there is 2 task_sla record exist then delete the one whice created later. 

-Thanks,

AshishKM