Finding incoming Jira Service Management Data Center mail request from database
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
This article presents Jira DB Tables related to Incoming Email requests from Jira Service Management. If you are using a JSM mail processor (not a native Jira mail handler), please check the Troubleshoot Incoming Mail in Jira Service Management guide before checking the solution below.
Environment
JSM 4.x ,5.x., 10.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
1
2
3
4
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:
1
2
3
select * from "AO_2C4E5C_MAILITEMCHUNK";
select * from "AO_2C4E5C_MAILITEM";
select * from "AO_2C4E5C_MAILITEMAUDIT";>> Queries related to the mail handler(s) configuration:
1
2
3
4
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.
Was this helpful?