In the confluence database I find more spaces than in Confluence itself; why is this?

[Harold de Bell]

query: select spacename from spaces where spacestatus <> 'ARCHIVED';

gives more spaces than when I look in Confluence under Space Directory --> All Spaces

[Ollie Guan]

Hello @Harold de Bell ,

Through the database, you should be able to look up these missing space keys. Can you access these space directly in the system?

[Harold de Bell]

That's the issue; why are spaces mentioned in the DB missing in Confluence?

[Ollie Guan]

Do you have access to all spaces (personal and public)?

As a system administrator, i think you can find these spaces in Individual Spaces.