Table of Contents

Introduction   1

Overview of This Book   1

How to Benefit from This Book   1

How to Continue Expanding Your Knowledge   2

1 SharePoint 2013 Management Shell   3

How Do I Run PowerShell?   4

How Do I Make PowerShell Aware of SharePoint?   5

What Is the SharePoint 2013 Management Shell?   5

What Is the SharePoint 2013 Management Shell Loading?   6

2 PowerShell Basics   9

What Is a Cmdlet?   10

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

What Is a Parameter?   10

What Is a Switch Parameter?   10

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

What Does F3 Do?   11

What Does F7 Do?   11

What Are Console Commands?   12

Path Environment Variable   13

Running Unsigned Scripts   13

Disabling the Confirmation Prompt   14

Generating Inline Credentials   14

Referencing an Assembly   15

3 SharePoint Installation and Configuration   17

Prepare the Microsoft SharePoint Installation Module   18

Install SharePoint Unattended   19

Install Without a Product Key in the Configuration File   20

Configure a New SharePoint Farm    21

Join a Server to the SharePoint Farm   22

Create a New Web Application   22

Create a New Site Collection   23

Create a New Subsite   24

4 Farm Management   27

Review Farm Configuration Values   28

Set the Farm Configuration Values   28

Refresh Installed Products   30

Change the Port of Central Admin   30

Change the Farm Passphrase   30

Retrieve the System Accounts   31

Retrieve Managed Accounts   32

Rename a Server on the Farm   32

Display the Configured Managed Paths   33

Create a New Managed Path   34

Remove a Managed Path   34

Merge Log Files   35

End the Current Log File   36

Review SharePoint Designer Settings   36

Configure SharePoint Designer Settings   37

Review Workflow Configuration Settings 38

Modify Workflow Configuration Settings   39

Display Available Timer Jobs on the Farm   40

Get a Specific Timer Job   41

Enable a Timer Job   41

Disable a Timer Job   42

Start a Timer Job   42

Set the Schedule for a Timer Job 43

5 Web Application Management  45

Display Available Web Applications on the Farm   46

Get a Specific Web Application   46

Remove a Web Application   47

Create a New Web Application   48

Configure Web Application Settings   48

Extend a Web Application   49

Create an Alternate Access-Mapping URL   50

Display All Alternate Access Mappings   51

Get a Specific Alternate URL Entry   51

Change the Zone of an Alternate Access Mapping   51

Remove an Alternate Access Mapping   52

6 Service Application Management  53

Install Service Applications   54

Display Available Service Applications on the Farm   54

Get a Specific Service Application   55

Configure IIS Settings for a Service Application   55

Share a Service Application   57

Remove a Service Application   57

Display Service Instances on a Server   57

Get a Specific Service Instance   58

Start a Service Instance   59

Stop a Service Instance   59

Ancillary Cmdlets for Service Applications   60

7 SharePoint Database Management  61

Display All SharePoint Databases   62

Get a Specific Database   63

Create a New Content Database    63

Display All Content Databases for a Web Application   64

Detach a Content Database from a Web Application   65

Attach a Content Database to a Web Application   65

Delete a Content Database   66

Create a New Configuration Database    66

Delete a Configuration Database   67

Back Up a Configuration Database   67

Restore a Configuration Database   68

Back Up the SharePoint Farm   69

Restore the SharePoint Farm   69

Back Up a Site Collection   70

Restore a Site Collection   70

8 Site Management  71

Display All Available Site Collections on the Farm   72

Display Available Site Collections in a Web Application   72

Display Available Site Collections in a Content Database   73

Get a Specific Site Collection   73

Remove a Site Collection   74

Create a Site Collection   74

Set the Lock State of a Site Collection   75

Set the Storage Limits on a Site Collection   76

Create a Site Under a Site Collection   76

Display All Subsites Within a Site Collection   77

Get a Specific Subsite (Web)    78

Remove a Subsite (Web) from a Site Collection   78

Modify the Subsite (Web) URL   79

Move a Site Collection to a Different Content Database   79

Move All Site Collections from One Content Database to Another   80

Display All Deleted Site Collections   80

Display Deleted Site Collections in a Content Database   81

Get a Specific Deleted Site Collection   81

Remove a Deleted Site Collection   82

Restore a Deleted Site Collection   82

Configure Information Rights Management (IRM) Settings   83

9 Solutions and Features  85

Add a Solution to the SharePoint Farm   86

Display Available Solutions on the Farm   86

Get a Specific Solution   87

Deploy a Solution to a Web Application   87

Retract a Solution   88

Upgrade a Deployed Solution   89

Remove a Solution from the SharePoint Farm   90

Add a Sandboxed Solution to a Site Collection   90

Display Available Sandboxed Solutions in a Site Collection   91

