Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get Confluence Stats

AbrahamA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 17, 2012

Hi

Can you please let me know how I can get information from Confluence like:

  • No.of Spaces
  • No.of Pages
  • No.of Versions/page

Is there schema published for confluence (I found for JIRA), where I can find database level information.

I am ok to go to database and run queries for getting these numbers.

Thanks

Abe

2 answers

1 accepted

1 vote
Answer accepted
Septa Cahyadiputra
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 18, 2012

Hi Abe,

You might want to review this documentation to get statistics from Confluence

If you want to get the information from your database try the following query

SELECT COUNT(*) FROM spaces;
To get the number of pages
SELECT COUNT(*) FROM content WHERE contenttype='PAGE' AND prevver is NULL;
To get the number of blogpost
SELECT COUNT(*) FROM content WHERE contenttype='BLOGPOST' AND prevver is NULL;
To get the number of version/pages
SELECT COUNT(version) FROM content WHERE contenttype='PAGE' AND TITLE='<Page Title>' AND SPACEID=<Space ID where the title reside>;
NOTE: Change the contenttype accordingly

0 votes
Bob Swift
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 18, 2012

Site Statistics has queries and charts for this type of thing.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events