In Confluence, how can we find which pages use a plugin?

[Ron Stanonik]

We're trying to determine which pages will be affected by a plugin update.

Is there a search we can run in confluence or a query we can run against the database to find which pages use a macro (in this case, table-plus macro)?

Thanks.

[nriley · Accepted solution]

Hi Ron, I believe this question was asked previously on Answers, check out this link:

https://answers.atlassian.com/questions/59203/find-pages-that-use-certain-macros-plugins

...specifically Sando's comment:

https://answers.atlassian.com/questions/59203/find-pages-that-use-certain-macros-plugins/59208

or Sarah's link:

http://ffeathers.wordpress.com/2012/09/04/how-to-search-for-macros-and-macro-parameters-in-confluence-4/

Hope this helps!

[Rodrigo Girardi Adami]

Hi Ron,

That's possible by running a database query indeed.

in mysql, you can use this query (If you are using another database, you may need to ask the DBA to tweak a bit the query):

SELECT c.title, s.spacename
FROM content c
INNER JOIN bodycontent b ON b.contentid = c.CONTENTID
INNER JOIN spaces s ON c.spaceid = s.spaceid
WHERE b.body like '%macro_syntax%';

This will show you the space name and page title of the affected page by the macro. Hope that helps :D

[Natvar]

I would need the count based on plugin instead of the macro which would help me decide to buy the plugin as the plugin might have n number of macros

[MatthewC]

Also, this DB query can take hours to run on large instances with some databases, due to lack of indexing, and given that some plugins can contribute 10, 20+ macros this can often isn't feasable for anything other than a small instance.

[Natvar]

Yes, I understand the performance part. Do you have any SQL query which would achieve the results.

[Ron Stanonik]

Thanks for the responses.

The "{macro" for 3.5 and "macroName: macro" for 4.X are what our web developers wanted, so they don't need to bug the DBA.