Get a Specific Sandboxed Solution   91

Activate a Sandboxed Solution   91

Deactivate a Sandboxed Solution  92

Upgrade a Deployed Sandboxed Solution   92

Remove a Sandboxed Solution from a Site Collection   93

Display Available Features   93

Get a Specific Feature   94

Activate a Feature   95

Deactivate a Feature   95

Install a Feature in SharePoint   96

Uninstall a Feature from SharePoint   97

Export Installed Farm Solutions   97

10 Content Deployment  99

Create a New Deployment Path 100

Display Deployment Paths Configured on the Farm 100

Get a Specific Content Deployment Path 101

Remove a Content Deployment Path 101

Create a New Deployment Job 102

Display Deployment Jobs Configured on the Farm 102

Get a Specific Content Deployment Job 103

Remove a Content Deployment Job 103

Start a Content Deployment Job   103

Modify Content Deployment Configurations 104

11 User Licensing  105

Display User Licensing Status   106

Enable User Licensing Enforcement   106

Disable User Licensing Enforcement   107

Display Available User Licenses   107

Create a New License Mapping   108

Add a New License Mapping   108

Display All License Mappings   109

Remove a License Mapping 110

12 InfoPath Forms Services  111

Browser-Enabled Form Templates   112

Throttle Data Connection Timeouts   112

Throttle the Data Connection Response Size   113

Modify Authentication Settings   113

Configure Session State   114

Enable View State   115

Verify and Upload a Form Template   116

Upload Multiple Form Templates at Once   116

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

Remove a Form from InfoPath Form Services    117

Quiesce a Form from InfoPath Form Services   118

Enable the Web Service Proxy   118

Export Forms Services Administration Files   119

Import Forms Services Administration Files 120

13 Enterprise Search  121

Display the Enterprise Search Service Information   122

Display Enterprise Search Service Instances   122

Get a Specific Enterprise Search Service Instance   123

Configure the Crawl Account for Enterprise Search 124

Configure the Enterprise Search Service Performance Level   124

Display Enterprise Search Service Applications   125

Get a Specific Enterprise Search Service Application   126

Create a Custom Metadata Category   126

Display Available Metadata Categories   127

Get a Specific Metadata Category   127

Create a Custom Metadata Crawled Property   128

Display Available Crawled Properties   129

Get a Specific Metadata Crawled Property   130

Create a Custom Metadata-Managed Property   130

Display Available Managed Properties   131

Get a Specific Metadata-Managed Property   132

Create a Metadata Mapping   133

Use Advanced Cmdlets for Search   133

14 Profile Service  135

Get the Identity of the Profile Service Application   136

Get a Specific Profile Service Application Instance   136

Configure Settings on the Profile Service Application   137

Remove Old Comments   137

Remove Old Ratings   138

Remove Old Tags   138

Update the Profile Photo Store   139

Refresh the Feed Cache   139

Refresh a Specific User’s Feed Cache   140

Use Advanced Cmdlets for the Profile Service   140

15 Business Data Connectivity Service  143

Get the Identity of the BCS Service Application   144

Get a Specific BCS Service Application Instance   144

Configure the BCS Database   145

Get a BCS Metadata Object   145

Import a BCS Model   146

Export a BCS Model   147

Set the Entity Notification Web   147

Get the Entity Notification Web   148

Create an OData Connection   148

Get an OData Connection 149

Update an OData Connection   150

16 Secure Store Service  153

Get the Identity of the Secure Store Service Application   154

Get a Specific Secure Store Service Application Instance   154

Enable Auditing for the Secure Store Service   155

Configure the Secure Store Database   155

Generate a New Master Key   156

Refresh the Encryption Key   157

Create Application Fields   157

Create a Target Application   159

Create a New Application Entry   159

17 Metadata Service  161

Get the Identity of the Metadata Service Application   162

Get a Specific Metadata Service Application Instance   162

Configure the Metadata Service Accounts   163

Configure the Term Store Database   163

Configure the Content Type Hub   164

Get the Identity of the Metadata Service Application Proxy   164

Get a Specific Metadata Service Application Proxy Instance   165

Configure the Metadata Service Connection Options   166

18 Session State and State Service  169

Enable Session State   170

Disable Session State   170

Display Session State Information   171

Configure the Timeout of the Session State   172

Display State Service Applications Configured on the Farm   173

Get a Specific State Service Application   173

Rename a State Service Application   174

Perform State Service Database Operations   174

19 Work Management Service  177

Get the Identity of the Work Management Service Application   178

Get a Specific Work Management Service Application Instance   178

Configure the Refresh Threshold   179

Configure the Search Query Threshold   179

Configure the User Synchronization Per Server   180

Get the Identity of the Work Management Service Application Proxy   181

Get a Specific Work Management Service Application Proxy Instance   181

