Reporting on all checked out pages within a SharePoint WCM Site Collection


Table of Contents

Picture this scenario...you have put the new Internet into Production for authors to go and enter their content. And it's close to go-live and you notice that pages are not showing up in the navigation. It turns out that the pages are still checked out to users.
In SharePoint there are views to see what pages are 'CHecked out by me', but not for everyone...even if you are an Owner of the Site Collections and Sub Sites. This view will also only show you in context of the Site you are selecting...not all pages in all sites.

Content by Query Web Part approach

Jamie has provided a great approach on using a Content by Query Web Part to list the pages using CAML.

Further Customise CQWP to Display Draft and Checked Out Pages By User by Jamie McAllister

STSADM approach

Waldek has written a STSADM extension command and posted it on CodePlex that will not only report the pages if run on the server, but also give you options to uncheck, checkin etc at server level. Obviously this is a bit more restricted from the perspective of Authors who won't have access to the server (hopefully!)

Manage Checked Out Publishing Pages (OCDCheckedOutPages StsAdm command by Waldek Mastykarz

Structure Reports

WCM includes a feature that installs a 'Content and Structure Report List'. Out of the box you will see various default reports available from Site Actions | View Reports' such as 'Checked out by Me'.
You can create your own custom reports, in this scenario you can create one with the following customised XAML:

<Where><Geq><FieldRef Name="CheckoutUser" LookupId="TRUE"/><Value Type="int">0</Value></Geq></Where>

More information on Structure Reports can be found here Report Rapport in MOSS 2007 by Lincoln DeMaris

Labels

reporting reporting Delete
publishing publishing Delete
wcm wcm Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.



Creative Commons License
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License. Hosted generously by CustomWare