How Can I Get Space Count on Confluence?

[Dogan Can]

Hi, I want to change Confluence Usage Stats plugin to display all projects in the confluence on the "Global Activity" section so I tried to overwrite the plugin. Now I can change the number of spaces by setting "max" parameter, but I need to the total project(or space) count to "max" parameter. How can get the total space count and use it? It can be like this:

#set ($spaceCount = "display=count|spaces=@all")
$helper.renderConfluenceMacro("{popular:display=icon,count|max=$spaceCount|type=spaces|$commonParams}")

[Dogan Can · Accepted solution]

#set ($spaceCount = 0)
#foreach ($space in $spaceManager.getAllSpaces()) 
	#set ($spaceCount = $spaceCount + 1) 
#end<br />

[Davin Studer]

It gets easier than that.

$spaceManager.getAllSpaces().size()

[azher khan]

where we can run this code confluence 

[Hsu Yao Chang]

dear sir, 

Where can I add the command ? Thank you.

[Davin Studer]

The above code is for a user macro. Go to Confluence Admin -> User Macros to create one. After you create the user macro it will show up in your macro browsers. Below are some links for how to create user macros. https://confluence.atlassian.com/doc/user-macro-template-syntax-223906130.html https://developer.atlassian.com/confdev/development-resources/confluence-architecture/confluence-internals/velocity-template-overview/confluence-objects-accessible-from-velocity