nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Usage Stats on User Macros

Binaya

I am looking to see what "user" written macros have been utilized in the last year to potentially delete user macros that were created but never utilized in confluence. Is there a way to do that?

We have a "Macro Stats" plugin that lists the usage for all the plugins...I am looking to see if a similar one exists for User Macros.

Thanks.

Accepted answers

Steve Goldberg2

One thing you could do is do a search for the user macros to see how many pages they have been used in. This quite simple, see http://ffeathers.wordpress.com/2011/11/04/how-to-search-confluence-for-usage-of-a-macro/ for information.

It's manual work, alas.

All comments

Adolfo Casari

I have the same requirement, if someone knows an approach please share it.

Julio Mugabe

Same here, a solution will be greatly appreciated.

Steve Goldberg2

It's manual work, alas.

Matthew J. Horn

I wrote a macro to iterate over a space's pages and detect macro usage in each space. It works on Confluence 4.2.x. I have not tested it on 3.x or 5.x.

## Macro title: Macro Usage Report
## Developed by: Matthew J. Horn
## Date created: 11/12/13
## This macro takes no parameters
## @noparams

## Get a list of User Macros
#set($containerManagerClass = $content.class.forName('com.atlassian.spring.container.ContainerManager'))
#set($getInstanceMethod = $containerManagerClass.getDeclaredMethod('getInstance',null))
#set($containerManager = $getInstanceMethod.invoke(null,null))
#set($containerContext = $containerManager.containerContext)
#set($macroManager = $containerContext.getComponent('userMacroLibrary'))
#set($macroMetadataManager = $containerContext.getComponent('macroMetadataManager'))
#set($macroNames = $macroManager.getMacroNames())

## Get the ExcerptHelper (probably not supposed to be used for getting all macros, but it works)
#set($eHelper = $containerContext.getComponent('excerptHelper'))

## Get a list of pages in the space
#set ( $targetSpace = $spaceManager.getSpace("admin") )
#set ( $allPagesInSpace = $pageManager.getPages($targetSpace, true) )

## List all macro names
&lt;h3&gt;Macro names&lt;/h3&gt;
&lt;hr/&gt;
#foreach($name in $macroNames)
  $name, 
#end

#set($isValid = false)

## Iterate over each page and check if each of the macros in macroNames is used on that page
&lt;h3&gt;Macro Usage&lt;/h3&gt;
&lt;hr/&gt;
&lt;table&gt;
  &lt;tr&gt;&lt;th&gt;Macro&lt;/th&gt;&lt;th&gt;Description&lt;/th&gt;&lt;th&gt;Page (isValid) (parameters)&lt;/th&gt;&lt;/tr&gt;
  #foreach ($name in $macroNames) 
    &lt;tr&gt;
      &lt;td&gt;$macroMetadataManager.getMacroMetadataByName($name).getTitle().getKey() ($name)&lt;/td&gt;
      &lt;td&gt;$macroMetadataManager.getMacroMetadataByName($name).getDescription().getKey()&lt;/td&gt;
      &lt;td&gt;
      #foreach ($page in $allPagesInSpace)  ## $page is of type Page
        #if ($eHelper.getMacroDefinition($page, $name))
          &lt;a href="$page.getUrlPath()"&gt;$page.getTitle()&lt;/a&gt; ($eHelper.getMacroDefinition($page, $name).isValid()) ($eHelper.getMacroDefinition($page, $name).getParameters())&lt;br/&gt;          
        #end
      #end
      &lt;/td&gt;
    &lt;/tr&gt;
  #end
&lt;/table&gt;