Confluence user created date

Question

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

Richard Yale · Answer

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.

Richard Yale · Answer

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.