Can I view Plugin usage from the databse


I have Confluence - 3.3

(Plugin Repositiory is not working)

I would like to view the plugin usage - using a script from the database.

Is this possible..


2 answers

1 accepted

7 votes
Accepted answer

Hi Showkat Ally!

This is possible by referencing the bodycontent table, body column which is the storage location for content in Confluence 3.3.

What I use to find out what the literal string I'm going to put into the sql script is, navigate to a page using the macro you want to identify the usage for. Click on the Tools menu > View Wiki markup

select count(*) from bodycontent where body like '%{toc}%';

For Confluence 4.0 and newer, you'll use Tools > View storage format and the query would look something like this:

select count(*) from bodycontent where body like '%<ac:macro ac:name="toc" />%';

Hope this helps!

Hi there,

Unfortunately this is not possible, what you can view from the database would be which plugins you have installed by the following query:

select * from plugindata;

As you're having problems with your plugin repository, then I would like also to suggest you to clean the plugins cache to try to solve this problem, by the following procedure:

Hope this helps.

Kind Regards,


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,099 views 17 14
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you