Confluence user created date

Jason Skrzypek August 2, 2011

I have to do a growth rate since we installed confluence. Is there a way to find a user created date, so i can show how many people have been added to the system. Is it also posisble to do the same with pages (display all page created dates on one page)??

Thank you

2 answers

0 votes
Richard Yale
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.
August 15, 2011

You will need to go into the database and do a few different queries. The first for users will be the [users] table and you'll want to look at the "created" column. For the pages you'll want to look at the [content] table and you'll want to filter by the creationdate column and do a where version = 1 and contenttype = page.

0 votes
Richard Yale
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.
August 15, 2011

You will need to go into the database and do a few different queries. The first for users will be the [users] table and you'll want to look at the "created" column. For the pages you'll want to look at the [content] table and you'll want to filter by the creationdate column and do a where version = 1 and contenttype = page.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events