In this post I’ve sum up some power shell scripts for SharePoint Inventory, I will keep update this post with new PS scripts so that other admins benefits from this post.
Add-PSSnapin Microsoft.SharePoint.PowerShell
[System.reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
$web = Get-SPWeb "http://yourportaladdress"
$list = $web.Lists["NameOfList"]
$DeleteBeforeDate = [Microsoft.SharePoint.Utilities.SPUtility]::CreateISO8601DateTimeFromSystemDateTime([DateTime]::Now.AddDays(-10))
$caml='<Where> <Lt> <FieldRef Name="Created" /><Value Type="DateTime">{0}</Value> </Lt> </Where> ' -f $DeleteBeforeDate
$query=new-object Microsoft.SharePoint.SPQuery
$query.Query=$caml
$col=$list.GetItems($query)
Write-Host ("Total Item's created before 10 days is : {0}" -f $col.Count)
$confirmation = Read-Host "Are you Sure You Want To Proceed (y/n):"
if ($confirmation -match "[yY]") {
$col | % {$list.GetItemById($_.Id).Delete()}
}
$web.Dispose()
S-E-N-S-E Developers' Corner 