Thanks for your reply. We are actually seeing sla notifications sent for resolved cases in the life. So I wanted to look for a particular work object in this table (using case number) but I am unable to as the case number is in blob data and we can't expose the column. Can you think of any way this can be achieved or possible reason why the sla for resolved cases is still active?
You could modify the System-Queue-ServiceLevel InstanceList list view to display the data needed. You can add filters to limit your results. As for why the SLA would still exist for resolved cases, I would start by reviewing the history of those work objects to understand the steps taken prior to the resolution. Are there any patterns when the issue occurs?
The issue we are facing is that cases which are resolved are having sla expire notifications being sent for them. So want to stop the sla notifications being sent for resolved cases. Anything you can think of to resolve this.