PowerShell for SharePoint 2010 How-To


Need fast, reliable, easy-to-implement solutions for automating SharePoint 2010 administration with PowerShell? This book delivers exactly what you’re looking for: step-by-step help and guidance with the tasks you’ll perform most often. You’ll find tested PowerShell scripts and proven techniques for managing installations, servers, farms, IIS, users, services, sites, data, solutions, enterprise services, and more. You’ll even find practical guidance and tested solutions for getting more value from Enterprise ...

See more details below
Other sellers (Paperback)
  • All (9) from $18.69   
  • New (7) from $18.69   
  • Used (2) from $21.88   
PowerShell for SharePoint 2010 How-To

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study

Want a NOOK? Explore Now

NOOK Book (eBook)
BN.com price
(Save 44%)$27.99 List Price


Need fast, reliable, easy-to-implement solutions for automating SharePoint 2010 administration with PowerShell? This book delivers exactly what you’re looking for: step-by-step help and guidance with the tasks you’ll perform most often. You’ll find tested PowerShell scripts and proven techniques for managing installations, servers, farms, IIS, users, services, sites, data, solutions, enterprise services, and more. You’ll even find practical guidance and tested solutions for getting more value from Enterprise Search and PerformancePoint business intelligence. The industry’s most focused resource for scripting SharePoint with PowerShell, this book provides all the answers you need—now!

Fast, Accurate, and Easy-to-Use!

  • Run PowerShell scripts from the SharePoint 2010 Management Shell console
  • Perform unattended SharePoint installations
  • Configure new farms, add servers, and manage sites
  • Create new site collections and sub-sites
  • Review and set Farm Configuration Values and SharePoint Designer Settings
  • Display, get, create, remove, configure, and extend web applications
  • Create, manage, remove, back up, and restore SharePoint databases
  • Work with SharePoint solutions and features
  • Automatically publish and manage content
  • Control Office features: Excel Services, Access Services, Visio Graphic Services, Word Services, and PerformancePoint Services
  • Administer InfoPath Form Services, profiles, metadata, Secure Store, and other service applications
  • Change the behavior of Enterprise Search and SharePoint Foundation Search
  • Manage external data connections via Business Data Connectivity Service
Read More Show Less

Product Details

  • ISBN-13: 9780672335594
  • Publisher: Sams
  • Publication date: 7/6/2011
  • Series: How-To Series
  • Edition number: 1
  • Pages: 272
  • Sales rank: 1,258,863
  • Product dimensions: 6.00 (w) x 8.90 (h) x 0.70 (d)

Meet the Author

Steve Mann was born and raised in Philadelphia, Pennsylvania, where he still resides today. He is an Enterprise Applications Engineer for Morgan Lewis and has more than 17 years of professional experience. Steve was previously a Principal Architect for RDA Corporation, where he worked for more than 13 years.

For the past 8 years, Steve has primarily focused on collaboration and business intelligence solutions using Microsoft technologies. He managed the internal BI Practice Group at RDA for several years. He was also heavily involved within RDA’s Collaboration/Search Practice Group.

Steve has authored and coauthored several books related to the subject of SharePoint Server 2010. His blog site can be found at www.SteveTheManMann.com.

Read More Show Less

Table of Contents

Introduction 1

Part I: Getting Started

1 SharePoint 2010 Management Shell 5

How Do I Run PowerShell? 6

How Do I Make PowerShell Aware of SharePoint? 6

What Is the SharePoint 2010 Management Shell? 7

What Is the SharePoint 2010 Management Shell Loading? 8

2 PowerShell Basics 11

What Is a Cmdlet? 12

How Can I See the Possible Verbs for a Noun Command? 12

What Is a Parameter? 12

What Is a Switch Parameter? 12

How Can I See the Possible Parameters for a Cmdlet? 12

What Does F3 Do? 13

What Does F7 Do? 13

What Are Console Commands? 14

Path Environment Variable 14

Run Unsigned Scripts 15

Disable the Confirmation Prompt 15

Generate Inline Credentials 16

Reference an Assembly 17

Part II: Server Management

3 SharePoint Installation and Configuration 21

Prepare the Microsoft SharePoint Installation Module 22

Install SharePoint Unattended 23

Installing Without a Product Key in the Configuration File 24

Configure a New SharePoint Farm 24

Join a Server to the SharePoint Farm 26

Create a New Web Application 26

Create a New Site Collection 27

Create a New Subsite 28

4 Farm Management 31

Review Farm Configuration Values 32

Set the Farm Configuration Values 32

Refresh Installed Products 34

Change the Port of Central Admin 34

Change the Farm Passphrase 34

Retrieve the System Accounts 35

Retrieve Managed Accounts 36

Rename a Site Template 36

Rename a Server on the Farm 37

Display the Configured Managed Paths 37

Create a New Managed Path 38

Remove a Managed Path 39

Merge Log Files 39

End the Current Log File 40

Review SharePoint Designer Settings 41

