Script to extract checked out files

All replies

• 

  

  0

  Sign in to vote

  [System.Reflection.Assembly]::Load(“Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c”)
  
  function CheckedOutItems()
  {
      $url=Read-Host “Please Enter In Site Url”
      “SiteURL ‘t” + “FileName ‘t” + “CheckedOutTo ‘t” + “ModifiedDate ‘t” + “Version” >> c:\temp\checkedoutfiles.csv
      $site = New-Object Microsoft.SharePoint.SPSite($url)
      $webs = $site.AllWebs
  
      foreach($web in $webs)
      {
          $listCollections=$web.Lists
          foreach($list in $listCollections)
          {
              if($list.BaseType.ToString() -eq “DocumentLibrary”)
              {
                  $dList=[Microsoft.SharePoint.SPDocumentLibrary]$list
                  $items = $dList.Items
                  $files = $dList.CheckedOutFiles
                  foreach($file in $files
                  {
                      $wuse=$file.DirName.Substring($web.ServerRelativeUrl.Length)
                      $web.Url + “‘t” + $wuse + “‘/” + $file.LeafName + “‘t” + $file.CheckedOutBy.Name + “‘t” + $file.TimeLastModified.ToString() + “‘t” + “No Checked In Version” >> c:\temp\checkedoutfiles.csv
                  }
              }
          }
      $web.Dispose()
      }
  $site.Dispose()
  }
  
  CheckedOutItems

  https://sharepoint.stackexchange.com/questions/169831/sp2007-list-all-checked-out-unversioned-files

  Regards

  Prasad Tandel

  Saturday, October 14, 2017 6:09 PM