## [STEP 1] Get information ## skip archived ## skip collaboration, knowledge_base, and personal ## limit up to 250 space ## and add icon for better representation #set ( $parameters = "status=current&type=global&limit=250&include-icon=true" ) ## request spaces #set ( $spaces = $ConfluenceManager.get("/wiki/api/v2/spaces?${parameters}").results ) #set ( $spaceMap = {}) #foreach ( $space in $spaces ) #set ( $permissions = $ConfluenceManager.get("/wiki/api/v2/spaces/${space.id}/permissions").results) #set ( $users = {} ) #foreach ( $permission in $permissions ) #set ( $id = $permission.principal.id ) #if ( $permission.principal.type == "user" ) #set($dontOutput = $users.put($id, null) ) #elseif( $permission.principal.type == "group" ) #set ( $members = $ConfluenceManager.get("/wiki/rest/api/group/${id}/membersByGroupId").results) #foreach ( $member in $members ) ## Skip app accoutns. Only personal accounts will be counted #if ( $member.accountType == "atlassian" ) #set($dontOutput = $users.put($member.accountId, null) ) #end #end #end #end #set ($usersSize = $users.size()) $!spaceMap.put($space, $usersSize) #end ## [STEP 2] Represent in a table #foreach ( $space in $SortTool.sort( $spaceMap.entrySet(),"value:desc")) #set($icon = $StringUtils.remove($space.key.icon.path, "/wiki")) #end

	Space key	Space name	User count
	$space.key.key	$space.key.name	$space.value

Usercount for Every Space — Confluence Cloud Macro

You May Also Like