Tuesday 11 April 2017

Delete all items from large list in SharePoint using Powershell



$AuditSite = Get-SPWeb "http://sharepoint/sites/AuditReport"
$list = $AuditSite.Lists["Test"]
$count = $list.ItemCount
$round = ($count/5000)+1
for($i -eq 0; $i -lt $round;$i++){
  $spQuery = New-Object Microsoft.SharePoint.SPQuery
  $spQuery.RowLimit = 5000
  $items = $list.GetItems($spQuery);
  $items.Count
  if($items.Count -gt 0)
  {
      $items | % {$list.GetItemById($_.Id).Delete()}
  }
}
$AuditSite.Dispose()

No comments:

Post a Comment