How to check the mail audit log outside of the Jira UI
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Where is the data from the mail audit log of Jira Service Desk ?
In the UI you can find that data via ⚙ > Applications > JIRA Service Desk > Email Requests > View Log > Processing Log
But where to find the source for this data, so that you can check on the results using scripts or similar.
Environment
All Jira Service Desk / Jira Service Management
Solution
The data can be found in the table AO_2C4E5C_MAILITEMAUDIT
To extract the data use a query similar to this:
select distinct "FROM_ADDRESS", "MESSAGE", "RESULT_STATUS" from "AO_2C4E5C_MAILITEMAUDIT" group by "FROM_ADDRESS", "MESSAGE" , "RESULT_STATUS" ;
This will give you the sender email and the result of the operation.