Foreword Ed Wilson “The Scripting Guy” iii

Acknowledgements v

From Dave v

About the Authors vi

Dave Kawula - MVP vi

Sean Kearney - MVP vii

Thomas Rayner - MVP vii

Allan Rafuse – MVP viii

Will Anderson – MVP ix

Mick Pletcher – MVP x

Ed Wilson – The Scripting Guy xi

Technical Editors xii

Cristal Kawula – MVP xii

Emile Cabot - MVP xii

Kai Poynting xiii

Contents xiv

Introduction 1

North American MVPDays Community Roadshow 1

Structure of the Book 2

Sample Files 3

Additional Resources 3

Chapter 1 5

PowerShell Regex to Get Value Between Quotation Marks 5

Chapter 2 7

How to Send an Email Whenever a File Gets Changed 7

Chapter 3 8

Using PowerShell to Add Groups to Accept messages only Distribution list members 8

The Code 9

Chapter 4 10

Installing and Finding Modules 10

Why use Install-Modules 10

Module Dependencies 10

Repositories 11

Managing Repositories 11

Finding Modules in the Repositories 11

Installing a Module 13

Proxy Configuration 14

Summary 14

Chapter 5 15

Use PowerShell to Validate Parameters for you 15

Common PowerShell Functions – NO Validation 16

PowerShell Features for Parameters 16

Problem 1 16

Problem 2 17

Problem 3 17

Solution 18

Other Parameter Validation Features 18

Chapter 6 19

PowerShell – My Way to Prepare a SQL Server VM 19

Template File 20

A look at library-PrepareSQLServer.ps1 21

Running the script 23

Chapter 7 25

Building Gold VHDx images with PowerShell 25

Define the Variables 26

Build $unnatendSource 26

Get-UnattendChunk 27

New-Unattendfile 28

New-BaseImage 29

Chapter 8 32

Using Try Catch to help with Decision Making in a Script 32

Chapter 9 36

Invoking your SCCM Client Remotely with PowerShell 36

Chapter 10 38

Use PoweShell to Parse RSS Feeds 38

Chapter 11 44

How to alter the public IP Address of an Azure Virtual Machine using PowerShell 44

The Challenge 44

Data formatting or using an existing example 44

Make the change 46

Chapter 12 48

Get the Public IP of an Azure VM with PowerShell 48

Chapter 13 49

SCCM Local Administrator Reporting with PowerShell 49

LocalAdmins.ps1 53

Chapter 14 58

Configuring Power Settings using PowerShell 58

Set-PowerScheme.ps1 58

Chapter 15 73

Automated SCCM Endpoint Full System Scan upon Infection with Email Notification 73

ApplicationVirusDetectionMethodEmail.ps1 75

AntiVirusScanEmail.ps1 76

Chapter 16 79

Laptop Mandatory Reboot Management with SCCM and PowerShell 79

MandatoryReboot.ps1 80

MandatoryRebootCustomDetection.ps1 82

Chapter 17 84

Set Windows Features with Verification 84

WindowsFeatures.ps1 85

Chapter 18 90

Easily Restore a Deleted Active Directory User with PowerShell 90

Chapter 19 91

Getting Large Exchange Mailbox Folders with PowerShell 91

Chapter 20 95

Getting your Organizations Largest Exchange Mailboxes with PowerShell 95

Chapter 21 99

Just Enough Administration (JEA) First Look 99

So how do you get started? 99

Chapter 22 105

Does a String Start or End in a Certain Character? 105

Chapter 23 107

Using PowerShell to List All the Fonts in a Word Document 107

Chapter 24 109

Find PowerShell Scripts in the GUI 109

Chapter 25 116

How to use PowerShell as an Administrative Console 116

Chapter 26 118

How to Erase Files based on Date using PowerShell 118

Chapter 27 121

Join us at MVPDays and meet great MVP’s like this in person 121

Live Presentations 121

Video Training 121

Live Instructor-led Classes 121

Consulting Services 122

Twitter 123