Under Content and Structure (_layouts/sitemanager.aspx) there are a set of views that allow you to filter items in your site. For instance, “Checked Out To Me”, “Pending Approval” are just two of the out of the box views. One report that is not there, but should be, is a view for all checked out pages by all users. Happily, you can add your own custom views by editing the “Content and Structure Reports.”
From Site Actions, select “View All Site Content”
Click on “Content and Structure Reports”
You’ll see all of the canned reports listed:
Click “Add New Item” and enter the Report Title and CAML Query:
<Where><Geq><FieldRef Name=”CheckoutUser” LookupId=”TRUE”/><Value Type=”Integer”>0</Value></Geq></Where>
Save and close
To use the report, go to Site Actions > Manage Content and Structure and change the View to the new “All Checked Out” report:
Chris "Jake" Jacobsen 
#1 by Marcel Gaarenstroom on May 30, 2012 - 10:24 am
Hello,
Nice tut…
But, how can I see checked out documents in all the sites, now I’ll have to click on pages to see checked out documents.
Is there a possibility to do this from HOME.
I am Working for several schools and we have lots of subsites… and I want to see all Checked out pages, by me or somone else.
Regards Marcel
#2 by Jake on May 30, 2012 - 8:00 pm
Good Question, Marcel. As far as I know, it’s not easily done using this method. Ultimately, you might want to write a PowerShell script that traverses all sites to gather all the checked-out files. I think that’s your best bet.
Jake
#3 by Donal Conlon on November 20, 2012 - 6:57 pm
This is a fantastic blog and just what I was looking for. you are a God sir. A God!!
#4 by Jake on November 20, 2012 - 7:10 pm
That’s nothin. You should see me dance!
#5 by Nancy Skaggs (@Nanskatoon) on June 18, 2013 - 12:05 pm
Love this idea! I need this query to run on Pages libraries, however, not Document Libraries. How can that be achieved?