How to check the mail audit log outside of the Jira UI
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
要約
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.
環境
All Jira Service Desk / Jira Service Management
ソリューション
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.