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
Answer accepted

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
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

511 views 2 13
Read article

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