SharePoint列表数据清除

–获取站点对象

$spWeb =get-spweb http://123.sinochem.com

–获取具体列表对象

$spList =$spWeb.GetListFromUrl(“http://123.sinochem.com/Lists/Tasks/AllItems.aspx“)

–定义查询对象

$spQuery = New-Object Microsoft.SharePoint.SPQuery

–拼接查询条件

$camlQuery = ‘<Where><Leq><FieldRef Name=”Created” /><Value Type=”DateTime”>2017-01-11</Value></Leq></Where>’

–将查询条件赋值到查询对象

$spQuery.Query = $camlQuery

–执行查询，获取结果

$spListItem = $spList.GetItems($spQuery)

–结果数据查看

$spListItem[0].ID $spListItem[0].UniqueId $spListItem[0].Title

–循环删除结果项

Write-Host $spListItem.Count $spListItem|%{$spList.GetItemById($_.Id).Delete()} $spList.Update()