Space creation stats per user

Dominic Oliaro

Hi all,

 

Is there a way to query the database for the amount of spaces that each user has created?

I can do pages like this..

select
u.lower_username,count(u.lower_username)
from content c join user_mapping u on c.CREATOR=u.user_key
where c.CONTENTTYPE in ('PAGE') AND c.PREVVER is NULL
group by u.lower_username
order by count(u.lower_username) DESC

 

but can i get that stat data for just how many spaces a user has created?

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

Confluence does not record the space creator, beyond making them the initial admin (which can be removed)

I would want to look at why you want to know this?  Why does it matter?