I wanted to give our various managers some metrics to base some of their upcoming reviews on, so I wrote up this SQL query showing the top 5 page creators for each space - others may be interested in this as well. I'm sure there are ways of making this more efficient, but it got me what I needed.
With allpages as (
FROM [CONTENT] c
join SPACES s on s.SPACEID=c.SPACEID and left(s.SPACEKEY,1)<>'~'
left join user_mapping u on u.user_key=c.CREATOR
left join cwd_user AS cu ON cu.lower_user_name = u.lower_username
where c.[CREATIONDATE]>'2020-01-01 01:01:05.000'
, spacepages as (
,count(CONTENTID) as numpages
group by display_name, email_address,SPACENAME
Select * from (
,row_number() over (partition by SPACENAME order by numpages desc) as spacerank
from spacepages) ranks
where spacerank <=5;
Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...
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