Create a SharePoint site map in Visio using Powershell

A great little script that crawls your farm and produces a nice visual site map.

Works on SharePoint 2007, 2010, and 2013.  

Rename Web Application in Central Admin

Sometimes web applications get created with names that aren't very descriptive , or are just untidy, so here is a short Power Shell script for renaming them.

Batch check in multiple files with Powershell

I recently came across a problem where a user had migrated 10000 documents to a Team Site. The user hadn't turned off the check in/out in the library settings, so all the documents needed manually checking in.

This normally wouldn't be a problem. The user could either navigate to the manage content and structure page '/_layouts/sitemanager.aspx?' or, I could take ownership from library settings > Manage files which have no checked in version  '/_layouts/ManageCheckedOutFiles.aspx?' and check them in myself.

Unfortunately, from 'manage content and structure' you can only check in 2100 files at once. This is something to do with a SQL limit.

Instead I used the following PowerShell script. This iterates through all the folders in the library you specify, takes ownership of the files, then recursively checks in all files that are checked out.

Import a SharePoint 2007 list to 2010

SharePoint 2007 and 2010 both support .stp templates. So the east way to migrate a list should be to create a template in 2007, upload to 2010, and create the list from it. Except that wont work, SharePoint 2010 complains that the it doesn't support version 3 templates. Fortunately there is a fairly easy way to fix this.

Rename Central Administration Database (Sharepoint_Config)

The Central Admin DB is automatically created with a horrible GUID. To remove this we need to create a new DB, move the DB and remove the old DB.