Find spaces in confluence that use specific plugin (Confluence 5.1)

karthikys

Hi,

Can anyone help with the below query to retrieve the list of spaces/pages in Confluence that uses community forum macro.

we tried using following keywords(community, forum, forum:) but nothing helped us.

Select CONTENT.CONTENTID, Title, SpaceID, CREATOR, LASTMODDATE
from CONTENT, BODYCONTENT
WHERE
PREVVER IS NULL
AND (CONTENTTYPE = 'PAGE') 
AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID 
AND CONTENT_STATUS = 'current'
AND (BODY like '%{macroName%')

Thank you.

FelipeA

Hi Karthik

This is what I did:

Select CONTENT.CONTENTID, Title, SpaceID, CREATOR, LASTMODDATE
from CONTENT, BODYCONTENT
WHERE
PREVVER IS NULL
AND (CONTENTTYPE = 'PAGE') 
AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID 
AND CONTENT_STATUS = 'current'
AND ((BODY like '%ac:name=\”communities\”%') OR (body LIKE '%ac:name=\"user-info\"%'));

Basically you'll have to list all Community Bubbles macros. The above query will return just pages with {communities} OR {user-info}, so you'll have to extend this OR to include all macros listed on that page.

Best regards,

Felipe Alencastro