SharePoint: Planning for the Future – PowerShell Scripts

I recently presented a session on planning for the future with SharePoint, as promised to the attendees, below are two of the scripts that I used in my demonstrations to audit Content databases and Site Collections. Content Database InventoryThis script outputs details of all Content Databases within a SharePoint farm to a CSV file, this includes…

2

Who are Global Business Support? What Do They Do?

It's been nearly three weeks since my last post, how time flies! I'm back with a slightly different post, the contributors of this Blog are from the PFE and CTS teams within Microsoft UK, these teams are part of a larger team known as Global Business Support (GBS). One of my colleagues recently recorded a video that…

1

Sizing SharePoint – The 2nd stage Site collection recycle bin

One of my customers asked me about the impact about the 2nd stage recycle bin on sizing a new farm. They were concerned that the default value of 50% of the current site quota could have a negative impact on sizing the farm and could influence the expected size of the contentDBs. This setting can…


Create a SharePoint Application Pool using PowerShell

As you may know there isn't an out of the box PowerShell cmdlet available in SharePoint 2010 or 2013 that can be used to create an Application Pool for a Web Application, New-SPServiceApplicationPool (http://technet.microsoft.com/en-us/library/ff607595(v=office.15).aspx) is available however this can only be used to create an Application Pool for a Service Application. A customer recently asked…


Office 365 – Exporting Site Collection Search Configuration using CSOM with PowerShell

Chris O'Brien has a fantastic Blog post – Using CSOM in PowerShell Scripts with Office 365: http://www.sharepointnutsandbolts.com/2013/12/Using-CSOM-in-PowerShell-scripts-with-Office365.html. One of the examples that he provides is how to import search configuration from an XML file, this is a new feature in SharePoint 2013 that is documented here – http://technet.microsoft.com/en-us/library/jj871675(v=office.15).aspx. I've put together a PowerShell script that can be…


Office 365 – Automating the Creation of a Design Manager Package using CSOM with PowerShell

One of the really cool features in SharePoint 2013 is the Design Manager, further information on this feature can be found here: Overview of Design Manager in SharePoint 2013 – http://msdn.microsoft.com/en-us/library/jj822363.aspx. Design Manager provides the ability to export a Design Manager Package so that customizations can be easily copied to another Site Collection and re-used -…

7

Office 365 – Automating the Creation of Managed Metadata Groups, Term Sets and Terms using CSOM with PowerShell

I've previously written a Blog post on how to output MMS Term Sets and Terms using CSOM – http://blogs.technet.com/b/fromthefield/archive/2014/03/03/office-365-output-managed-metadata-term-sets-and-terms-using-csom.aspx. This next script example can be used to automate the creation of MMS Groups, Term Sets and Terms. The only reason that I wrote this script was for an excuse to improve my understanding of the…

5

SharePoint 2013 – December CU – Exception: No mapping between account names and security IDs was done

I was recently helping a colleague to troubleshoot an issue that he was running into whilst deploying the December 2013 CU for SharePoint 2013, the following error was being logged in the upgrade log. Exception: No mapping between account names and security IDs was done 00000000-0000-0000-0000-00000000000003/03/2014 18:46:19.17 PSCONFIG (0x0EA8) 0x0BCC SharePoint Foundation Upgrade SPUpgradeSession ajxnm ERROR    at Microsoft.Office.Server.Utilities.WindowsSecurity.LookupAccountName(String accountName, String& domainName, SID_NAME_USE&…

1

Office 365 – Create Managed Metadata Terms using CSOM with PowerShell

In a follow up to my previous post – "Office 365 – Output Managed Metadata Term Sets and Terms using CSOM with PowerShell" – http://blogs.technet.com/b/fromthefield/archive/2014/03/03/office-365-output-managed-metadata-term-sets-and-terms-using-csom.aspx, I've written a sample PowerShell script that can be used to add Terms to a specific Term Set. The script uses a simple text file as input with each Term…


Office 365 – Output Managed Metadata Term Sets and Terms using CSOM with PowerShell

This PowerShell script will connect to an O365 SharePoint tenant and output the following information to the console from the Managed Metadata Term Store: Groups Term Sets Terms As with my previous CSOM scripts, this is more a sample to get you started than something you would use in production. My term store has a relatively small…

9