SharePoint 2010: How to view all user checked out files for a specific document library

Problem

You need to view all files that are checked out.  If Publishing is enabled, these will also not yet be published.  Such files will not visible even if you navigate to the target folder under your Administrator account. The References section provides links to related, interesting topics.

Solution

• Use the document library's Manage files which have no checked in version option:
1. Navigate to the document library using at least a Site Collection Administrator account.
2. On the Library ribbon, click Library Settings button.
3. In the Permissions and Management group, click Manage files which have no checked in version.

References

• Designing large lists and maximizing list performance (SharePoint Server 2010)
• Managing Checked-Out Documents in SharePoint
• Configure a site library to require check-out of files
• SharePoint 2010: PowerShell Script to List the documents checked out with version details in a Site Collection
• “Manage files which have no checked in version” list larger than list view threshold

Notes

• If you click this link, and then experience the error, "The query cannot be completed because the number of lookup columns...", you will need to increase the threshold value for the list.  You can do this in Central Administration by:
1. Navigating: Central Administration > Application Management > Web Applications > Manage Web Applications
2. Select the target web application
3. Click the General Settings button on the Web Applications ribbon.
4. Select Resource Throttling from the dropdown.
5. Set the List View Threshold for Auditors and Administrators to a larger number.
• If your users upload documents in bulk to a document library that has the Require Check Out set to Yes, all of the uploaded files will be uploaded as checked out to the user who uploaded them - and the user may not be aware of this.