How can we get the count of number of pages,blogs and attachments from a specific team space in Confluence?

How can we get the count of number of pages,blogs and attachments from a specific team space in Confluence 5.6.6. Can this be obtained through any plugin or can this be fetched from the database?

3 answers

1 accepted

2 votes
Stephen Deutsch Community Champion Feb 03, 2015

If you're just looking for a count, why not log in as an administrator (a member of "confluence-administrators" group, who therefore has access to see all pages) and use the search function? Just click enter in the search box, and on the left side of the search screen choose the team space.  After that, click on "Pages", "Blog Posts", or "Attachments", and you will see to the right "Showing XXX results" and that would be the total count in the space.

 

Thanks Sash, Is there anyway I can get it via the Confluence database? The plugin seems to be taking up lot of memory and is freezing our confluence instance. :( Regards, Arya

Then look at table CONTENT of your Confluence DB, it has a straight-forward structure, so you will quite quickly understand how to make your SQL select

I use the Viewtracker plugin. Shows users per page. 

 

Hi Vera, Thanks for your response. I am already using Viewtracker but it seems to give me the count of no. of views of users per page. I was looking for the total number of attachments present in a team space. Any other suggestions please? Regards, Arya

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Tuesday in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

385 views 17 9
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you