Active spaces list

[Roja Gurram]

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]

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