Showing the Latest Modification Dates for All Spaces

Scenario

As administrator or content manager on a Confluence instance with a lot of content, there may be a need to know which spaces are becoming obsolete.

This recipe allows you to show the dates and times of all spaces when it was last touched by a user (commented/new additions/modified, etc).

Note: The report may take some time to load depending on the volume of content to report on.


Result


Recipe

Ingredients

Add-ons

Reporting

Platform

N/A

Level

EASY

Estimated time

15 minutes

Macros

Suppliers

Storage format

Macro structure

You can recreate the example in the editor view:

Steps

Steps

Description

1

The report will be formatted as a table with Report Table.

2

Combining Reporter is used to enclose the Content Reporter in #2. It takes the results list of contents retrieved from Content Reporter to be filtered via Repeat Filter in #7.

3

All contents from all spaces are retrieved from Content Reporter by setting spaces parameter to '@all'.

4

The contents from Content Reporter is first filtered to ensure they have valid spaces. This is done via Text Filter, setting supplier key to 'Content Supplier', and setting required parameter to 'true'.

5

The contents are then sorted according to space name via Text Sort, setting supplier key to 'Content Supplier'.

6

The contents are then sorted according to date of last modification via Date Sort, setting supplier key to 'Content Supplier'. The order is set to 'descending'.

7

The sorted and filtered list of contents from Content Reporter is then filtered again, taking out contents with same spaces, and only include the first content for each space. This is done via Repeat Filter, setting supplier key to 'Content Supplier'.

8

Each column of the table is outlined using Report Column. The three column titles are 'Space', 'Content' and 'Last Modified', in that order.

9

The space name of each content retrieved from Combining Reporter is displayed via Report Info, setting supplier key to 'Content Supplier'.

10

The content name of each content retrieved from Combining Reporter is displayed via Report Info, setting supplier key to 'Content Supplier'.

11

The date of last modification of each content retrieved from Combining Reporter is displayed via Report Info setting supplier key to 'Content Supplier'.