Configure SharePoint Designer Settings 41

Review Workflow Configuration Settings 42

Modify Workflow Configuration Settings 43

Display Available Timer Jobs on the Farm 44

Get a Specific Timer Job 45

Enable a Timer Job 46

Disable a Timer Job 46

Start a Timer Job 46

Set the Schedule for a Timer Job 47

5 Web Application Management 49

Display Available Web Applications on the Farm 50

Get a Specific Web Application 50

Remove a Web Application 51

Create a New Web Application 51

Configure Web Application Settings 52

Extend a Web Application 53

Create an Alternate Access Mapping URL 54

Display All Alternate Access Mappings 55

Get a Specific Alternate URL Entry 55

Change the Zone of an Alternate Access Mapping 56

Remove an Alternate Access Mapping 56

6 Service Application Management 59

Install Service Applications 60

Display Available Service Applications on the Farm 60

Get a Specific Service Application 61

Configure IIS Settings for a Service Application 61

Share a Service Application 62

Remove a Service Application 63

Display Service Instances on a Server 64

Get a Specific Service Instance 65

Start a Service Instance 65

Stop a Service Instance 66

Ancillary Cmdlets for Service Applications 66

7 SharePoint Database Management 67

Display All SharePoint Databases 68

Get a Specific Database 69

Create a New Content Database 69

Display All Content Databases for a Web Application 70

Detach a Content Database from a Web Application 71

Attach a Content Database to a Web Application 72

Delete a Content Database 72

Create a New Configuration Database 73

Delete a Configuration Database 73

Back Up a Configuration Database 74

Restore a Configuration Database 75

Back Up the SharePoint Farm 75

Restore the SharePoint Farm 76

Back Up a Site Collection 76

Restore a Site Collection 77

Part III: Development and Administration

8 Site Management 81

Display All Available Site Collections on the Farm 82

Display Available Site Collections in a Web Application 82

Display Available Site Collections in a Content Database 83

Get a Specific Site Collection 83

Remove a Site Collection 84

Create a Site Collection 84

Set the Lock State of a Site Collection 85

Set the Storage Limits on a Site Collection 86

Create a Site Under a Site Collection 87

Display All Subsites within a Site Collection 87

Get a Specific Subsite (Web) 88

Remove a Subsite (Web) from a Site Collection 88

Modify the Subsite (Web) URL 89

Move a Site Collection to a Different Content Database 89

Move All Site Collections from One Content Database to Another 90

9 Solutions and Features 91

Add a Solution to the SharePoint Farm 92

Display Available Solutions on the Farm 92

Get a Specific Solution 93

Deploy a Solution to a Web Application 93

Retract a Solution 94

Upgrade a Deployed Solution 95

Remove a Solution from the SharePoint Farm 96

Add a Sandboxed Solution to a Site Collection 96

Display Available Sandboxed Solutions in a Site Collection 97

Get a Specific Sandboxed Solution 97

Activate a Sandboxed Solution 98

Deactivate a Sandboxed Solution 98

Upgrade a Deployed Sandboxed Solution 99

Remove a Sandboxed Solution from a Site Collection 99

Display Available Features 100

Get a Specific Feature 101

Activate a Feature 101

Deactivate a Feature 102

Install a Feature in SharePoint 103

Uninstall a Feature from SharePoint 103

Export Installed Farm Solutions 104

10 Content Deployment 105

Create a New Deployment Path 106

Display Deployment Paths Configured on the Farm 106

Get a Specific Content Deployment Path 107

Remove a Content Deployment Path 107

Create a New Deployment Job 108

Display Deployment Jobs Configured on the Farm 108

Get a Specific Content Deployment Job 109

Remove a Content Deployment Job 109

Start a Content Deployment Job 109

Modify Content Deployment Configurations 110

Part IV: Service Application Management

11 InfoPath Forms Services 113

Browser-Enable Form Templates 114

Throttle Data Connection Timeouts 114

Throttle the Data Connection Response Size 115

Modify Authentication Settings 115

Configure Session State 116

Enable View State 117

Verify and Upload a Form Template 118

Upload Multiple Form Templates at Once 118

Activate or Deactivate a Form to or from a Site Collection 119

Remove a Form from InfoPath Form Services 119

Quiesce a Form from InfoPath Form Services 120

Enable the Web Service Proxy 120

12 Enterprise Search 123

Display the Enterprise Search Service Information 124

Display Enterprise Search Service Instances 124

Get a Specific Enterprise Search Service Instance 125

Configure the Crawl Account for Enterprise Search 126

Configure the Enterprise Search Service Performance Level 126

Display Enterprise Search Service Applications 127

Get a Specific Enterprise Search Service Application 128

Create a Custom Metadata Category 128

Display Available Metadata Categories 129

Get a Specific Metadata Category 129

Create a Custom Metadata Crawled Property 130

Display Available Crawled Properties 131

Get a Specific Metadata Crawled Property 132

