Question about SLAAUDITLOG table.

[Darren Laurel]

Hi Team,

I have a question regarding the database table where SLA values are stored. Based on available information, SLA data appears to be stored in the table AO_54307E_SLAAUDITLOG.

Would it be possible to confirm if the data-remaining-time field is located in this table as well?

Please note that I'm not very familiar with the database structure—this is purely for reporting purposes.

Thank you.

[Tuncay Senturk _Snapbytes_ · Accepted solution]

Hi @Darren Laurel 

No, there is not direct column named data-remaining-time in that table. That field is not (and cannot be) stored explicitly in the database. Instead, Jira calculates it dynamically using the SLA goal, current time, and pause/resume events. Because it must consider the current time, it cannot store the value in a field and update it every second.