count the number of pages created in a Confluence Space. How to? With JQL?

Question

How can I count the number of pages created in a Confluence Space? I do not see an analytics menu item in the side bar.

Barbara Szczesniak · Answer

Thanks for this, @Marc -Devoteam-! I see that you can do this for each Type—pages and live docs, databases, whiteboards, attachments, smart links, etc. Good to get the count and also an easy way to find all of the whiteboards, databases, etc. in a giant space.

Alex Koxaras -Relational- · Answer

Hi @Paul and welcome to the community,

You could use REST API to get that info:

GET /wiki/rest/api/search?cql=space=SPACEKEY AND type=page&limit=0

Replace SPACEKEY with your confluence key. You'll get a result like the followin:

{
"results": [],
"start": 0,
"limit": 0,
"size": 0,
"totalSize": 211,
"cqlQuery": "space = ABC AND type = page",
"searchDuration": 306,
"archivedResultCount": 0,
"_links": {
"base": "https://abc.atlassian.net/wiki",
"context": "/wiki",
"next": "/rest/api/search?next=true&cursor=_t_XXXXXX%3D&limit=0&start=0&cql=space=ABC%20AND%20type=page",
"self": "https://abc.atlassian.net/wiki/rest/api/search?cql=space=ABC%20AND%20type=page"
}
}

totalSize should be the number you are looking for. Keep in mind that restrictions apply. If you can't see a page, then this will not be counted.

Let me know if the above helps.

Marc -Devoteam- · Answer

Hi @Paul

Welcome to the community.

Confluence Analytics is a Premium feature, so not available on Standard.

You could see the Atlassian Marketplace for options.

Confluence has no JQL.

A workaround can be to go to the main search bar and choose the option "Advanced search"

Then select a single space under the Space option and under Type the option Pages and Live Docs.

This will show the number of pages.