Create a Custom Metadata Managed Property 133

Display Available Managed Properties 133

Get a Specific Metadata Managed Property 134

Create a Metadata Mapping 135

13 SharePoint Foundation Search 137

Display the Search Service Information 138

Display Search Service Instances 138

Get a Specific Search Service Instance 139

Configure the Crawl Account 139

Configure the Maximum Backup Duration 141

Configure the Search Service Performance Level 141

14 Profile Service 143

Get the Identity of the Profile Service Application 144

Get a Specific Profile Service Application Instance 144

Configure Settings on the User Profile Service Application 145

Remove Old Comments 145

Remove Old Ratings 146

Remove Old Tags 146

Update the Profile Photo Store 147

Use Ancillary Cmdlets for the User Profile Service 147

15 Business Data Connectivity Service 149

Get the Identity of the BCS Service Application 150

Get a Specific BCS Service Application Instance 150

Configure the BCS Database 151

Get a BCS Metadata Object 151

Import a BCS Model 152

Export a BCS Model 153

16 Secure Store Service 155

Get the Identity of the Secure Store Service Application 156

Get a Specific Secure Store Service Application Instance 156

Enable Auditing for the Secure Store Service 157

Configure the Secure Store Database 157

Generate a New Master Key 158

Refresh the Encryption Key 159

Create Application Fields 159

Create a Target Application 161

Create a New Application Entry 161

17 Metadata Service 163

Get the Identity of the Metadata Service Application 164

Get a Specific Metadata Service Application Instance 164

Configure the Metadata Service Accounts 165

Configure the Term Store Database 165

Configure the Content Type Hub 166

Get the Identity of the Metadata Service Proxy 166

Get a Specific Metadata Service Application Proxy Instance 167

Configure the Metadata Service Connection Options 168

18 Session State and State Services 171

Enable Session State 172

Disable Session State 172

Display Session State Information 173

Configure the Timeout of the Session State 174

Display State Service Applications Configured on the Farm 175

Get a Specific State Service Application 175

Rename a State Service Application 176

Perform a State Service Database Operation 176

Part V: Office Features

19 Excel Services 181

Create a Trusted File Location 182

Display All Trusted File Locations 183

Get a Specific Trusted File Location 183

Remove a Trusted File Location 184

Create a Trusted Data Connection Library 185

Display All Trusted Data Connection Libraries 185

Get a Specific Trusted Data Connection Library 186

Remove a Trusted Data Connection Library 186

Create a New Safe Data Provider 187

Display All Safe Data Providers 188

Get a Specific Safe Data Provider 188

Remove a Safe Data Provider 189

Create a Blocked File Type 190

Display All Blocked File Types 190

Get a Specific Blocked File Type 191

Remove a Blocked File Type 191

Create a User-Defined Function Reference 192

Display All User-Defined Function References 192

Get a Specific User-Defined Function Reference 193

Remove a User-Defined Function Reference 193

Modify Excel Services Objects 194

20 PerformancePoint Services 195

Configure the Unattended Service Account 196

Display the Unattended Service Account 196

Create a Trusted Content Location 197

Create a Trusted Data Source Location 198

Display All Trusted Content Locations 198

Display All Trusted Data Source Locations 199

Display Details of Trusted Locations 199

Get a Specific Trusted Location 200

Remove a Trusted Location 200

Configure PerformancePoint Services to Enforce Trusted Locations 201

Configure PerformancePoint Services Application Settings 202

21 Access Services 203

Configure the Application Log Size 204

Configure the Cache Timeout 204

Modify the Maximum Columns in a Query 205

Modify the Maximum Calculated Columns in a Query 205

Configure the Maximum Order By Clauses 206

Configure the Maximum Number of Rows in a Query 206

Configure the Maximum Number of Records in an Access Table 207

Configure the Maximum Number of Sources in a Query 208

Enable and Disable the Use of Outer Joins 208

Allow or Restrict Non-Remotable Queries 209

Throttle Access Services Memory Utilization 210

Throttle Session Memory Utilization 210

Configure User Sessions 211

Limit Template Sizes 212

22 Visio Graphics Services 213

Configure the Unattended Service Account 214

Create a New Safe Data Provider 214

Display All Safe Data Providers 216

Get a Specific Safe Data Provider 216

Remove a Safe Data Provider 217

Set the Description of a Data Provider 217

Configure Visio Performance Settings 218

23 Word Services 219

Configure the Conversion Processes 220

Configure Conversion Throughput 220

Configure Supported Document Formats for Conversion 222

Modify Database Information 223

Modify Job Monitoring 224

Modify Conversion Timeouts 225

Modify the Maximum Conversion Attempts 225

Modify the Maximum Memory Usage 226

Disable Word 97–2003 Document Scanning 226

Disable Embedded Fonts in Conversions 227

Modify the Recycle Threshold 228

Part V: Appendices

A stsadm vs SharePoint PowerShell 231

B Upgrade/Migration 237

Index 239

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)