Can I view Plugin usage from the databse

Hi

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..

Thanks

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:

https://confluence.atlassian.com/display/CONFKB/How+to+Clear+Confluence+Plugins+Cache

Hope this helps.

Kind Regards,

LJ.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

800 views 38 5
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