Macro Usage search in Confluence Cloud

Question

Hello, is there a way to search for a specific macro in a space for Confluence Cloud? Wehn search for this, I see there's a macroName:<macro name> search but that is not giving me any results.

I do know there is a Macro Usage report, but none of the filtering options work for me. Just the TOC macro has over 2000 results. I want to see how many instances of this in a specific space, but this report is for all spaces. Scrolling and scrolling and scrolling to get the whole report to load and then to use CTRL+F to search for "2025" takes forever. I'd be happy if I could export the report to CSV (but without having to load the entire report and then copying and pasting the results).

Brant Schroeder · Answer

@Kimberly Onnen macroName is a search feature in DataCenter and does not work in cloud.  I am not aware of any search function that provides you with a similar functionality in cloud using basic search.  There is a feature request for this enhancement here that you can vote for https://jira.atlassian.com/browse/CONFCLOUD-70003

You can use advance search CQL to find macros.  Here is the KB https://developer.atlassian.com/cloud/confluence/advanced-searching-using-cql/#macro

Dirk Ronsmans · Answer

Hi @Kimberly Onnen ,

Have you tried just doing a CQL search? You should be able to find all page searching for

type=page AND macro="toc"

and replace the name of your macro of course. This way you can also filter on space if you want to.