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; } } }

How many pages in a space?

Emily Johnson

I just want to know how many pages are in a Confluence space without having to manually count or run a SQL query. I know the usage tracker plugin used to do it, and it was disabled by default because it impacted performance, but I cant find it even to run for a bit and then re-disable. Any other ideas>? I dont need anything fancy, just a page count.

Thanks,

Emily

Accepted answers

MatthewC

If you have the Reporting plugin, you could use this markup:

{report-info:space > all pages > size}

OR you could create a user macro.....

Name: pagecount

No Macro Body

Output generates wiki markup (or HTML doesn't really matter)

Template:

## get page manager...

#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($pageManager=$containerContext.getComponent('pageManager'))

#set($pageCount=$pageManager.getPages($space,true).size())

Page Count: *$pageCount*

All comments

MatthewC

If you have the Reporting plugin, you could use this markup:

{report-info:space > all pages > size}

OR you could create a user macro.....

Name: pagecount

No Macro Body

Output generates wiki markup (or HTML doesn't really matter)

Template:

## get page manager...

#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($pageManager=$containerContext.getComponent('pageManager'))

#set($pageCount=$pageManager.getPages($space,true).size())

Page Count: *$pageCount*

Betsy Walker

Here's a user macro that does it, accepting a single parameter representing the SpaceKey of the space on which to report:

## pagecount - no body, unprocessed, generates WM
#if ($paramspace)
#set ($space=${paramspace})
#else
#set ($space="WikiHelp")
#end

{report-table}
{space-reporter:space=$space}
{text-sort:space:name|mode=natural|order=ascending}
{space-reporter}
{report-column:title=Space}{report-info:space:name|link=true}{report-column}
{report-column:title=Pages}{report-info:space:all pages > collection:size}{report-column}
{report-table}

Jeremy Largman

I figured I could write a quick user macro for this, so I went to go look at the available community User Macros, and there's one already. See Count Pages in a Space.

And, yes, I was indeed to my surprise to see that I was the author! Can't remember that at all... So, let me know if that doesn't work on your version and needs an update.

MatthewC

Hi Jeremy, I don't think that one works any more, not since they lost the .getPages() from the space object (3.1 cleanup?)

my attempt gets hold of the pageManager object to call it's getPages() method.

Jeremy Largman

You're right, sorry about that! I figured out what needs to happen in 3.5 and posted again. You need to use spaceManager:

$spaceManager.findPageTotal($space)

twong_atlassian

SQL-- Show number of CURRENT PAGES (as opposed to historical versions of pages) in every space:

SELECT
    spacename,
    COUNT(*)
FROM
    spaces s
JOIN
    content c
ON
    s.spaceid = c.spaceid
WHERE
    c.contenttype='PAGE'
AND prevver IS NULL
GROUP BY
    spacename
ORDER BY
    spacename;

jim kennedy

The fix described by Matthew above works for me, but only in the current space. If I do {pagecount} I get the number of pages in the current space.

Is there any syntax that would allow me to count the pages in a different space?

MatthewC

Modification of original user macro which takes the Space Code as the body of the macro

e.g. {pagecount}CONFTEST{pagecount}

## get page manager...

#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($pageManager=$containerContext.getComponent('pageManager'))

#set($spaceManager=$containerContext.getComponent('spaceManager'))

#set($targetSpace=$spaceManager.getSpace($body))

#set($pageCount=$pageManager.getPages($targetSpace,true).size())

#set($spaceName=$targetSpace.getName())

Space Name: *$spaceName*

Page Count: *$pageCount*

Jeremy Largman

Hi Jim,

I added another line to the user macro Count Pages in a Space. Check the green tip box.

jim kennedy

Hi Jeremy, thanks but that doesn't seem to work for me. I should probabaly have mentioned that I'm on version 3.1.

Jeremy Largman

I reopened this question. Questions need not be closed just because they're answered .

Jonathan Simonoff

findPageTotal returns a basically useless number that includes all versions of the pages. The JavaDoc notes "this probably doesn't give the number you are looking for."

Milo Test

Can this be modified to get a count of child pages of a certain parent page?

K. Yamamoto

For Confluence Cloud users, consider using REST API because Confluence Cloud doen't support SQL, Macro, or some Add-ons for stats.

A_USER="admin"
A_PASSWD="__YOUR_PASSWORD_HERE__"
INSTANCE_HOST="__YOUR_SUBDOMAIN_HERE__.atlassian.net"
 
# Total number of pages
curl -sGLu ${A_USER}:${A_PASSWD} "https://${INSTANCE_HOST}/wiki/rest/api/search" --data-urlencode 'cql=type IN (blogpost, page)' --data-urlencode 'limit=0' | jq '.totalSize'

Refer my related answer at For Confluence Cloud, how do I find the total number of pages? for more detail if you needed.

David Gregory

One brute force method that I have used is to:

create a page in another space
On that page place the Children Display macro
Edit the macro and Show Descendents as well as fill in the Parent Page with the root of the page tree you wish to count (Space Home)
Export this page to Word
Use the Word native Statistics to get a count of the number of lines
The number of pages will be 1 less than the number of lines since there is a line for the page name

liteyear

This works well for all pages, provided you heed my note I added to your link about use of passwords being deprecated.

I'm interested in how to restrict this search to a single space. I tried adding --data-urlencode 'cqlcontext={"spaceKey":"KEY"}' but it seems to make no difference.

But adding "and space = KEY" to the cql seems to do the trick. Eg:

A_USER="admin"
A_TOKEN="__YOUR_TOKEN_HERE__"
INSTANCE_HOST="__YOUR_SUBDOMAIN_HERE__.atlassian.net"
SPACE_KEY="__YOUR_KEY_HERE__"
 
# Total number of pages
curl -sGLu ${A_USER}:${A_TOKEN} "https://${INSTANCE_HOST}/wiki/rest/api/search" --data-urlencode "cql=type IN (blogpost, page) and space = $SPACE_KEY" --data-urlencode 'limit=0' | jq '.totalSize'

Martin

Thanks this helped

Adrian Morse

In Confluence, do an Advanced Search with the space selected and content = pages. Leave the search field blank. There will be a search result for every page. At the top of the search results page it will tell you how many results there are. Number of results = number of pages.

Greg Gorman

This seems to me like the simplest solution suggested here. Any reason to use the macros or other workarounds when all I need is a quick count?