Get All Checked Out Items From A Site Collection Using PowerShell In SharePoint 2013

At some point, your architect/manager/customer may ask you to perform a SharePoint Migration from one version to another version. At that time, you'll be asked to analyze a lot of factors, like total data to be migrated, workflows, solution files etc. Along with that, one of the most important things is files uploaded in the document library.

Let’s say, for example, you use the Metalogix Context Matrix tool. In that, the checked out files in document library won't be migrated. To identify the files which are checked out in the entire site collection is a very tedious task manually. The below piece of PowerShell code makes life easier by getting the checked out files in the site collection in one shot. Here is the PowerShell code which will get the document library items from the site collection which are checked out.

1. #Add the PowerShell SnapIn Add - PSSnapin microsoft.sharepoint.powershell
2. # Enter the Site Collection URL $spWeb = Get - SPWeb "http://insiscvmsrv70:8888/sites/KM/"
3. #Function to get the CheckedOut items in document library
5. function GetCheckedItems($spWeb) {
6. Write - Host "Scanning Site: $($spWeb.Url)"
7. foreach($list in ($spWeb.Lists | ? {
8. $_ - is[Microsoft.SharePoint.SPDocumentLibrary]
9. })) {
10. Write - Host "Scanning List: $($list.RootFolder.ServerRelativeUrl)"
11. foreach($item in $list.CheckedOutFiles) {
12. if (!$item.Url.EndsWith(".aspx")) {
13. continue
14. }
15. $writeTable = @ {
16. "URL" = $spWeb.Site.MakeFullUrl("$($spWeb.ServerRelativeUrl.TrimEnd('/'))/$($item.Url)");
17. "Checked Out By" = $item.CheckedOutBy;
18. "Author" = $item.File.CheckedOutByUser.Name;
19. "Checked Out Since" = $item.CheckedOutDate.ToString();
20. "File Size (KB)" = $item.File.Length / 1000;
21. "Email" = $item.File.CheckedOutByUser.Email;
22. }
23. New - Object PSObject - Property $writeTable
24. }
25. foreach($item in $list.Items) {
26. if ($item.File.CheckOutStatus - ne "None") {
27. if (($list.CheckedOutFiles | where {
28. $_.ListItemId - eq $item.ID
29. }) - ne $null) {
30. continue
31. }
32. $writeTable = @ {
33. "URL" = $spWeb.Site.MakeFullUrl("$($spWeb.ServerRelativeUrl.TrimEnd('/'))/$($item.Url)");
34. "Checked Out By" = $item.File.CheckedOutByUser.LoginName;
35. "Author" = $item.File.CheckedOutByUser.Name;
36. "Checked Out Since" = $item.File.CheckedOutDate.ToString();
37. "File Size (KB)" = $item.File.Length / 1000;
38. "Email" = $item.File.CheckedOutByUser.Email;
39. }
40. New - Object PSObject - Property $writeTable
41. }
42. }
43. }
44. foreach($subWeb in $spWeb.Webs) {
45. GetCheckedItems($subWeb)
46. }
47. $spWeb.Dispose()
48. }
49. GetCheckedItems($spWeb) | Out - GridView
50. # As an alternate option you can export the data to a textfile as well.Uncomment below code to do that
51. # GetCheckedItems($spWeb) | Out - File c: \CheckedOutItemsInSiteCollection.txt - width 300

Once you run the PowerShell script using PowerShell ISE, you get the below output.