How to Identify Active Objects AO Tables in Jira Application Database
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
Purpose
This article explains how you can easily identify the plugin and/or vendor of Active Objects (AO) tables that can be found in the Jira Application Database. There is an related KB of List of Jira Server AO table names and vendors where you can find a listing of the most popular plugins and the AO tables they create.
You must have the ability to query your Jira database to make use of this information.
Active Objects tables are used by Jira Applications and plugins to store data. The table prefix can be used to determine what plugin or Jira Application feature the table is used for.
- As an example, tables that begin with "AO_54307E" are related to Jira Service Management.
Solution
Active Objects Table Prefixes
Direct database modifications are discouraged and are not supported by Atlassian. Always back up Jira's database before performing any modifications
For a current list of Add-ons and their associated tables specific to your environment you can go to System > Advanced > Plugin Data Storage page in Jira.
You must have the ability to query your Jira database to make use of this information.
- Inspect the tables in your Jira database.
- All tables with a prefix of "AO" are a table created by a Jira Application.
- Compare the table name with the list below to identify which Jira Application uses the table.
| Table Prefix | Used by |
|---|---|
| AO_54307E | Jira Service Management |
| AO_2C4E5C | Jira Service Management - Jira Email Processing Plugin |
| AO_9B2E3B | Jira Service Management - Automation |
| AO_A415DF | Jira Portfolio (Portfolio for Jira) |
| AO_82B313 | Jira Portfolio Team Management |
| AO_D9132D | Jira Portfolio Live Plans |
| AO_60DB71 | Jira Software (Jira Agile) |
| AO_E8B6CC | Jira DVCS Connector (Bitbucket) |
| AO_563AEE | Streams Third Party Provider Plugin (com.atlassian.streams.streams-thirdparty-plugin) |
AO_587B34 | Hipchat for Jira |
| AO_88263F | Support Healthcheck Plugin |
| AO_733371 | Jira Inform (Batched notifications) |
| AO_8542F1 | Assets (Insight) |
| AO_A415DF | Advanced Roadmaps (Portfolio for Jira) |