Add-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue $SiteCollections = @() $Data = Import-Csv -Path C:\Everything\SitesProfile.csv if($Data) { [string]$SiteUrls ="" foreach($Site in $Data) { $SiteUrl = $Site.SiteUrl $sitecoll = New-Object Microsoft.SharePoint.SPSite($SiteUrl) foreach ($web in $sitecoll.AllWebs) { foreach ($list in $web.Lists) { if ($list.Hidden) { continue } $data = @{ "Site" = $sitecoll.Url "Web" = $web.Url "List" = $list.Title "ItemCount" = $list.ItemCount "LastModified" = $list.LastItemModifiedDate } $List = New-Object PSObject -Property $data $SiteCollections +=$List } $web.Dispose(); } $sitecoll.Dispose() } }
#$SiteCollections | Out-GridView #$SiteCollections | Export-Csv -NoTypeInformation -Path C:\Everything\Inventory.csv