Active spaces list

Question

Hi All,

1) How to see a list of ACTIVE SPACES in confluence using TSQL command.

2) How to see a list of IN-ACTIVE SPACES in confluence using TSQL command.

Dominic Lagger · Answer

Hi @Roja Gurram

There is just one option to an inactiv space and this is when the space is archieved.

Here are the the SQL commands to get this:

SELECT * FROM SPACES where spacestatus = 'ARCHIVED';
SELECT * FROM SPACES where spacestatus = 'CURRENT'

Regards, Dominic