PowerShell Scripts for SharePoint 2010

I was working with Large Lists recently and needed to create huge amount of test data. I had to work with about 2,000 Sub Sites, 2,000 Lists, 6,000 documents and about 20,000 list items. So naturally the all so powerful PowerShell was the only answer for creating such an amount of test data with so much flexibility and ease of use. So I thought to write down here some of my scripts which someone might find useful:

1) Index Fields:

	Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
	function IndexField($fieldName, $spList)
	{
	$spField = $spList.Fields[$fieldName]
	$spField.Indexed = $true
	$spField.Update()
	$spList.FieldIndexes.Add($spField)
	$spList.Update()
	Write-Host "$fieldName Indexed"
	}
	try
	{
	$SiteUrl = "http://spsa00:6000/"
	$web = Get-SPWeb $SiteUrl
	$spList = $web.Lists["Tasks"]
	IndexField "Assigned To" $spList
	IndexField "Status" $spList
	$web.Dispose()
	}
	Catch [system.exception]
	{
	$error[0]
	}

view raw indexfields.ps1 hosted with ❤ by GitHub

2) Delete Site:

	Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
	$SiteUrl = "http://spsa00:6000/"
	$web = Get-SPWeb $SiteUrl
	$web.Delete()
	Write-Host "$SiteUrl Deleted"

view raw deletesite.ps1 hosted with ❤ by GitHub

3) Upload Document:

	Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
	function UploadFile($Web, $DocLibName, $FilePath)
	{
	$List = $Web.GetFolder($DocLibName)
	$Files = $List.Files
	$FileName = $FilePath.Substring($FilePath.LastIndexOf("\")+1)
	$File= Get-ChildItem $FilePath
	$Files.Add($DocLibName +"/" + $FileName,$File.OpenRead(),$false)
	}
	$SiteUrl = "http://spsa00:6000/"
	$Web = Get-SPWeb $SiteUrl
	UploadFile $Web "Shared Documents" "C:\Users\IA\SliderRCwebsite1.docx"
	Write-Host "Documents Uploaded to $SiteUrl"
	$web.Dispose()

view raw uploaddocument.ps1 hosted with ❤ by GitHub

4)Add New Group to Site:

	Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
	$SiteUrl = "http://spsa00:6000/"
	$web = Get-SPWeb $SiteUrl
	$user = Get-SPUser -Identity "spsa\vrd" -Web $web
	$web.SiteGroups.Add("$web Group", $user, $user, “Group Description”)
	$group = $web.SiteGroups["$web Group"]
	$group.AllowMembersEditMembership = $true
	$group.Update()
	$groupAssignment = new-object Microsoft.SharePoint.SPRoleAssignment($group)
	#Full Control,Design, Contribute, Read
	$groupRoleDefinition = $web.Site.RootWeb.RoleDefinitions["Full Control"]
	$groupAssignment.RoleDefinitionBindings.Add($groupRoleDefinition)
	$web.RoleAssignments.Add($groupAssignment)
	$web.Update()
	$web.Dispose()
	Write-Host "$SiteUrl Updated"

view raw newgroup.ps1 hosted with ❤ by GitHub

5) Create New Site:

	Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
	$SiteUrl = "http://spsa00:6000/"
	$SiteTemplate = "STS#2"
	$SiteLanguage = 1033
	$web = New-SPWeb $SiteUrl -Template $SiteTemplate -Name $Name -UniquePermissions -UseParentTopNav -Language $SiteLanguage
	$web.Dispose()
	Write-Host "Site Created for $SiteUrl"

view raw createsite.ps1 hosted with ❤ by GitHub

6) Add User to Site:

	Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
	$SiteUrl = "http://spsa00:7766/"
	$web = Get-SPWeb $SiteUrl
	$group = $web.SiteGroups["Group Name"]
	$user = Get-SPUser -Identity "spsa\vrd" -Web $SiteUrl
	$group.AddUser($user)
	$group.Update()
	$web.Update()
	Write-Host "Added to $SiteUrl"

view raw addusertosite.ps1 hosted with ❤ by GitHub

7) Clear Object Cache on All Web Front Ends

	Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
	$site = Get-SPSite "http://spsa00:7766/"
	$cache = New-Object Microsoft.SharePoint.Publishing.SiteCacheSettingsWriter $site
	$cache.SetFarmCacheFlushFlag()
	$cache.Update()
	Write-Host "Object Cache Cleared"

view raw clearobjectcache.ps1 hosted with ❤ by GitHub

8) Enable the Developer Dashboard

	Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue
	$ddb = [Microsoft.SharePoint.Administration.SPWebService]::ContentService.DeveloperDashboardSettings
	#On, Off, OnDemand
	$ddb.DisplayLevel = [Microsoft.SharePoint.Administration.SPDeveloperDashboardLevel]::OnDemand
	$ddb.RequiredPermissions = 'EmptyMask'
	$ddb.TraceEnabled = $true
	$ddb.Update()
	Write-Host "Developer Dashboard Enabled"

view raw ddb.ps1 hosted with ❤ by GitHub

Hope you find them useful!