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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.