Checking messages processed by Jira's incoming mail
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
There are two incoming mail jobs in Jira:
Each mechanism works a bit differently and uses different tables. Check below how to find the history.
Solution
For Jira's native mail handler, we can see the processed messages by running this SQL query:
1 2 3 4 5 6 7
SELECT ni.notificationtype ,ni.emailaddress ,concat(p.pkey,'-',i.issuenum) as issue_key ,i.created as issue_created_date FROM notificationinstance ni JOIN jiraissue i on ni.source=i.id JOIN project p on p.id=i.project
For Jira Service Management, we can either use the UI or a SQL query.
For the UI option, just navigate to Administration > Applications > Email requests and click on the "View log" option towards the bottom of the page:
For a database perspective, just query the
AO_2C4E5C_MAILITEMAUDIT
table:1
SELECT * FROM "AO_2C4E5C_MAILITEMAUDIT"
1
SELECT * FROM AO_2C4E5C_MAILITEMAUDIT
Was this helpful?