PowerShell for SharePoint 2010

Need fast, reliable, easy-to-implement solutions for automating SharePoint 2010 administration with PowerShell? This book delivers exactly what you

List 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
 

About the author

STEVE MANN is Professor in the Department of Electrical Engineering and Computer Engineering at the University of Toronto.

Summary

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

Product details

• Authors: Steve Mann, Steven Mann
• Publisher: Sams
• Languages: English
• Product format: Paperback / Softback
• Released: 31.12.2011
• EAN: 9780672335594
• ISBN: 978-0-672-33559-4
• No. of pages: 272
• Dimensions: 155 mm x 228 mm x 15 mm
• Weight: 368 g
• Illustrations: w. ill.
• Series: Sams; How to...; How-To (Sams); Sams; How-To
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > Data communication, networks