"Macro usage stats plugin" plugin missing from URL

The URL to download "Macro usage stats plugin" is missing.

I could not download the plugin.

Thanks

2 answers

This widget could not be displayed.

Hi Vinh,

I just checked the Comalatech website, (they are the developers of the Macros Usage Stats plugin), but I couldn't find a direct download link to it there either so it could be that they have deprecated it because I know it only worked upto Confluence v3.something anyway.

However, you might find the following blog post useful for searching for macros in Confluence v4.x and above: http://ffeathers.wordpress.com/2011/11/04/how-to-search-confluence-for-usage-of-a-macro/

If you are using Confluence v3.x then the query below should work for you:

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

And if you are using v4.x and later, but would rather use SQL than search through the interface you can use the following query:

Select CONTENTID, Title, SpaceID, CREATOR, LASTMODDATE
from CONTENT, BODYCONTENT
WHERE
PREVVER IS NULL
AND (CONTENTTYPE = 'PAGE' OR CONTENTTYPE = 'BLOGPOST') 
AND CONTENT.CONTENTID = BODYCONTENT.CONTENTID 
AND CONTENT_STATUS = 'current'
AND (BODY like '%<ac:macro ac:name="MACRO">%')

I hope that helps to workaround the missing plugin for you and gives you other options for finding the macro usage in your instance no matter what version you are running.

All the best,
John

This widget could not be displayed.

Although the Marketplace URL of http://www2.comalatech.com/confluence/plugins/jars/macrostats-1.0.4.jar failed to connect, I simply changed the "www2" to "www" in the URL, and then it worked :)

Fantastic, it still works and even seems to be compatible to Confluence 5.7.5! However, thanks a lot mate!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

463 views 3 17
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you