Geeks With Blogs
Alex Hildyard
We're currently migrating our Confluence installation, and I was looking around for resources to provide some basic metrics, eg. the total number of (non-private) pages we are currently hosting. It appears that the simplest way to get this information is simply to connect directly to the database and run a query:

# Get count of all pages in all global spaces (each page is counted as a single version)
select count(*)
from SPACES as A
inner join CONTENT as B
on A.SPACEID = B.SPACEID
where A.SPACETYPE='global'
and B.PREVVER is null
and B.CONTENTTYPE='PAGE'

Posted on Friday, March 10, 2017 2:05 PM | Back to top


Comments on this post: Counting pages in Confluence

# re: Counting pages in Confluence
Requesting Gravatar...
I am from Florida, and now living in Roswell, and I need to begin angling once more, yet there truly isn't anyplace great to angle down along these lines, we have lake Brantley in Carlsbad's, and the Pecos goes through town, however, I am not eating anything out of there get assignment help online at assignment moz . I need to discover a place in the mountain around this territory (not Bonita in Ruidoso) to take day excursions to, or conceivable fish/outdoors trips for the end of the week, some place where there are not many individuals so my pooch isn't annoying anyone.
Left by Sharlyn on Mar 16, 2017 4:58 AM

# Nice Article
Requesting Gravatar...
I would like to thank the author for sharing this source code. This post offered an insight on counting pages in Confluence. I think this post will be a reference to all computer science students. Expecting more source codes like these. prefab tiny house
Left by Taylor Shaw on Apr 05, 2017 10:30 AM

# re: Counting pages in Confluence
Requesting Gravatar...
I would like to thank the author for sharing this source code. This post offered an insight on counting pages in Confluence. I think this post will be a reference to all computer science students. Expecting more source codes like these
academic writer uk
Left by Daisy Faith on Apr 13, 2017 6:53 AM

# re: Counting pages in Confluence
Requesting Gravatar...
This will be good information for many IT students. It is for the first time I am getting to know about counting the pages in confluence. As you said, this looks quite simple. Please share more useful information like this. private rijksmuseum tour
Left by lionel on Apr 18, 2017 10:46 AM

# re: Counting pages in Confluence
Requesting Gravatar...
This is Megan Here, I professional web developer and an academic writer at Assignment Help On Web and I was looking for this database attachments to migrate some counting pages in confluence.
Left by Megan Martin on May 02, 2017 7:11 AM

# re: Counting pages in Confluence
Requesting Gravatar...
To me this topic seemed very relevant and interesting, very glad that I found it on your site
food places near me
Left by maodzedun on Jul 28, 2017 11:32 AM

# re: Counting pages in Confluence
Requesting Gravatar...
Thanks for sharing! In case you are willing to bore holes in a wide variety of materials, often you cannot do so by hand as creating these holes manually can definitely lead to a lot of mistakes. In this article, you can check out the best drill press review for 4 products in 2017. Best Drill Press
Left by Best Drill Press on Aug 18, 2017 11:10 AM

# re: Counting pages in Confluence
Requesting Gravatar...
Rummy is one of the Most popular game of card_now here we brings you the amazing and new website of gamesdro.com/gin-rummy where you can play rummy with a new version and free of cost.
Left by play online free gin rummy on Aug 19, 2017 10:59 AM

# re: Counting pages in Confluence
Requesting Gravatar...
Try to minimize the quantity of pages its tough to handle more pages, chemistry assignment help writers can help you in this.. They are experts in minimizing the content they might help you too...
Left by Maisie Acton on Aug 26, 2017 3:04 PM

# free app
Requesting Gravatar...
magicpin is the best free app for discovering and earning great cashback and free recharge on your shopping bills at restaurants, beauty salons, spas and fashion outlets freecharge
Left by magicpin on Sep 04, 2017 8:51 AM

# re: Counting pages in Confluence
Requesting Gravatar...
Thanks for sharing the function. I'll let you my opinion on this once i finish trying it. UK document attestation
Left by Alice on Sep 16, 2017 11:16 AM

Your comment:
 (will show your gravatar)


Copyright © Alex Hildyard | Powered by: GeeksWithBlogs.net