This below script mainly helps to get the site item count for both SharePoint Online and MOSS 2007. This will be useful when you are migrating site from MOSS2007 to SharePoint online. Script requires input csv file which contains list of site url as below Input.CSV SiteUrl http://testsite1.com http://tetsite.com when you execute the script, you need to provide 2 input parameters 'Enter input csv path with file name' - c:\script\input.csv Enter Output Path- c:\script\outpu.csv Script for SharePoint 2007 #clear the PowerShell window cls $CsvPath = Read-Host -Prompt 'Enter input csv path with file name' $ReportPath = Read-Host -Prompt 'Enter Output Path' # Exclude the following libaries / lists $excludeLists = @( "Master Page Gallery" , "User Information List" , "TaxonomyHiddenList" , "Theme Gallery" ,
Scenario: updating choice column option value for all the columns in a site collection including sub sites. Solution ; Below script will iterate through all the sites and sub sites of site collection and finds the choice column " choiceColumnName" and will change the value "Choice 1" to "Option 1". Powerhsell Script: param($url = $(Read-Host -prompt "Root Site Collection Url")) #Get the PowerShell Snapin if ((Get-PSSnapin "Microsoft.SharePoint.PowerShell" -ErrorAction SilentlyContinue) -eq $null) { Add-PSSnapin "Microsoft.SharePoint.PowerShell" } #Get Root Site $root = Get-SPSite $url #If site was found / valid if($root -ne $null) { foreach($subSite in $root.AllWebs) { $subSiteTitle = $subSite.Title Write-Host $subSiteTitle -ForegroundColor Magenta $subSiteURL = $subSite.Url Write-Host $subSiteURL -Foregroun