How to Identify Active Objects AO Tables in Jira Application Database

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the server and data center platforms.

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.


tip/resting Created with Sketch.

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.

  1. Inspect the tables in your Jira database.
  2. All tables with a prefix of "AO" are a table created by a Jira Application.
  3. Compare the table name with the list below to identify which Jira Application uses the table.
Table PrefixUsed by
AO_54307EJira Service Management
AO_2C4E5CJira Service Management - Jira Email Processing Plugin
AO_9B2E3BJira Service Management - Automation
AO_A415DFJira Portfolio (Portfolio for Jira)
AO_82B313Jira Portfolio Team Management
AO_D9132DJira Portfolio Live Plans
AO_60DB71Jira Software (Jira Agile)
AO_E8B6CCJira DVCS Connector (Bitbucket)
AO_563AEEStreams Third Party Provider Plugin (com.atlassian.streams.streams-thirdparty-plugin)

AO_587B34

Hipchat for Jira
AO_88263FSupport Healthcheck Plugin
AO_733371Jira Inform (Batched notifications)
AO_8542F1

Assets (Insight)

AO_A415DFAdvanced Roadmaps (Portfolio for Jira)

Description

This article is a listing of common Active Objects (AO) table prefixes that can be found in the Jira Application Database.

You must have the ability to query your Jira database to make use of this information.

Last modified on Jan 27, 2023

Was this helpful?

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