Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,362,088
Community Members
 
Community Events
168
Community Groups

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

 

 

 

 

 

15 comments

Jira ActiveObjects mappings:

 

AO_00B950 - Projectrak (was 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 - Zephyr Scale (was Test Management for Jira)
AO_4E8AE6 - Service Desk Notifications Plugin
AO_54307E - JIRA Service Desk
AO_544E33 - Email this Issue (was JETI)
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 - Advanced Roadmaps Team Management (was Portfolio Team Management)
AO_86B55C - Out Of Office Assistant
AO_86ED1B - Tempo Timesheets
AO_88263F - <unknown>
AO_8AC478 - Softwareplant BigGantt
AO_8BAD1B - <unknown>
AO_97EDAB - Atlassian Jira - Plugins - Invite User
AO_9B2E3B - Service Desk Automation Plugin
AO_A0B856 - Atlassian WebHooks Plugin
AO_A415DF - Advanced Roadmaps for Jira (was Portfolio for Jira)
AO_A44657 - <unknown>
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 - Jira Service Desk/Management Canned Responses Plugin
AO_D9132D - Advanced Roadmaps plans (was Portfolio Live Plans)
AO_DA6AB9 - Softwareplant BigTemplate
AO_E8B6CC - Jira DVCS Connector Plugin
AO_ED669C - SSO for Atlassian Data Center
AO_F1B27B - Atlassian Timed Promise Plugin
AO_A9375F - Mail.ru: My ToDo
AO_8542F1 - Insight CMDB
AO_050302 - Statuspage for Jira Service Desk
AO_6FF49D - Jira Cloud Migration Assistant (JCMA)
AO_A020FF - Atlassian Centralized License Visibility Plugin
AO_A07C39 - Microsoft Teams for Jira Server
AO_AFD221 - Zeplin for Jira
AO_A83C21 - Better PDF Exporter
AO_D1CA32 - Refined for Jira
AO_744954 - Elements Copy Sync
AO_C2A220 - Smart Checklist
AO_D195E9 - Herzum approval plugin
AO_AC3877 - Atlassian Rate Limiting Plugin
AO_2C3287 - User Profiles for Jira
AO_589059 - Automation for Jira

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 Marketplace Partner 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

I've updated some of the names (TM4J to Zephyr Scale, ProFields to Projectrak etc), merged in the list for Justin and added a few extras to the main list.

 

CCM

Does anyone knows which jira plugin owns this tables?

AO_ED979B_ACTIONREGISTRY
AO_ED979B_EVENT
AO_ED979B_EVENTPROPERTY
AO_ED979B_SUBSCRIPTION
AO_ED979B_USEREVENT

A few new items added for Jira, and I've updated names for Portfolio to Roadmaps

 

CCM

Added Automation for Jira

https://github.com/redradishtech/activeobject_views/blob/master/jiraplugins.csv has a pretty exhaustive list - but last commit was 2022.

Content stuffing each of the AO's currently listed in the above GitHub link so they'll at least show in search results

AO_8496F9
AO_BF7624
AO_299380
AO_1EF9DD
AO_788523
AO_499D56
AO_2DA43D
AO_9C8F64
AO_BA68D6
AO_FD6F52
AO_222C21
AO_E2B9A5
AO_8DD30D
AO_C30643
AO_299E6C
AO_86B55C
AO_C069E0
AO_9B0D9B
AO_8BAD1B
AO_9F079B
AO_6714C7
AO_DDA217
AO_A1636C
AO_8AAAB7
AO_C16815
AO_BD1E3C
AO_2C4E5C
AO_97EDAB
AO_3B1893
AO_550953
AO_0A5972
AO_733371
AO_E8B6CC
AO_575BF5
AO_0AC321
AO_CFF990
AO_4AEACD
AO_7A2604
AO_B9A0F0
AO_D9132D
AO_587B34
AO_F1B27B
AO_38321B
AO_21D670
AO_ED669C
AO_5FB9D7
AO_319474
AO_54307E
AO_56464C
AO_9B2E3B
AO_D530BB
AO_C7F17E
AO_4E8AE6
AO_0201F0
AO_563AEE
AO_82B313
AO_23011C
AO_4789DD
AO_A0B856
AO_21F425
AO_F3C482
AO_E36E26
AO_39E198
AO_3A112F
AO_877885
AO_E7E13A
AO_8D4C0F
AO_CD1DD1
AO_13D3DF
AO_589059
AO_430618
AO_713E23
AO_B98A89
AO_E0F72F
AO_58EA67
AO_0EC4DF
AO_DCF489
AO_396840
AO_F5A203
AO_C4B6C1
AO_00B950
AO_854ED6
AO_00C882
AO_AFAA51
AO_53699B
AO_102D86
AO_7B9828
AO_1E3ECE
AO_AC8402
AO_B50D50
AO_935429
AO_B8EFDD
AO_1273F8
AO_242870
AO_98448A
AO_0802A2
AO_08F1AF
AO_CEEE86
AO_6A3064
AO_2D1742
AO_AC093E
AO_69E499
AO_7C2234
AO_D195E9
AO_3F6548
AO_459C0D
AO_272C37
AO_085EFF
AO_4C3E54
AO_5A68F6
AO_248DF5
AO_B1EC07
AO_BD1080
AO_B300F0
AO_33A75D
AO_8CB340
AO_3D787C
AO_34AB25
AO_9BFD01
AO_61F280
AO_717BDC
AO_F04B02
AO_2AE210
AO_455C86
AO_18A588
AO_6D516B
AO_BC9342
AO_C1221E
AO_551312
AO_F86E5E
AO_78C957
AO_BF7F57
AO_595E00
AO_BF4748
AO_426761
AO_3BA132
AO_A912D8
AO_1B155C
AO_6B9F04
AO_D9F874
AO_4D28DD
AO_1114A6
AO_1B54DA
AO_3F6C61
AO_CE20B8
AO_5A70E4
AO_8BF6AE
AO_D98188
AO_2B6364
AO_04376E
AO_4B0B86
AO_941C01
AO_D1BE42
AO_3FB43F
AO_47EAC7
AO_544E33
AO_09E361
AO_764F4D
AO_A83C21
AO_FF4886
AO_CE4B6D
AO_7C2DE0
AO_52302C
AO_3198A9
AO_DB39E1
AO_14A4BF
AO_CBC281
AO_02C593
AO_092BCA
AO_956E29
AO_C63094
AO_4B00E6
AO_CC6AEB
AO_A36E36
AO_E7B8CC
AO_42D05A
AO_ED9438
AO_2EE522
AO_28A718
AO_A29AEA
AO_F26C1F
AO_60DB71
AO_C868C5
AO_7C25E5
AO_A415DF
AO_9E74DD
AO_C3F46D
AO_5E638F
AO_9701C1
AO_385228
AO_F719F1
AO_F3AFCB
AO_D1CA32
AO_F58FCA
AO_8542F1
AO_F9C6CD
AO_41FCC6
AO_95DC8F
AO_9AA912
AO_A69CA7
AO_A3B085
AO_22BE8E
AO_62850F
AO_044626
AO_30028F
AO_4CB44A
AO_D4B4E5
AO_6AD1C6
AO_2E48A5
AO_52220E
AO_C3C6E8
AO_013613
AO_2D3BEA
AO_BEE373
AO_AEFED0
AO_7DEABF
AO_2B6685
AO_85377D
AO_5345B8
AO_984231
AO_CB3B8D
AO_DB4848
AO_744954
AO_F90A7B
AO_353A13
AO_216B11
AO_3D5E3B
AO_63D3CD
AO_2B7A0E
AO_06D57D
AO_E30806
AO_275653
AO_ADD55C
AO_C72C89
AO_632F8B
AO_8BA09E
AO_3C6513
AO_8B1069
AO_CC493F
AO_882244
AO_2D44A0
AO_4223CC
AO_4FFCB7
AO_C3EFFD
AO_4D8B31
AO_1BD964
AO_7A4E8B
AO_B5E1D5
AO_3EFB4D
AO_2C3287
AO_9B23C2
AO_9FD13B
AO_EE3AEC
AO_7AF017
AO_515FC4
AO_A709F6
AO_28DB39
AO_B8B557
AO_91A39F
AO_D0CA64
AO_0456E7
AO_698B6A
AO_6B485E
AO_377A17
AO_4AED16
AO_0C0737
AO_9DE8AC
AO_F33F82
AO_A18366
AO_9ED7BE
AO_B4101D
AO_311E07
AO_E24DEA
AO_9661E7
AO_4811F4
AO_B64EA1
AO_48D2EA
AO_67BD6E
AO_050302
AO_04990F
AO_756F83
AO_503A94
AO_E74470
AO_E8E966
AO_27DE84
AO_687793
AO_15241E
AO_3A3ECC
AO_88DE6A
AO_72EDB4
AO_DDF8A3
AO_D4AF4C
AO_88CD22
AO_F64AB2
AO_C87C73
AO_9F9188
AO_A1168D
AO_A0A7C0
AO_96E78C
AO_84DB96
AO_91C093
AO_D53E8E
AO_C5CA76
AO_FEDBA1
AO_4634D4
AO_CEA560
AO_680A11
AO_16D9EC
AO_A406ED
AO_AD8E0F
AO_154E16
AO_FDF29B
AO_23ADAF
AO_C5D949
AO_6797AA
AO_2DDF0D
AO_5D733E
AO_47E0AA
AO_2FC5DA
AO_DBF70C
AO_0DB21A
AO_A9375F
AO_A72509
AO_C5350F
AO_A3CCC5
AO_EAB919
AO_5CF617
AO_9F39CD
AO_0BB235
AO_E970DC
AO_4FE048
AO_4C6FC2
AO_A5E733
AO_2E9800
AO_E115BF
AO_5D285B
AO_3CA953
AO_19C9CB
AO_FF0AC4

Comment

Log in or Sign up to comment
TAGS

Atlassian Community Events