Have all pages using a macro

[Jacynthe_Thibault]

Hi,

We will be migrating to Confluence Cloud soon, but first we need to have all pages using SQL macros because we don't want these macros in the cloud.

I saw in "Administration/general configuration/macro usage", I have a link to pages that use the macro in question. But I just noticed that if someone has restricted the permissions on a page it does not appear in these lists.

So I would like a way (maybe by SQL query) to have the list of all pages using a macro (it's a third party macro) regardless of whether there have been restrictions on it.

Thanks

[Kian Stack Mumo Systems · Accepted solution]

@Jacynthe_Thibault, 

Please take a look at this page which contains details about the query you would need to run.

I would recommend using the source editor plugin to find out what the macro is called on the back end.

Thanks,

Kian

[Stiltsoft support]

Hi @Jacynthe_Thibault ,

Maybe this thread gives you some hints for the case https://community.atlassian.com/t5/Confluence-questions/Reporting-of-pages-using-Table-Excerpt-Include/qaq-p/1556626 

[Jacynthe_Thibault]

Hi,  I tried with the field search MacroName: sql but it gives only the page where I have permission to see it.  It there are a restriction I don't see it (even if I am administrator in COnfluence)