JIRA Service Desk SLA Extract

Question

Hi, does anyone have the SQL required to extract all of the JIRA SD SLA's from the database along with their start and stop status/s?

Thanks,

Stephen

Isabel Alvarez Hoyos · Answer

Hola,

Localizaron la consulta necesaria para extraer los datos de los sla de los diferentes tickets?

Andy Heinzer · Answer

I recommend checking out the KB How to Troubleshoot SLAs in JIRA Service Desk. It contains a number of SQL queries for locating SLAs in Jira.  It also has more details about the goals and how you can find them via SQL.