SharePoint 2010: Who has what checked out…

It’s a simple quandry not always so easily solved if you are new to it. Just run, with some obvious prior editing, this query where CONTENTDB is your content database:

use CONTENTDB; 
Select d.DirName, d.LeafName, u.tp_Login
From dbo.AllDocs as d, dbo.UserInfo as u
Where d.CheckoutUserId = u.tp_ID
And tp_Login = ‘DOMAINusername’