You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
Hi,
On confluence server Instance , I would like to get with just one request on my database:
- the list of spaces
- the last access date
- the name of the admin of each space.
The goal is to identify active and passive spaces of this instance.
Best regards,
Roger
Hi @Ndofunsu
You can try and get spaces
select * from spaces;
And then you can get users something like that
select * from user_mapping where user_key in (select creator from spaces);
You can add distinct etc...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.