Prepare data for Atlassian support
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.