Advanced Windows PowerShell Scripting Video Training

Advanced Windows PowerShell Scripting Video Training
Advanced Windows PowerShell Scripting Video Training

Friday, July 15, 2016

Building Your PowerShell Test Environment

Very often I get asked the question  "How can I build my own test environment?"  I get this a lot because I advocate testing all of your code in a test environment before running it in production.  The problem is that many IT Pros do not know how to build one.  Well, I’ve got the instructions for you.

Head on over to my Advanced Windows PowerShell Scripting training with O`Reilly (  The “free” lessons cover how to build a test environment including the installation of Hyper-V, building virtual machines, and the creation of a domain.  Yes, all of that is in the free content.


Tuesday, July 12, 2016

What is the Difference between $PSItem and $PSItem.Something?

Diversity is a wonderful thing.  So many different experiences leads us to look at the same thing in so many different ways.  I just had a simple, yet really good question in my PowerShell class.
“What is the difference between $PSItem and $PSItem.something?”

Good question.  We are currently studying the PowerShell Pipeline.  As a result, we are looking at $_ and $PSItem.  These two automatic variables represent the current object in the PowerShell pipeline.  If you look at the PowerShell help file About_Automatic_Variables you will see this:
       Same as $PSItem. Contains the current object in the pipeline object.
       You can use this variable in commands that perform an action on every
       object or on selected objects in a pipeline.

I tend to use $_ because it is shorter and most of my content needs to fit nicely in a book or in a blog post.  Let’s look at an object that we will place in the PowerShell pipeline.
PS Variable:\> Get-Date | Get-Member -MemberType Properties

   TypeName: System.DateTime

Name        MemberType     Definition                                                                 ----        ----------     ----------                                                               DisplayHint NoteProperty   DisplayHintType DisplayHint=DateTime                                     Date        Property       datetime Date {get;}                                                       Day         Property       int Day {get;}                                                           DayOfWeek   Property       System.DayOfWeek DayOfWeek {get;}                                         DayOfYear   Property       int DayOfYear {get;}                                                     Hour        Property       int Hour {get;}                                                           Kind        Property       System.DateTimeKind Kind {get;}                                           Millisecond Property       int Millisecond {get;}                                                   Minute      Property       int Minute {get;}                                                         Month       Property       int Month {get;}                                                         Second      Property       int Second {get;}                                                         Ticks       Property       long Ticks {get;}                                                         TimeOfDay   Property       timespan TimeOfDay {get;}                                                 Year        Property       int Year {get;}                                                           DateTime    ScriptProperty System.Object DateTime {get=if ((& { Set-StrictMode -Version 1; $this.DisplayHint }) -ieq  "Date")...    

This object has several members.  This first example will show you the results of using just $PSItem
PS C:\> Get-Date | ForEach-Object { $PSItem }

Tuesday, July 12, 2016 1:15:22 PM

This second example will show you the result of using $PSItem.DayOfYear
PS C:\> Get-Date | ForEach-Object { $PSItem.DayOfYear }

This third example involves a method of the object.
PS Variable:\> Get-Date | ForEach-Object { $PSItem.AddDays(10) }

Friday, July 22, 2016 2:59:56 PM

See the difference?  When you reference $PSItem, you are referencing the entire object.  When you add the name of a property or the name of a method of the object to $PSItem, you are asking for the value of that property or for that method to execute.

Monday, July 11, 2016

Use SAPIEN PowerShell Studio to protect your Nintendo Stock Gains

Thanks to a lot of press, Pok√©mon Go raised Nintendo’s stock price by over 30% Today.  Unfortunately, you may not be able to set a stop loss on it to protect those gains because it is traded on a foreign stock market.  In this post, we will use SAPIEN PowerShell Studio 2016 to create a small GUI to alert us should the stock fall below a specified price.

First off, create a New Form Project.

Next you will need to create a form using 3 labels and 2 text boxes. Set the name of the first text box to Textbox_Symbol and the second to Textbox_Low  for the fourth label, set the name to Label_Price.  The names of the other form controls do not matter for this exercise.

Pre-populate the value of Symbol with NTDOY.  Also pre-populate the value of Low with your selling price.

Also add a Timer control and leave the default settings.

In the script tab, replace the code with what is below.
  $timer1.Interval = 5000

       # Set the refresh for 5 minutes.
       $timer1.Interval = 300000
       function Get-StockInfo
              $Sym = $textbox_Symbol.Text
              $URL = "$Sym&f=snl1ghjk"
              $Obj = New-Object -TypeName PSObject -Property @{
                     Ask = $Null
                     DayLow = $Null
                     DayHigh = $Null
                     YearLow = $Null
                     YearHigh = $Null
              $Data = Invoke-RestMethod -Uri $URL
              $Data = $Data.Replace("N/A", "NA")
              $Obj.Ask = ($Data.Split(","))[2]
              $Obj.DayLow = ($Data.Split(","))[3]
              $Obj.DayHigh = ($Data.Split(","))[4]
              $Obj.YearLow = ($Data.Split(","))[5]
              $Obj.YearHigh = ($Data.Split(","))[6]
              $label_Price.Text = $Obj.Ask
              If ($Obj.ask -gt $textbox_Low.text) {$label_Price.BackColor = 'Green'}
              Else { $label_Price.BackColor = 'Red'}
       } # END: function Get-StockInfo
}#end timer1_Tick

Here is the end result.

Not much, but if the price drops below $27.00, the price turns red.  This is just a basic example of how to create a GUI with SAPIEN PowerShell Studio 2016.  I encourage you to download the trial edition. You can down load it from here:

Remember that this is an alert from data that is about 10 to 20 minutes old.  You will also have to trigger the sell manually.  This is just a demo to show you the possibilities of using SAPIEN PowerShell Studio 2016 and not an actual stock trading tool.