looking for postgres request with confluence

[Ndofunsu]

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

[aorlov]

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