Book Image

Learn PowerShell Core 6.0

By : David das Neves, Jan-Hendrik Peters
Book Image

Learn PowerShell Core 6.0

By: David das Neves, Jan-Hendrik Peters

Overview of this book

Beginning with an overview of the different versions of PowerShell, Learn PowerShell Core 6.0 introduces you to VSCode and then dives into helping you understand the basic techniques in PowerShell scripting. You will cover advanced coding techniques, learn how to write reusable code as well as store and load data with PowerShell. This book will help you understand PowerShell security and Just Enough Administration, enabling you to create your own PowerShell repository. The last set of chapters will guide you in setting up, configuring, and working with Release Pipelines in VSCode and VSTS, and help you understand PowerShell DSC. In addition to this, you will learn how to use PowerShell with Windows, Azure, Microsoft Online Services, SCCM, and SQL Server. The final chapter will provide you with some use cases and pro tips. By the end of this book, you will be able to create professional reusable code using security insight and knowledge of working with PowerShell Core 6.0 and its most important capabilities.
Table of Contents (26 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

ETL parsing


For feature updates, it may become necessary to investigate *.etl files. The following code shows how to retrieve and work with these kinds of files and also filter the data to find the important information. We again make use of the Get-WinEventcmdlet, and after loading the file with this cmdlet, the usage should again look very familiar to you:

#Defining the etl file
$etlFile = 'C:\Windows\Panther\setup.etl'

#Retrieving the content
$log = Get-WinEvent -Path $etlFile –Oldest

#Finding the ProviderName
$ProviderNames = $log | Select-Object Providername -Unique -ExpandProperty ProviderName

#Filtering 
$log.Where{$_.Providername -eq$($ProviderNames[1])}
$log | Where-Object {$_.ProviderName -eq"$($ProviderNames[0])"} | Select-Object -First 10
$log | Where-Object {$_.ProviderName -eq'Microsoft-Windows-Services'} 

#Exporting the log data
$log | Export-Csv c:\temp\etltest.csv -Delimiter ';'
$log | Export-Csv -Delimiter ';' -PipelineVariable $logcsvnew 

#Importing the log data
$logcsv...