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.
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.
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.
Hi Nic,
Are there any guides relating to creating a user macro to get this report data?
Start at https://confluence.atlassian.com/doc/writing-user-macros-4485.html
It looks like you're new here. Sign in or register to get started.
