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
Accepted answer
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
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,127 views 17 14
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