Confluence: Reports on Pages

I’m new to Confluence and am currently evaluating a test copy.

As part of our implementation of a document lifecycle management process, I need to be able to create simple reports, for example: schedule reviews (or other actions) in the future for all pages in the Confluence system. This requires a page reporting function.

The scheduled activity will be based on the page: date last modified meta-data. A composite report with date page created and no. of versions is also a requirement to provide potential trends in activities.

My question is: is this possible out of the box in Confluence? If not, which plugin(s) will provide this reporting functionality and, finally, for someone with little SQL/reporting experience, how difficult is it to use? I’m up against it time-wise, so a simple explanation would be really, really, helpful.

Thanks in advance!

john

3 answers

I would recommend the reporting plug-in. I think it is bundled with Confluence. Here is an example of a report that should generate what you asked for, over a given space.

{report-table} 

{content-reporter:spaces=@self|types=+page} 
{text-sort:content:title} 
{content-reporter} 

{report-column:title=Title}{report-info:page:title|link=true}{report-column} 
{report-column:title=Person Last Changing}{report-info:page:modifier}{report-column} 
{report-column:title=Last Changed Date}{report-info:page:modification date}{report-column} 
{report-column:title=Version History}{report-info:page:version history}{report-column}
{report-column:title=Version Comment}{report-info:page:version comment}{report-column}
{report-column} 

{report-table} 

Now, maybe you just want the version number instead of the version history. See http://wiki.customware.net/repository/display/AtlassianPlugins/Content+Supplier for details on the content-reporter (supplier).

The above reports on all pages in the current space. You can filter based on content, such as labels, if you wish. You can sort the resulting table based on any column or even a "hidden" column.

You might also wish to look at {pageapproval} and {pageapproval-report} macros. http://wiki.customware.net/repository/display/AtlassianPlugins/pageapproval

Archiving Plugin helps you to automate many aspects of Content Lifecycle Management.

As you asked specifically about reporting, I'd recommend you to start reading here:

  1. Content Quality report (no of up-to-date vs. expired pages, no of actively visited vs. non-visited pages, etc. per space - see below)
  2. Tracking and reporting pages that are not viewed by anyone (potentially irrelevant content)
  3. Tracking and reporting pages that are not updated for a period (potentially stale content)

 

content-quality-statistics.png

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Tuesday in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

461 views 19 9
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you