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: