"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

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

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Jul 10, 2018 in Marketplace Apps

If you’re an Atlassian app developer, you’ll want to know about Atlas Camp!

This September 6-7, hundreds of Atlassian App developers will flock to Barcelona Spain to build skills, discover product roadmaps, meet face-to-face with the Atlassian team, and learn how to extend t...

186 views 0 4
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