Friday, September 25, 2009

All checked out documents for site collection

Scenario:
Can we generate a list of documents checked out to anyone – a list of all checked out documents not just Checked Out To me

Steps ( MOSS only ) :

1. Navigate to Home > View All Site Content > Content and Structures Reports > Create a new report with following CAML Query

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

2. Navigate to Site Action > Manage Content and Structure > Change the view to All Checked Out documents ( from right side view drop down)

12 comments:

Anonymous,  October 16, 2009 at 2:13 AM  

Nice one Sandeep.
-nn

Anonymous,  November 17, 2009 at 8:04 AM  

Thank you!
You are great!

Anonymous,  December 2, 2009 at 5:25 PM  

How to limit those to a Document library?

Sandeep K Nahta December 2, 2009 at 9:41 PM  

Check out concept applies to Document Library only

CJ Randolph,  March 8, 2010 at 11:59 AM  

I just use instead of greater than zero. Also it should be noted that your query cannot have any spaces outside the tags. If your query doesn't work don't give up, keep checking that your fomatting is correct.

The query I am using to get a list of documents that have been checked out more than seven days:

Sandeep K Nahta March 8, 2010 at 9:04 PM  

CJ , I think there is one such Query already with OOTB installation.

Last Sever Days checked out documents

Anonymous,  March 11, 2010 at 7:20 AM  

Is there a way to display who has the document checked out with this report?

Sandeep K Nahta March 11, 2010 at 9:33 AM  

hmm.. with custom webpart = yes

Anonymous,  April 5, 2010 at 12:35 AM  

How to limit to subsite? means I need to see all checked-out documents from subsite only not from all sites? How do I modify where clause?

Sandeep K Nahta April 5, 2010 at 12:41 AM  

I need to validate but if you set CAML List Type to Web it should work.

Also in the treeview when you click a particular site and select the proper report from the View Drop Down then it should limit to that site only.

Anonymous,  April 6, 2010 at 12:58 AM  

Can you explain how to do 'set CAML List Type to Web'? Is it possible to edit these reports into designer? if yes then please give me steps. Can you post your email address?