June 8, 2010

Microsoft Project Server 2010 and PowerShell

In case you have not heard SharePoint 2010 and Project Server 2010 will support PowerShell and hence will ship with a library of already about 650 commands. Please find below a few examples I wrote trying to automate Project Service Application creation.

One useful commands to get started: Get-Help *project* (lists all cmdlet that contains the word ‘project’).

Check out this recently Project Server 2010 PowerShell Help file for more information: http://technet.microsoft.com/en-us/library/ee890098(office.14).aspx

As usual we will release Project Server 2010 PowerShell documentations by RTM on TechNet. One of the great thing about PowerShell is that you can easily create your own commands (think of a utility that issues PSI calls for instance…), stay tune for more samples MSDN, in the meantime experiment the power of PowerShell 🙂

$projectapppool = "ProjectServer-AppPool"
$projectserviceapp = "ContosoProjectServiceApplication"
$pwaname = "PWA"
$projectwebappname = "Contoso Project Server Site"
$projectwebappport = 82
$projectwebappurl = "http://www.contoso.com"
$projectwebcontentdb = "ProjectServer"+$projectwebappport+"_Content"
$adminaccount = "contosoadministrator"
$databaseserver = "DEMO2010A"
    
# Create Application Pool
New-SPServiceApplicationPool  -Name $projectapppool -Account $adminaccount

# Create Project Service Application
New-SPProjectServiceApplication -ApplicationPool $projectapppool -Name $projectserviceapp

# Create Project Service Application Proxy
New-SPProjectServiceApplicationProxy -Name ContosoProjectServiceApplicationProxy -ServiceApplication $projectserviceapp

# Create Project Server Web Application with its own Content Database
New-SPWebApplication -Name $projectwebappname -Port $projectwebappport -URL $projectwebappurl -ApplicationPool $projectapppool -ApplicationPoolAccount $adminaccount -DatabaseName $projectwebcontentdb

# Create New Project Server Site Collection
# Get-SPWebTemplate
New-SPSite -Url ($projectwebappurl+ ":" +$projectwebappport) -OwnerAlias $adminaccount -ContentDatabase $projectwebcontentdb -Template PWS#0

# Provision PWA Instance
New-SPProjectWebInstance -AdminAccount $adminaccount -ArchiveDbname ($pwaname +"_Archive") -DraftDbname ($pwaname +"_Draft") -PrimaryDbserver $databaseserver -PublishedDbname ($pwaname +"_Published") -ReportingDbname ($pwaname +"_Reporting") -ReportingDbserver $databaseserver -Url ($projectwebappurl + ":" + $projectwebappport + "/" + $pwaname) -Lcid 1033

Great PowerShell resources:

PowerGui: http://powergui.org (great UI editor for PowerShell)
Zach Rosenfield’s Blog: http://sharepoint.microsoft.com/blogs/zach/Lists/Categories/Category.aspx?Name=PowerShell (contains lots of SP 2010 examples as well as an intro to PowerShell)
- PowerShell 2010: Basic Discovery
- PowerShell 2010: Basic SharePoint Cmdlets
- SP 2010: Intro to PowerShell Part 3
- SP 2010: Intro to PowerShell Part 4
PowerShell team blog: http://blogs.msdn.com/PowerShell
Master-PowerShell | With Dr. Tobias Weltner (eBook): http://powershell.com/cs/blogs/ebook/ (if you want to go beyond standard commands and start creating your own)