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:

      (Auto-migrated image: description temporarily unavailable)
    • For a database perspective, just query the AO_2C4E5C_MAILITEMAUDIT table:

      1 SELECT * FROM "AO_2C4E5C_MAILITEMAUDIT"
      1 SELECT * FROM AO_2C4E5C_MAILITEMAUDIT

Updated on February 28, 2025

Still need help?

The Atlassian Community is here for you.