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

Your comment:
 (will show your gravatar)


Copyright © Alex Hildyard | Powered by: GeeksWithBlogs.net