nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

BHUSHAN PATIL_fap6cn

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.

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

View Space Activity

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

Regards,
Bhushan

All comments

BHUSHAN PATIL_fap6cn

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.

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

View Space Activity

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

Regards,
Bhushan

Mattia (Elevatic)

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.

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 (Elevatic)

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.