It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confluence user created date

Jason Skrzypek Aug 02, 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 Aug 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 Aug 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
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

867 views 0 19
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you