As I keep having to figure this out every time I come to do it I’m leaving it here for reference.
To find a SharePoint feature when you only know part of the name of it the following command can be used:
|
1 |
Get-SPFeature | where { $_.DisplayName -like "*something*" } | format-list -property displayname |
I needed to set up a new web application that was a copy of an existing web application. The constraint was that there was only one farm available to work with (I did have other farms but they were running different versions of SQL server).
Approach 1
I’ll first point out that this didn’t work, skip ahead if you’re not interested.
I went through the following steps:
The result was the database attached but it had no site collections in it.
It turns out that this approach could work but only if you attach it to a different farm. You can then backup that database and restore/attach it back on the source farm.
As I stated at the beginning – I didn’t have the luxury of a second farm.
Approach 2
The only option left that I could think of was to backup and restore each site collection manually.
I knocked up the following powershell script to automate this and it worked …
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
$sourceApp = "http://source.example.com" $targetApp = "http://target.example.com" $app = Get-SPWebApplication -Identity $sourceApp foreach ($site in $app.Sites) { Write-Host performing backup of $site.URL Backup-SPSite -Identity $site.URL -Path "c:\backup\migration.bak" -force $newurl = $site.URL -replace $sourceApp, $targetApp Write-Host restoring into $newurl Restore-SPSite -Identity $newurl -Path "c:\backup\migration.bak" -force -confirm:$false } |
So I needed to ensure that all sites in my farm were formatting dates in the British format …
Powershell, once again, to the rescue! This is what I ended up with …
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
Add-PSSnapin Microsoft.SharePoint.PowerShell foreach ($app in Get-SPWebApplication) { foreach ($site in $app.Sites) { foreach($web in $site.AllWebs) { Write-Host processing $web in site $site in app $app If ($web.locale -ne 2057) { $web.Locale = 2057; $web.Update(); Write-Host UPDATED $web in site $site in app $app } } } } |
So I had a need to get a csv that could tell me who was in which groups in which sites.
Powershell to the rescue! This is what I ended up with …
There may be a better way to do this but the main thing is that it works and it was quick!
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
Add-PSSnapin Microsoft.SharePoint.PowerShell function OutputRow($url, $group, $member) { $out = new-object psobject $out | add-member noteproperty url $url $out | add-member noteproperty group $group $out | add-member noteproperty member $member write-output $out } foreach ($app in Get-SPWebApplication) { foreach ($site in $app.Sites) { OutputRow $site.Url "primary site owner" $site.owner OutputRow $site.Url "secondary site owner" $site.SecondaryContact foreach($web in $site.AllWebs) { if (!$web.HasUniqueRoleDefinitions) { OutputRow $web.Url "Everything Inherited from parent" "" } else { if ($web.RequestAccessEnabled) { OutputRow $web.Url "request access email" $web.RequestAccessEmail } foreach($group in $web.sitegroups) { if ($group.users.Count -eq 0) { OutputRow $web.Url $group.name "Empty Group" } foreach ($user in $group.users) { OutputRow $web.Url $group.name $user.name } } } } } } |