How can I search for the use of a macro within a space.

[Leanne Leanne]

How can I search a confluence space to find all the instances where a macro is used?

[Nelson Carranza]

Hi,

This has been answered here https://answers.atlassian.com/questions/59203

Add * after macro name, so it will look like this macroName:xxxxx* AND spacekey:key_of_the_space

(I saw more results after adding * )

[Panos]

Using the default search, you can search with the query:  

macroName:xxxxx AND spacekey:key_of_the_space

[IshanL]

you can use below query. Pls replace XXXXX with macro name.

Select CONTENT.CONTENTID, Title, SpaceID, CREATOR, LASTMODDATE
from CONTENT, BODYCONTENT
WHERE
PREVVER IS NULL
AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID
AND CONTENT_STATUS = 'current'
AND ((BODY like '%{add-page-form%')  OR (BODY like '%<ac:macro ac:name="XXXXX">%') OR (BODY like '%<ac:structured-macro ac:name="XXXXX">%'))