Search all pages with Metadata plugin used in it.


I was wondering if i can could get help with the information on the plugin -

I need to find all pages where any macros of this plugin are present. As I see there is quite a number of those and there is a big change of missing them. I found that some info might be stored in os_propertyentry table. Like "metadata.XXX".  But I’m not sure If I can select all macros using this syntax. As using the instruction I saw only description for finding metadata-list macro (see here -  

Can anyone tell me the way (SQL in ideal way) I would be more than happy.  Or I’d like to see some documentation on the plugin database structure if possible. Thank you.

2 answers

1 accepted

1 vote
Answer accepted

You can just run "macroName: <macro>" in the search to get a list of pages it's used on.

With SQL, you're into searching the bodycontent table text for snippets of text referring to the macro, then joining with other tables to try to establish more information about the pages.

Indeed. Searching for each macro in Confluence earch tool was quite effective and too simple =) 

I as still wondering if there is a way to search all macros from a particulat plugin without referring to each of the macro separately. Like as I don't know how many macros a particular plugin supports.

Anyway it is more of a food for thought. Thanks! 

Ann Worley Atlassian Team Jun 28, 2017

Hi there Alex,

If you want to use SQL to find the macros you still have to know the macro names. The SQL is in this kb: How to find all pages and spaces that use a specific macro via SQL

The macros are listed on this page: Metadata macros.

Hope that helps,


1 vote
Davin Studer Community Champion Jun 28, 2017

If you are using Confluence 5.10+ there is a Macro Usage page in Confluence Admin that shows you all the macros used in your system and groups them by add-on.

Ann Worley Atlassian Team Jun 28, 2017

Well said! Thank you for mentioning that.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

275 views 2 10
Read article

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