Prepare data for Atlassian support

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

If you encounter problems with Jira automation and need to contact Atlassian support, try to provide the data described on this page. It will help us find and solve your issue faster.

Database content

Database tables in CSV

Make dumps of the following database tables to CSV files:

  • AO_589059_RULE_STAT_ROLLUP_HR

  • AO_589059_RULE_STAT_ROLLUP_MIN

  • AO_589059_RULE_STAT_ROLLUP_DAY

Database items

Rules executed in the last 24 hours and execution count

Run the following query to get this data:

SELECT AI."OBJECT_ITEM_NAME" AS Rule_Name,
       sum(CASE
               WHEN AI."CATEGORY" = 'SUCCESS' THEN 1
               ELSE 0
           END) AS Successful_Executions,
       sum(CASE
               WHEN AI."CATEGORY" = 'NO_ACTIONS_PERFORMED' THEN 1
               ELSE 0
           END) AS No_Actions_Performed
FROM jiraschema."AO_589059_AUDIT_ITEM" AI
JOIN jiraschema."AO_589059_AUDIT_ITEM_ASC_ITEM" AIAI ON AI."ID" = AIAI."AUDIT_ITEM_ID"
WHERE 1=1
    AND AI."CATEGORY" != 'CONFIG_CHANGE'
    AND AI."CREATED" >= DATEADD(DAY, -1, GETDATE())
GROUP BY AI."OBJECT_ITEM_NAME";

Rule actors and execution count

Run the following query to get this data:

SELECT cwu.user_name AS Username,
       count(AI."ID") AS Num_Of_Executions
FROM jiraschema."AO_589059_AUDIT_ITEM" AI
JOIN jiraschema."AO_589059_AUDIT_ITEM_ASC_ITEM" AIAI ON AI."ID" = AIAI."AUDIT_ITEM_ID"
JOIN jiraschema.app_user au ON AI."AUTHOR_KEY" = au.user_key
JOIN jiraschema.cwd_user cwu ON au.lower_user_name = cwu.lower_user_name
WHERE 1=1
    AND AI."CATEGORY" != 'CONFIG_CHANGE'
    AND AI."CREATED" >= DATEADD(DAY, -1, GETDATE())
GROUP BY cwu.user_name;

Rules with highest execution count

Run the following query to get this data:

SELECT top 300 AI."OBJECT_ITEM_NAME" AS Rule_Name,
           AI."DURATION"
FROM jiraschema."AO_589059_AUDIT_ITEM" AI
JOIN jiraschema."AO_589059_AUDIT_ITEM_ASC_ITEM" AIAI ON AI."ID" = AIAI."AUDIT_ITEM_ID"
WHERE 1=1
    AND AI."CATEGORY" != 'CONFIG_CHANGE'
    AND AI."CREATED" >= DATEADD(DAY, -1, GETDATE())
ORDER BY AI."DURATION" DESC; 

Events that triggered rules and execution count

Run the following query to get this data:

SELECT AI."EVENT_SOURCE",
       count(*) AS Times_Triggered
FROM jiraschema."AO_589059_AUDIT_ITEM" AI
JOIN jiraschema."AO_589059_AUDIT_ITEM_ASC_ITEM" AIAI ON AI."ID" = AIAI."AUDIT_ITEM_ID"
WHERE 1=1
    AND AI."CATEGORY" != 'CONFIG_CHANGE'
    AND AI."CREATED" >= DATEADD(DAY, -1, GETDATE())
GROUP BY Event_Source
HAVING count(*) >= 1;

Audit log export

For more info on how to export your audit log, see Use the audit log.

Automation rules export

For more info on how to export your automation rules to a JSON file, see Export and import automation rules.

Support ZIP

For more info on how to create a support ZIP, see one of the following pages:

Jira thread dump

For more info on how to create a thread dump, see Create thread dumps.

Automation service limits

If you changed the default service limits, the list of current ones will be useful. For more info on how to get it, see Automation service limits.


Last modified on Jun 21, 2022

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.