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

Your comment:
 (will show your gravatar)


Copyright © Alex Hildyard | Powered by: GeeksWithBlogs.net