How to find static spaces

[david cockrell]

Hi Community,

We would like to check our Confluence instance if there are static spaces.

for example: a static space could be a space that all/most of it's pages were not edited for over 3 years.

Are there any best practices for doing this? maybe via SQL script

[BHUSHAN PATIL · Accepted solution]

Hi @david cockrell ,

There are several ways to check for static spaces in Confluence

• One way is to use the Confluence Analytics feature to identify unused spaces by sorting the table by views (ascending) and selecting a space to see detailed statistics, including most popular content and active contributors. From there, the space administrator or active contributors can be contacted to see whether the space could be archived or backed up and removed.

1. Identify unused spaces

• Another way is to view space activity, which displays statistics on the activity in each space, including how many pages and blog posts have been viewed, added, or updated over a given period, which content is the most popular (most frequently viewed), which content is the most active (most frequently edited), and which people are the most active contributors/editors of content

1. View Space Activity

Also, if you feel my input help you please accept the answer.

Regards,
Bhushan

[david cockrell]

Thanks Bhushan,

I was not aware of the this "cleanup option. 

I am reviewing it now. 

unfortunately I am only getting 3 months back (due to the large size of the instance) but I think this can give me a good starting point for potential cleanup.

[Mattia _Communardo_]

Hello @david cockrell 

As you're running Confluence Server you will not have the built-in Analytics included. It means your best option is to retrieve the desired data from the database directly. This how-to article has examples of how to do this.

Best regards,
Mattia

[david cockrell]

Hi Mattia,

We are running Data Center so we do have analytics (not sure why my question was tagged as "Server")

However, due to the large size of our instance we are only getting analytics for 3 months back... So your link might come handy anyway. 

[Mattia _Communardo_]

I see. If you are running Data Center and are reaching the limits of Confluence's built-in Analytics, you might want to try the Viewtracker app from the Marketplace.
It offers several reports and with just a few clicks you can get the information you are looking for as well as further insights.