Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to check your Add-On (app) database usage - Active Objects (AO) tables

When marketplace developers need to store data related to their apps, they can do this via Active Objects tables (database tables that are prefixed with AO_ then a 6 character hex code which seems to be unique for that app, then another underscore and the table name itself (set by the developer).

When reviewing your environments app usage (could be to get an indication of how used an app is as part of renewal discussions, maybe you're investigating it as part of a performance discussion, maybe your DBA has concerns about table size, maybe you just want to know what's happening in the environment.

For any apps that are still installed, there's a "Plugin Data Storage" page that's available to sys admins that will give you a breakdown of the vendor, the AO_ tables and a count of how many rows in each of those tables.

Below links are for Server/DC

NB: Cannot find equivalents for Crowd or Bamboo

What you may see on this page though is a list of AO_ tables at the top marked either <unknown> or just blank - these are AO tables that were created by an app, but that app is no longer installed, and it seems like the metadata that maps the AO to the app is removed with it. The AO tables are left as uninstalling an app does not remove the underlying data. This is great if you're uninstalling to resolve an issue, or accidentally removing, but long term, you may want to clean up the AO tables for apps you'll never use again.

 

Unfortunately, I'm yes to find a good/reliable way to find the AO to app mapping - you can Google/search community.atlassian.com for the AO_ABCDEF style table name and you may get a hit, but, it's far from guaranteed.

 

What I'd like to start with this thread is a community sourced reference page for the AO_ tables and their apps that will be maintained over time (or someone from Atlassian or the vendor community can chime in with a better location).

I'll add a reply for each application with a summary of the tables and apps that I'm aware of (and a list of the AO tables our environment has an unknown as well) and if anyone is able to provide other mappings, then please reply to the applications thread with the AO prefix and app name and I'll monitor and edit the summary table moving forward.

 

CCM

 

 

 

 

 

9 comments

Jira ActiveObjects mappings:

 

AO_00B950 - Profields - Project Custom Fields
AO_013613 - System Plugin: Tempo Core
AO_0201F0 - Service Desk Reports Plugin
AO_050302 - Statuspage for Jira Service Desk
AO_098293 - <unknown>
AO_0AC321 - jira-optimizer-plugin
AO_21D670 - Atlassian Whitelist Core Plugin
AO_21F425 - Atlassian Notifications
AO_23011C - InProduct translation for JIRA
AO_275653 - <unknown>
AO_2C4E5C - jira-email-processor-plugin
AO_2D3BEA - System Plugin: Tempo Planning API
AO_2F1435 - <unknown>
AO_319474 - psmq-plugin
AO_38321B - Atlassian Navigation Links Plugin
AO_3A112F - Configuration Manager Core Bundle
AO_3B1893 - Atlassian Jira - Plugins - Mail Plugin
AO_3FB43F - <unknown>
AO_4789DD - Atlassian Troubleshooting and Support Tools
AO_47EAC7 - <unknown>
AO_4AEACD - Atlassian Jira - Plugins - WebHooks Plugin
AO_4B00E6 - Adaptavist ScriptRunner for JIRA
AO_4D28DD - Test Management for JIRA
AO_4E8AE6 - Service Desk Notifications Plugin
AO_54307E - JIRA Service Desk
AO_544E33 - <unknown>
AO_550953 - Jira Projects Plugin
AO_563AEE - Streams Third Party Provider Plugin
AO_56464C - Service Desk Approvals Plugin
AO_575BF5 - Atlassian Jira - Plugins - Development Integration Plugin
AO_587B34 - Hipchat for Jira
AO_5FB9D7 - Atlassian Hipchat Integration Plugin Core
AO_60DB71 - JIRA Agile
AO_6AD1C6 - <unknown>
AO_733371 - Jira inform - event plugin
AO_78C957 - <unknown>
AO_7A2604 - JIRA Working Hours Plugin
AO_7C2234 - JSU - Suite Utilities for Jira
AO_7DB66D - <unknown>
AO_82B313 - Portfolio Team Management
AO_86B55C - Out Of Office Assistant
AO_86ED1B - Tempo Timesheets
AO_88263F - <unknown>
AO_8AC478 - BigGantt
AO_8BAD1B - <unknown>
AO_97EDAB - Atlassian Jira - Plugins - Invite User
AO_9B2E3B - Service Desk Automation Plugin
AO_A0B856 - Atlassian WebHooks Plugin
AO_A415DF - Portfolio for Jira
AO_A44657 - <unknown>
AO_A9375F - My ToDo
AO_AEFED0 - System Plugin: Tempo Teams
AO_B9A0F0 - Project Templates Plugin
AO_BA68D6 - <unknown>
AO_BD1E3C - <unknown>
AO_BEE373 - System Plugin: Tempo Platform - JIRA
AO_C16815 - Atlassian Jira - Plugins - Diagnostics Plugin
AO_C3C6E8 - System Plugin: Tempo Accounts
AO_C52AAA - <unknown>
AO_C7F17E - Service Desk Lingo Plugin
AO_CC6AEB - <unknown>
AO_CFF990 - Atlassian Jira - Plugins - Transition Trigger Plugin
AO_D4AF4C - Mobility for JIRA
AO_D530BB - Service Desk Canned Responses Plugin
AO_D9132D - Portfolio Live Plans
AO_DA6AB9 - <unknown>
AO_E8B6CC - Jira DVCS Connector Plugin
AO_ED669C - SAML for Atlassian Data Center
AO_F1B27B - Atlassian Timed Promise Plugin

Like # people like this

Bitbucket ActiveObjects mappings

 

AO_02A6C0 - Bitbucket Server - Repository Ref Sync
AO_0E97B5 - Bitbucket Server - Repository Shortcuts
AO_1B80C1 - SU for Bitbucket
AO_31728E - Adaptavist ScriptRunner for Bitbucket Server
AO_33D892 - Bitbucket Server - Jira Integration
AO_371AEF - Bitbucket Server - Webhooks
AO_38321B - Atlassian Navigation Links Plugin
AO_38F373 - Bitbucket Server - Comment Likes
AO_4789DD - Atlassian Troubleshooting and Support Tools
AO_58E6CE - Bitbucket Hipchat Integration Plugin
AO_5F844E - <unknown>
AO_5FB9D7 - Atlassian Hipchat Integration Plugin Core
AO_616D7B - Bitbucket Server - Branch
AO_6292E3 - Awesome Graphs for Bitbucket Server
AO_6978BB - Bitbucket Server - Ref Restriction
AO_777666 - Bitbucket Server - Jira Development Integration
AO_7C4561 - Office 365 Connector
AO_811463 - Bitbucket Server - Git LFS
AO_8E6075 - Bitbucket Server - Mirroring Upstream Capability
AO_92D5D5 - Bitbucket Server - Notification
AO_9DEC2A - Bitbucket Server - Default Reviewers
AO_A0B856 - Atlassian Webhooks Plugin
AO_A21099 - <unknown>
AO_B586BC - Bitbucket Server - GPG Commit Signatures
AO_BD73C3 - Bitbucket Server - Audit
AO_C716BC - <unknown>
AO_CFE8FA - Bitbucket Server - Build
AO_D6A508 - Bitbucket Server - Importer
AO_E5A814 - Bitbucket Server - Access Tokens
AO_ED669C - SAML for Atlassian Data Center
AO_F4ED3A - Atlassian Connect Plugin
AO_FB71B4 - Bitbucket Server - SSH

Like # people like this

Confluence ActiveObjects mappings

 

AO_098293 - <unknown>
AO_187CCC - Confluence Space IA Plugin
AO_21D670 - Atlassian Whitelist Core Plugin
AO_21F425 - Atlassian Notifications
AO_26C053 - Comala Workflows
AO_26DB7F - Confluence Hipchat Integration Plugin
AO_2F1435 - <unknown>
AO_38321B - Atlassian Navigation Links Plugin
AO_42E351 - <unknown>
AO_4789DD - Atlassian Troubleshooting and Support Tools
AO_4DC94A - No Email Storm
AO_54C900 - Confluence Create Content Plugin
AO_563AEE - Streams Third Party Provider Plugin
AO_5F3884 - Confluence and Jira Content Connector
AO_5FB9D7 - Atlassian Hipchat Integration Plugin Core
AO_6384AB - Confluence Feature Discovery Plugin
AO_6A9285 - SU for Confluence
AO_7CDE43 - Atlassian Notifications SPI Plugin
AO_7E78AC - Content Exporter (Word, PDF, HTML)
AO_80B181 - <unknown>
AO_88263F - <unknown>
AO_88BB94 - Confluence Batch Notifications plugin
AO_92296B - Recently Viewed Plugin
AO_9412A1 - Workbox - Host Plugin
AO_950DC3 - Team Calendars
AO_954A21 - Confluence Mobile Plugin
AO_A0B856 - Atlassian WebHooks Plugin
AO_A3F2EF - RefinedTheme for Confluence
AO_A8FB76 - RefinedToolkit for Confluence
AO_B1DBB9 - Questions for Confluence Plugin
AO_BAF3AA - Confluence Inline Tasks
AO_CEFA84 - ConfiForms, forms and workflows plugin for Confluence
AO_DC98AE - atlassian-help-tips
AO_ED549C - RefinedMobile for Confluence
AO_ED669C - SAML for Atlassian Data Center
AO_EF9604 - <unknown>
AO_FC3809 - <unknown>

Like # people like this
Daniel Eads Atlassian Team May 02, 2019

This is amazing @Craig Castle-Mead - super handy as I have personally struggled to decrypt what some of these tables were in the past.

The names themselves are the last bit of an md5 of the plugin key. Details of how this is generated are here. Unfortunately since it's a hash, it can't just be decrypted - so listing them all our for search is the best method to figure out what they are if you can't get the details from the Plugin Data Storage page.

Daniel Eads Atlassian Team Jun 28, 2019

The amazing @Andy Heinzer has taken a run at the most popular plugins for Jira and created a KB article - https://confluence.atlassian.com/display/JIRAKB/List+of+Jira+Server+AO+table+names+and+vendors

Like Craig Castle-Mead likes this

Super handy - thanks @Andy Heinzer  and @Daniel Eads !

 

CCM

Kat Community Leader Oct 23, 2019

This page is both helpful and depressing. Reviewing the usage of an app seems like an obvious task Administrators and decisions makers would do especially when renewals dates are approaching.

That's absolutly great, thanks !

I'm looking for the AO tables for the FLOW BOARD plug-in, and couldn't find them in those lists.

https://marketplace.atlassian.com/apps/1214206/flow-board?hosting=server&tab=overview

Maybe can you help me finding them ?

Thanks in advance !

Great list!

Got a few more to add:

  • AO_39E198 - Balsamiq Wireframes for JIRA Server
  • AO_3C6513 - Xporter
  • AO_544E33 - Email This Issue
  • AO_88263F - Support Healthcheck Plugin
  • AO_8BAD1B - Structure
  • AO_BF4748 - JEditor
Like Ivanichev Andrey likes this

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Why everyone using Jira must be GDPR-compliant

Did you know that penalties up to 4 % of the yearly company turnover are possible in case of GDPR violations? GDPR regulations are currently mainly relevant for companies in the EU, but countries lik...

81 views 1 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you