audit log from SQL query

Question

Hi people,

I need help to find some SQL query to list what user maked a roles change around a date in a project. Could anybody help me?

Thanks a lot

Niranjan · Answer

Hi @Adrian Gonzalez , From JIRA 8.8 the audit_log table in jira is called AO_C77861_AUDIT_ENTITY.

If you have the date of chnage and the project name, you should be able to check it in via as project role changes are captured in UI Audit log.