How to get Confluence Stats

AbrahamA

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

Septa Cahyadiputra

Hi Abe,

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

• How do I Get More 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