It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to count pages in a whole Confluence instance?

Alex Bobrovski Jul 28, 2011

Hi,

who can help - I'd like to know how many pages are on my Confluence? The total number mustn't include deleted articles (from the recycle bin).

2 answers

3 votes
Adam Laskowski Jul 28, 2011

The best way to get an accurate count of the number of pages in the instance (excluding their previous versions) is to run this query against your database:

select count(*) from content where contenttype='PAGE' and prevver is null and content_status='current';

Limiting the contenttype to PAGE removes space and global descriptions, user info, drafts, and blog posts; only returning rows with a null previous version ensures that only the current version of the page is counted; lastly, content that has been deleted will have a status of "deleted," so you only want the rows that are still in the "current" status.

Alex Bobrovski Jul 28, 2011

If I use the {sql} macro, is it dangerous in terms of security? Is it true that any user can run the macro and get any data?

Penny Wyatt Atlassian Team Jul 28, 2011

Yes, the {sql} macro opens up your whole database to any user who can edit Confluence content.

2 votes
Kenta Yamamoto Atlassian Team Nov 30, 2016

For Confluence Cloud users, consider using REST API as below because Confluence Cloud doesn't support SQL, Macro, and 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'

 

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

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

2,502 views 11 28
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you