Generate a SQL query to find out the number of spaces, the number of pages in each of those spaces

[Central1 Admin Douglas Phan]

I'm looking to an MS SQL Query to find out the Spaces we have, how pages each of those spaces have and the number of attachments it has.

[JimmyVanAU]

Hi there,

Be careful as Nic says. There are a number of Atlassian KB docs which can guide you:

https://confluence.atlassian.com/confkb/how-to-find-the-total-amount-of-space-used-for-a-single-space-s-attachments-229839506.html

https://confluence.atlassian.com/confkb/how-to-get-more-statistical-data-disk-space-contents-created-from-confluence-s-usage-830284173.html

Once again, be careful, and do your best to run on a database clone or non-production instance.

[Nic Brough -Adaptavist-]

This is the sort of SQL that could kill your database (not damage it, but the nested searches you'd need to do could rapidly overwhelm it)

I'd strongly recommend writing a user macro to do this instead, as you can (sort of) get directly into the API, which will not overload your database and can get to the answers a lot quicker.

[Central1 Admin Douglas Phan]

Hi Nic,

Are there any guides relating to creating a user macro to get this report data?

[Nic Brough -Adaptavist-]

Start at https://confluence.atlassian.com/doc/writing-user-macros-4485.html