How to check who Installed/Enabled/Disabled/Uninstalled plugin in Jira
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
The article covers steps to identify the user details, who Installed/Enabled/Disabled/Uninstalled the plugin in Jira from the Jira Audit Log and from the Database using SQL query.
Environment
Jira v8.x and higher
Solution
There are two ways to check the action performed by a user:
Directly by Jira Audit log
By running SQL query in the Jira database
Option 1: Through Jira Audit Log
Date: Timestamp when the action was performed
Author: User who performed the action
Summary: Action performed
Affected Object(s): Plugin Name
Option 2: Through SQL query:
This was written and tested using a PostgreSQL DB, so you may need to tweak it depending on the database you are using.
ℹ️In the below query, need to use the appropriate PRIMARY_RESOURCE_ID, which you can get from ⚙️ → Manage apps → Manage apps, you can refer to the below screenshot:
Plugin Enabled:
1
select "ACTION", "USER_NAME", "ACTION_T_KEY", "CATEGORY", "ENTITY_TIMESTAMP","PRIMARY_RESOURCE_ID" from "AO_C77861_AUDIT_ENTITY" where "CATEGORY" like 'applications' and "ACTION" like 'App enabled' and "PRIMARY_RESOURCE_ID" like '<App key>';Plugin Installed:
1
select "ACTION", "USER_NAME", "ACTION_T_KEY", "CATEGORY", "ENTITY_TIMESTAMP","PRIMARY_RESOURCE_ID" from "AO_C77861_AUDIT_ENTITY" where "CATEGORY" like 'applications' and "ACTION" like 'App installed' and "PRIMARY_RESOURCE_ID" like '<App key>';Plugin Disabled:
1
select "ACTION", "USER_NAME", "ACTION_T_KEY", "CATEGORY", "ENTITY_TIMESTAMP","PRIMARY_RESOURCE_ID" from "AO_C77861_AUDIT_ENTITY" where "CATEGORY" like 'applications' and "ACTION" like 'App disabled' and "PRIMARY_RESOURCE_ID" like '<App key>';Plugin Uninstalled:
1
select "ACTION", "USER_NAME", "ACTION_T_KEY", "CATEGORY", "ENTITY_TIMESTAMP","PRIMARY_RESOURCE_ID" from "AO_C77861_AUDIT_ENTITY" where "CATEGORY" like 'applications' and "ACTION" like 'App uninstalled' and "PRIMARY_RESOURCE_ID" like '<App key>';Was this helpful?