"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
Community showcase
Published Oct 31, 2018 in Marketplace Apps

Marketplace Spotlight: Zephyr

Hello Atlassian Community! Each month, we run a series of Spotlights to highlight Marketplace vendors and apps that our team thinks this Community would find valuable. In last month's Spotlig...

335 views 0 1
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