Finding incoming Jira Service Management Data Center mail request from database
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
This article presents Jira DB Tables related to Incoming Email requests from Jira Service Management. Please check the Troubleshoot incoming mail in Jira Service Management guide if you are using JSM mail processor (not a native Jira mail handler) before checking the solution below.
Environment
JSM 4.x and 5.x.
Solution
>> Queries related to the Mail Puller and Mail Processor jobs: Check for Mail jobs are successfully running and Returns data related to the mail queue service run time. S in the “run_outcome” column means success
select * from clusteredjob where job_id like '%Puller%';
select * from clusteredjob where job_id like '%Processor%';
select * from rundetails where job_id like '%Puller%';
select * from rundetails where job_id like '%Processor%';
>> Queries related to the mails processed in the database:
select * from "AO_2C4E5C_MAILITEMCHUNK";
select * from "AO_2C4E5C_MAILITEM";
select * from "AO_2C4E5C_MAILITEMAUDIT";
>> Queries related to the mail handler(s) configuration:
select * from "AO_54307E_EMAILCHANNELSETTING";
select * from "AO_2C4E5C_MAILCONNECTION";
select * from "AO_2C4E5C_MAILCHANNEL";
select * from "AO_2C4E5C_MAILHANDLER";
Those tables will give all email settings information in the database also with the whole coming user email data.