20 Machine Translation Service  183

Get the Identity of the Machine Translation Service Application   184

Get a Specific Machine Translation Service Application Instance   184

Get the Identity of the Machine Translation Service Proxy   185

Get a Specific Machine Translation Service Application Proxy Instance   185

Configure the Translation Processes   186

Configure Translations Throughput   186

Configure Enabled Document File Extensions for Translation   188

Modify Database Information   189

Modify Translation Timeouts   190

Modify the Maximum Translation Attempts   191

Modify the Recycle Threshold   191

21 Excel Services  193

Create a Trusted File Location   194

Display All Trusted File Locations   195

Get a Specific Trusted File Location   196

Remove a Trusted File Location   197

Create a Trusted Data Connection Library   197

Display All Trusted Data Connection Libraries   198

Get a Specific Trusted Data Connection Library   199

Remove a Trusted Data Connection Library   199

Create a New Safe Data Provider   200

Display All Safe Data Providers   201

Get a Specific Safe Data Provider   201

Remove a Safe Data Provider   202

Create a Blocked File Type   202

Display All Blocked File Types   203

Get a Specific Blocked File Type   203

Remove a Blocked File Type   204

Create a User-Defined Function Reference   204

Display All User-Defined Function References   205

Get a Specific User-Defined Function Reference     206

Remove a User-Defined Function Reference   206

Modify Excel Services Objects   207

22 PerformancePoint Services  209

Configure the Unattended Service Account   210

Display the Unattended Service Account   210

Create a Trusted Content Location   211

Create a Trusted Data Source Location   212

Display All Trusted Content Locations   212

Display All Trusted DataSource Locations   213

Display Details of Trusted Locations   213

Get a Specific Trusted Location   214

Remove a Trusted Location   214

Configure PerformancePoint Services to Enforce Trusted Locations   215

Configure PerformancePoint Services Application Settings   216

23 Access Services  217

Configure the Application Log Size   218

Configure the Cache Timeout 218

Modify the Maximum Columns in a Query   219

Modify the Maximum Calculated Columns in a Query   219

Configure the Maximum Order By Clauses   220

Configure the Maximum Number of Rows in a Query   220

Configure the Maximum Number of Records in an Access Table   221

Configure the Maximum Number of Sources in a Query   222

Enable and Disable the Use of Outer Joins   222

Allow or Restrict Nonremotable Queries   223

Throttle Access Services Memory Utilization   224

Throttle Session Memory Utilization   224

Configure User Sessions   225

Limit Template Sizes   225

Modify Access Services Databases    226

24 Visio Graphics Services  227

Configure the Unattended Service Account   228

Create a New Safe Data Provider   228

Display All Safe Data Providers   229

Get a Specific Safe Data Provider   230

Remove a Safe Data Provider   230

Setting the Description of a Data Provider   231

Configuring Visio Performance Settings   231

25 Word Automation Services  233

Configure the Conversion Processes   234

Configure Conversion Throughput   234

Configure Supported Document Formats for Conversion   236

Modify Database Information   237

Modify Job Monitoring   238

Modify Conversion Timeouts   239

Modify the Maximum Conversion Attempts   239

Modify the Maximum Memory Usage   240

Disable Word 97–2003 Document Scanning   240

Disable Embedded Fonts in Conversions   241

Modify the Recycle Threshold   242

26 Office Web Apps  243

Create a New WOPI Binding in SharePoint  244

Review Current SharePoint WOPI Bindings   245

Configure the Default Action for an Application   245

Remove WOPI Bindings from SharePoint   246

Configure the WOPI SharePoint Zone   247

Disable Certain WOPI Actions   247

Resolve Invalid Proof Signature   248

A stsadm Versus SharePoint PowerShell  249

A Operations   249

B Operations   250

C Operations   250

D Operations   250

E Operations   251

G Operations   251

I Operations   252

L Operations   252

M Operations   252

O, P, and Q Operations   252

R Operations   252

S Operations   253

U Operations   254

V Operations    254

B Upgrade and Migration  255

Test-SPContentDatabase   255

Upgrade-SPContentDatabase   255

Upgrade-SPFarm   256

Test-SPSite   256

Repair-SPSite   256

Upgrade-SPSite   256

Additional Upgrade Cmdlets   256

C Enterprise Search Reference  259

Administrative   259

Crawling   259

Metadata   260

Miscellaneous   261

Querying   262

Service Application   263

Topology   264

D App Management Service Reference  265

App Settings and Configuration   265

Denied Endpoint Management   266

Installation and Provisioning of Apps   266

Marketplace Management   266

Service Application   267

Index  269

About the Author

Steven 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 19 years of professional experience.

Steven has authored and coauthored several books related to the subject of SharePoint Server, PowerShell, Managed Metadata, and Business Intelligence.