Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,678
Community Members
 
Community Events
168
Community Groups

looking for postgres request with confluence

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

1 answer

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...

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
TAGS

Atlassian Community Events