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

# GoAssignmentHelp
Requesting Gravatar...
Many thanks for sharing this very diverse opinion post where each expert has no doubt shared his best knowledge on the topic. Have more success in your journey.
Assignment Master
Left by Assignment Master on Oct 04, 2017 6:34 AM

# re: Counting pages in Confluence
Requesting Gravatar...
Thanks for the excellent algorithm, all that's left is to write a couple lines of code and everything will be ready 192.168.1.1
Left by lukenlow on Oct 06, 2017 2:06 PM

# re: Counting pages in Confluence
Requesting Gravatar...
Confluence in counting pages won't be that much simple which we are thinking,essay help try to reduce the counting pages quantity...
Left by Euan Kurtis on Oct 16, 2017 1:34 PM

# Thanks
Requesting Gravatar...
Thanks for Sharing this Awesome Post ! Best Carpet Cleaners Review
Left by Jacob Palmer on Oct 23, 2017 8:16 AM

# re: Counting pages in Confluence
Requesting Gravatar...
Through this article I came to know about this Confluence installation. I have gone through the code you have shared here and it was little bit confusing because I am not familiar with this topic. Can you update little more details regarding the topic?Topline Performance Huntington Beach
Left by Ann on Nov 23, 2017 11:56 AM

# re: Counting pages in Confluence
Requesting Gravatar...
This will be great data for some IT understudies. It is out of the blue I am becoming more acquainted with about including the pages juncture. As you stated, this looks very basic. If it's not too much trouble share more valuable data like this Write My Essays.
Left by Cerys Perry on Dec 02, 2017 4:44 AM

# re: Counting pages in Confluence
Requesting Gravatar...
I am from Florida, and now living in Roswell, and I have to start calculating yet again, yet there genuinely isn't wherever incredible to point down thusly, we have lake Brantley in Carlsbad's, and the Pecos experiences town, notwithstanding Al Pacino Tony Montana Scarface Jacket.
Left by Owen Potts on Dec 02, 2017 4:48 AM

Your comment:
 (will show your gravatar)


Copyright © Alex Hildyard | Powered by: GeeksWithBlogs.net