In the latest confluence, I am trying to find every page that uses the macro {live-template}, is there a way I can do this either with an sql query or something in the administration section?

[Jpoplar]

In the latest confluence, I am trying to find every page that uses the macro {live-template}, is there a way I can do this either with an sql query or something in the administration section? Is there a query I can run that lets me know what pages use what plugin?

[David at David Simpson Apps · Accepted solution]

I think this question has you covered:
https://answers.atlassian.com/questions/59203/find-pages-that-use-certain-macros-plugins

See also @Sarah Maddox's response:

For people who don't have access to the database, here's how to do it in Confluence 4.0 and above:

http://ffeathers.wordpress.com/2011/11/04/how-to-search-confluence-for-usage-of-a-macro/

In a nutshell: In a nutshell: Enter the following in the Confluence search box, assuming that your macro name is “x”:

macroName: x*

The above works in out-of-the-box Confluence (no plugins required). If you install a plugin, you can also search for specific parameters and parameter values. See http://ffeathers.wordpress.com/2012/09/04/how-to-search-for-macros-and-macro-parameters-in-confluence-4/