ServiceDesk

We had some issues with tickets not applying an SLA. The tickets are now in a closed status, but I would like to find a way to update the ticket and add a completed SLA status. Is there a way to do this through SQL?

I've looked around the ProcessManager for the SLA Status field, but I'm unable to find the table that holds this information. Any ideas?

Thanks!

Steven B.

It looks like the majority of the SLA information for a ticket is in SLAProcess table.  The ReportLogProcessID column matches up with the same column in the ReportProcess table.  The SLAConfig column matches up with the same in SLAConfig table.  It looks like you're able to fill in the rest with whatever you want.  I would test in a development environment before running something in production.

Thanks Justin! Exactly what I needed.