Powershell GUI - Adding bells & whistles

In my previous post “Gettingyour feet wet with Powershell GUI” I had mentioned how difficult it was get a concise documentation on creating Powershell GUI. To my surprise I discovered that there is a real cool tool developed by Sapien Technologies that allows you to create a Powershell GUI. They have a free Powershell Form creator – Primal Forms Community Creator” which enables you to create a nifty GUI. I was able to create a neat Form and then fill in the details of actually manipulating the controls I added. For details about the controls of a textBox, comboBox etc in Powershell refer to the MSDN library. This was the Powershell GUI I had created.

 #########################################################################################################

# Developed by Tinniam V Ganesh 

# Date 24 Apr 2012

# Powershell GUI generated by Primal Forms CE from Sapien Technologies (http://www.sapien.com/)

#########################################################################################################

function Get-SysInfo ($strComputer)

{ 

    write-host "reached here"

    $statusBar1.Text ="Working ..."   

    if ($radiobutton1.checked -eq $True)

    {

       $wmi = Get-WmiObject Win32_ComputerSystem -Namespace “root\CIMV2" -ComputerName $strComputer|Export-csv -force "test.csv"

    }

    else

    {

       $wmi =Get-WmiObject Win32_ComputerSystem -Namespace “root\CIMV2" -ComputerName $strComputer|ConvertTo-Html|out-file -append "test.html"

    }

    $statusBar1.Text ="Done." 

} 

#*=============================================================================

Function Get-BIOSInfo ($strComputer)

{

    $statusBar1.Text ="Working ..." 

    if ($radiobutton1.checked -eq $True)

    {

       $wmi = Get-WmiObject Win32_BIOS -Namespace “root\CIMV2" -computername $strComputer|Export-csv  -force "test.csv"

    }

    else

    {

       $wmi = Get-WmiObject Win32_BIOS -Namespace “root\CIMV2" -computername $strComputer|ConvertTo-Html|out-file -append "test.html"

    }

    $statusBar1.Text ="Done." 

}

Function Get-OSInfo {

    $statusBar1.Text ="Working ..." 

    if ($radiobutton1.checked -eq $True)

    {

       $wmi = Get-WmiObject Win32_OperatingSystem -Namespace “root\CIMV2" -Computername $strComputer|Export-csv -force "test.csv"

    }

    else

    {

       $wmi = Get-WmiObject Win32_OperatingSystem -Namespace “root\CIMV2" -Computername $strComputer|out-file -append "test.html"

    }

    $statusBar1.Text ="Done." 

}

Function Get-CPUInfo {

    $statusBar1.Text ="Working ..." 

    if ($radiobutton1.checked -eq $True)

    {

       $wmi = Get-WmiObject Win32_Processor -Namespace “root\CIMV2" -Computername $strComputer|Export-csv -force "test.csv"

    }

    else

    {

       $wmi = Get-WmiObject Win32_Processor -Namespace “root\CIMV2" -Computername $strComputer|out-file -append "test.html"

    }

    $statusBar1.Text ="Done."

}

Function Get-DiskInfo {

    $statusBar1.Text ="Working ..." 

    if ($radiobutton1.checked -eq $True)

    {

       $wmi = Get-WmiObject Win32_DiskDrive -Namespace “root\CIMV2" -ComputerName $strComputer|Export-csv -force "test.csv"

    }

    else

    {

       $wmi = Get-WmiObject Win32_DiskDrive -Namespace “root\CIMV2" -ComputerName $strComputer|out-file -append "test.html"

    }

    $statusBar1.Text ="Done."

}

Function Get-NetworkInfo {

    $statusBar1.Text ="Working ..." 

    if ($radiobutton1.checked -eq $True)

    {

       $wmi = Get-WmiObject Win32_NetworkAdapterConfiguration -Namespace “root\CIMV2" -ComputerName $strComputer | where{$_.IPEnabled -eq “True”}|Export-csv -noclobber "test.csv"

    }

    else

    {

       $wmi = Get-WmiObject Win32_NetworkAdapterConfiguration -Namespace “root\CIMV2" -ComputerName $strComputer | where{$_.IPEnabled -eq “True”}|out-file -append "test.html"

    }

    $statusBar1.Text ="Done."

}

#Generated Form Function

function GenerateForm {

########################################################################

# Code Generated By: SAPIEN Technologies PrimalForms (Community Edition) v1.0.10.0

# Generated On: 4/24/2012 2:46 PM

# Generated By: tvganesh

########################################################################

#region Import the Assemblies

[reflection.assembly]::loadwithpartialname("System.Windows.Forms") | Out-Null

[reflection.assembly]::loadwithpartialname("System.Drawing") | Out-Null

#endregion

#region Generated Form Objects

$form1 = New-Object System.Windows.Forms.Form

$statusBar1 = New-Object System.Windows.Forms.StatusBar

$label2 = New-Object System.Windows.Forms.Label

$button3 = New-Object System.Windows.Forms.Button

$button2 = New-Object System.Windows.Forms.Button

$tabControl1 = New-Object System.Windows.Forms.TabControl

$tabControl = New-Object System.Windows.Forms.TabPage

$groupBox1 = New-Object System.Windows.Forms.GroupBox

$radioButton2 = New-Object System.Windows.Forms.RadioButton

$radioButton1 = New-Object System.Windows.Forms.RadioButton

$label1 = New-Object System.Windows.Forms.Label

$textBox1 = New-Object System.Windows.Forms.TextBox

$comboBox1 = New-Object System.Windows.Forms.ComboBox

$Database = New-Object System.Windows.Forms.TabPage

$tabPage1 = New-Object System.Windows.Forms.TabPage

$tabPage2 = New-Object System.Windows.Forms.TabPage

$button1 = New-Object System.Windows.Forms.Button

$fontDialog1 = New-Object System.Windows.Forms.FontDialog

$InitialFormWindowState = New-Object System.Windows.Forms.FormWindowState

#endregion Generated Form Objects

#----------------------------------------------

#Generated Event Script Blocks

#----------------------------------------------

#Provide Custom Code for events specified in PrimalForms.

$button3_OnClick= 

{

$form1.Close() 

}

$button2_OnClick= 

{

  $textBox1.text=""

  # Set to the first item

  $comboBox1.SelectedIndex = 0;

}

$handler_button1_Click= 

{

$x = $textbox1.text

$vals = $x.split(",")

forEach($strComputer in $vals)

{

      switch($combobox1.selectedItem)

      {

         "SysInfo" {Get-SysInfo ($strComputer)}

"BiosInfo" {Get-BiosInfo($strComputer)}

"CPUInfo" {Get-cpuInfo($strComputer)}

"DiskInfo" {Get-diskInfo($strComputer)}

"OSInfo" {Get-OSInfo($strCOmputer)}

"NetworkInfo" {Get-NetworkInfo($strComputer)}

     }

}

}

$OnLoadForm_StateCorrection=

{#Correct the initial state of the form to prevent the .Net maximized form issue

$form1.WindowState = $InitialFormWindowState

}

#----------------------------------------------

#region Generated Form Code

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 444

$System_Drawing_Size.Width = 704

$form1.ClientSize = $System_Drawing_Size

$form1.DataBindings.DefaultDataSourceUpdateMode = 0

$form1.Name = "form1"

$form1.Text = "Primal Form"

$statusBar1.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 0

$System_Drawing_Point.Y = 422

$statusBar1.Location = $System_Drawing_Point

$statusBar1.Name = "statusBar1"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 22

$System_Drawing_Size.Width = 704

$statusBar1.Size = $System_Drawing_Size

$statusBar1.TabIndex = 8

$statusBar1.Text = "Ready"

$form1.Controls.Add($statusBar1)

$label2.DataBindings.DefaultDataSourceUpdateMode = 0

$label2.Font = New-Object System.Drawing.Font("Microsoft Sans Serif",14.25,1,3,1)

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 205

$System_Drawing_Point.Y = 22

$label2.Location = $System_Drawing_Point

$label2.Name = "label2"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 34

$System_Drawing_Size.Width = 341

$label2.Size = $System_Drawing_Size

$label2.TabIndex = 7

$label2.Text = "Windows Resource Management"

$form1.Controls.Add($label2)

$button3.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 439

$System_Drawing_Point.Y = 343

$button3.Location = $System_Drawing_Point

$button3.Name = "button3"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 23

$System_Drawing_Size.Width = 75

$button3.Size = $System_Drawing_Size

$button3.TabIndex = 6

$button3.Text = "Exit"

$button3.UseVisualStyleBackColor = $True

$button3.add_Click($button3_OnClick)

$form1.Controls.Add($button3)

$button2.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 330

$System_Drawing_Point.Y = 343

$button2.Location = $System_Drawing_Point

$button2.Name = "button2"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 23

$System_Drawing_Size.Width = 75

$button2.Size = $System_Drawing_Size

$button2.TabIndex = 5

$button2.Text = "Cancel"

$button2.UseVisualStyleBackColor = $True

$button2.add_Click($button2_OnClick)

$form1.Controls.Add($button2)

$tabControl1.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 136

$System_Drawing_Point.Y = 83

$tabControl1.Location = $System_Drawing_Point

$tabControl1.Name = "tabControl1"

$tabControl1.SelectedIndex = 0

$tabControl1.ShowToolTips = $True

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 231

$System_Drawing_Size.Width = 453

$tabControl1.Size = $System_Drawing_Size

$tabControl1.TabIndex = 4

$form1.Controls.Add($tabControl1)

$tabControl.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 4

$System_Drawing_Point.Y = 22

$tabControl.Location = $System_Drawing_Point

$tabControl.Name = "tabControl"

$System_Windows_Forms_Padding = New-Object System.Windows.Forms.Padding

$System_Windows_Forms_Padding.All = 3

$System_Windows_Forms_Padding.Bottom = 3

$System_Windows_Forms_Padding.Left = 3

$System_Windows_Forms_Padding.Right = 3

$System_Windows_Forms_Padding.Top = 3

$tabControl.Padding = $System_Windows_Forms_Padding

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 205

$System_Drawing_Size.Width = 445

$tabControl.Size = $System_Drawing_Size

$tabControl.TabIndex = 0

$tabControl.Text = "Basic Commands"

$tabControl.UseVisualStyleBackColor = $True

$tabControl1.Controls.Add($tabControl)

$groupBox1.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 271

$System_Drawing_Point.Y = 123

$groupBox1.Location = $System_Drawing_Point

$groupBox1.Name = "groupBox1"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 49

$System_Drawing_Size.Width = 124

$groupBox1.Size = $System_Drawing_Size

$groupBox1.TabIndex = 3

$groupBox1.TabStop = $False

$groupBox1.Text = "Save As"

$tabControl.Controls.Add($groupBox1)

$radioButton2.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 48

$System_Drawing_Point.Y = 19

$radioButton2.Location = $System_Drawing_Point

$radioButton2.Name = "radioButton2"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 24

$System_Drawing_Size.Width = 104

$radioButton2.Size = $System_Drawing_Size

$radioButton2.TabIndex = 1

$radioButton2.TabStop = $True

$radioButton2.Text = "HTML"

$radioButton2.UseVisualStyleBackColor = $True

$groupBox1.Controls.Add($radioButton2)

$radioButton1.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 6

$System_Drawing_Point.Y = 19

$radioButton1.Location = $System_Drawing_Point

$radioButton1.Name = "radioButton1"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 24

$System_Drawing_Size.Width = 104

$radioButton1.Size = $System_Drawing_Size

$radioButton1.TabIndex = 0

$radioButton1.TabStop = $True

$radioButton1.Text = "CSV"

$radioButton1.UseVisualStyleBackColor = $True

$radioButton1.checked =$True

$groupBox1.Controls.Add($radioButton1)

$label1.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 6

$System_Drawing_Point.Y = 26

$label1.Location = $System_Drawing_Point

$label1.Name = "label1"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 20

$System_Drawing_Size.Width = 192

$label1.Size = $System_Drawing_Size

$label1.TabIndex = 2

$label1.Text = "Enter comma separated server list"

$tabControl.Controls.Add($label1)

$textBox1.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 220

$System_Drawing_Point.Y = 26

$textBox1.Location = $System_Drawing_Point

$textBox1.Name = "textBox1"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 20

$System_Drawing_Size.Width = 203

$textBox1.Size = $System_Drawing_Size

$textBox1.TabIndex = 1

$tabControl.Controls.Add($textBox1)

$comboBox1.DataBindings.DefaultDataSourceUpdateMode = 0

$comboBox1.FormattingEnabled = $True

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 220

$System_Drawing_Point.Y = 79

$comboBox1.Location = $System_Drawing_Point

$comboBox1.Name = "comboBox1"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 21

$System_Drawing_Size.Width = 200

$comboBox1.Size = $System_Drawing_Size

$comboBox1.TabIndex = 0

$commands = @("SysInfo","BIOSInfo","OSInfo","CPUInfo","DiskInfo","NetworkInfo")

ForEach ($command in  $commands){

    $comboBox1.items.add($command)

 }

$tabControl.Controls.Add($comboBox1)

# Set to the first item

$comboBox1.SelectedIndex = 0;

$Database.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 4

$System_Drawing_Point.Y = 22

$Database.Location = $System_Drawing_Point

$Database.Name = "Database"

$System_Windows_Forms_Padding = New-Object System.Windows.Forms.Padding

$System_Windows_Forms_Padding.All = 3

$System_Windows_Forms_Padding.Bottom = 3

$System_Windows_Forms_Padding.Left = 3

$System_Windows_Forms_Padding.Right = 3

$System_Windows_Forms_Padding.Top = 3

$Database.Padding = $System_Windows_Forms_Padding

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 205

$System_Drawing_Size.Width = 445

$Database.Size = $System_Drawing_Size

$Database.TabIndex = 1

$Database.Text = "Database"

$Database.UseVisualStyleBackColor = $True

$tabControl1.Controls.Add($Database)

$tabPage1.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 4

$System_Drawing_Point.Y = 22

$tabPage1.Location = $System_Drawing_Point

$tabPage1.Name = "tabPage1"

$System_Windows_Forms_Padding = New-Object System.Windows.Forms.Padding

$System_Windows_Forms_Padding.All = 3

$System_Windows_Forms_Padding.Bottom = 3

$System_Windows_Forms_Padding.Left = 3

$System_Windows_Forms_Padding.Right = 3

$System_Windows_Forms_Padding.Top = 3

$tabPage1.Padding = $System_Windows_Forms_Padding

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 205

$System_Drawing_Size.Width = 445

$tabPage1.Size = $System_Drawing_Size

$tabPage1.TabIndex = 2

$tabPage1.Text = "Active Directory"

$tabPage1.UseVisualStyleBackColor = $True

$tabControl1.Controls.Add($tabPage1)

$tabPage2.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 4

$System_Drawing_Point.Y = 22

$tabPage2.Location = $System_Drawing_Point

$tabPage2.Name = "tabPage2"

$System_Windows_Forms_Padding = New-Object System.Windows.Forms.Padding

$System_Windows_Forms_Padding.All = 3

$System_Windows_Forms_Padding.Bottom = 3

$System_Windows_Forms_Padding.Left = 3

$System_Windows_Forms_Padding.Right = 3

$System_Windows_Forms_Padding.Top = 3

$tabPage2.Padding = $System_Windows_Forms_Padding

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 205

$System_Drawing_Size.Width = 445

$tabPage2.Size = $System_Drawing_Size

$tabPage2.TabIndex = 3

$tabPage2.Text = "Backup & Restore"

$tabPage2.UseVisualStyleBackColor = $True

$tabControl1.Controls.Add($tabPage2)

$button1.DataBindings.DefaultDataSourceUpdateMode = 0

$System_Drawing_Point = New-Object System.Drawing.Point

$System_Drawing_Point.X = 226

$System_Drawing_Point.Y = 343

$button1.Location = $System_Drawing_Point

$button1.Name = "button1"

$System_Drawing_Size = New-Object System.Drawing.Size

$System_Drawing_Size.Height = 23

$System_Drawing_Size.Width = 75

$button1.Size = $System_Drawing_Size

$button1.TabIndex = 0

$button1.Text = "Submit"

$button1.UseVisualStyleBackColor = $True

$button1.add_Click($handler_button1_Click)

$form1.Controls.Add($button1)

$fontDialog1.ShowHelp = $True

#endregion Generated Form Code

#Save the initial state of the form

$InitialFormWindowState = $form1.WindowState

#Init the OnLoad event to correct the initial state of the form

$form1.add_Load($OnLoadForm_StateCorrection)

#Show the Form

$form1.ShowDialog()| Out-Null

} #End Function

#Call the Function

GenerateForm

Get your feet wet with Powershell GUI

Here’s my latest attempt in creating a simple GUI using Powershell for Windows Resource Management Tasks. Powershell by itself is easy but there is hardly any documentation on the web for creating a cool GUI. You have to put together various bits and pieces by the trial and error method. Anyway I did come up with some success. However there is a lot to be desired. For some reason the results only show up when the GUI is closed through the Cancel or Exit button. Feel free to tweak the code as you please. The Windows Management Commands are some basic scripts taken from Powershell Pro.

This is the GUI that was created

Feel free to send me any comments.

[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Drawing") 

[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms") 

# Add functions

#*=============================================================================

Function BIOSInfo {

$colItems = Get-WmiObject Win32_BIOS -Namespace “root\CIMV2" -computername $strComputer

foreach($objItem in $colItems) {

       "------------------------------ Bios Info ---------------------"

       "Computer Name: "+ $strComputer

       "BIOS Characteristics: "+ $objItem.BiosCharacteristics

       "BIOS Version: "+ $objItem.BIOSVersion

       "Build Number: "+ $objItem.BuildNumber

       "Caption: "+ $objItem.Caption

       "Code Set: "+ $objItem.CodeSet

       "Current Language: "+ $objItem.CurrentLanguage

       "Description: "+ $objItem.Description

       "Identification Code: "+ $objItem.IdentificationCode

       "Installable Languages: "+ $objItem.InstallableLanguages

       "Installation Date: "+ $objItem.InstallDate

       "Language Edition: "+ $objItem.LanguageEdition

       "List Of Languages: "+ $objItem.ListOfLanguages

       "Manufacturer: "+ $objItem.Manufacturer

       "Name: " + $objItem.Name

       "Other Target Operating System: "+ $objItem.OtherTargetOS

       "Primary BIOS: "+ $objItem.PrimaryBIOS

       "Release Date: "+ $objItem.ReleaseDate

       "Serial Number: "+ $objItem.SerialNumber

       "SMBIOS BIOS Version: "+ $objItem.SMBIOSBIOSVersion

       "SMBIOS Major Version: "+ $objItem.SMBIOSMajorVersion

       "SMBIOS Minor Version: "+ $objItem.SMBIOSMinorVersion

       "SMBIOS Present: "+ $objItem.SMBIOSPresent

       "Software Element ID: "+ $objItem.SoftwareElementID

       "Software Element State: "+ $objItem.SoftwareElementState

       "Status: "+ $objItem.Status

       "Target Operating System: "+ $objItem.TargetOperatingSystem

       "Version: "+ $objItem.Version

      

}

}

Function OSInfo {

$colItems = Get-WmiObject Win32_OperatingSystem -Namespace “root\CIMV2" -Computername $strComputer

foreach($objItem in $colItems) {

 "------------------------------ OS Info ---------------------"

 "Computer Name: "+ $strComputer

 “Operating System:” + $objItem.Name

}

}

Function CPUInfo {

$colItems = Get-WmiObject Win32_Processor -Namespace “root\CIMV2" -Computername $strComputer

foreach($objItem in $colItems) {

  "------------------------CPU Info -------------------------"

  "Computer Name: "+ $strComputer

  “Caption: ”+ $objItem.Caption

  “CPU Status: ”+ $objItem.CpuStatus

  “Current Clock Speed: ”+ $objItem.CurrentClockSpeed

  “Device ID: ”+ $objItem.DeviceID

  “L2 Cache Size: ”+ $objItem.L2CacheSize

  “L2 Cache Speed: ”+ $objItem.L2CacheSpeed

  “Name: ”+ $objItem.Name

  "System Name:" + $objItem.SystemName

}

}

Function DiskInfo {

$colItems = Get-WmiObject Win32_DiskDrive -Namespace “root\CIMV2" -ComputerName $strComputer

foreach($objItem in $colItems) {

  "------------------------- Disk Info --------------------"

  "Computer Name: "+ $strComputer

  “Description: ”+ $objItem.Description

  “Device ID: ”+ $objItem.DeviceID

  “Interface Type: ”+ $objItem.InterfaceType

  “Media Type: ”+ $objItem.MediaType

  “Model: ”+ $objItem.Model

  “Partitions: ”+ $objItem.Partitions

  “Size: ”+ $objItem.Size

  “Status: ”+ $objItem.Status

}

}

Function NetworkInfo {

$colItems = Get-WmiObject Win32_NetworkAdapterConfiguration -Namespace “root\CIMV2" -ComputerName $strComputer | where{$_.IPEnabled -eq “True”}

foreach($objItem in $colItems) {

 "------------------------------ Network Info ---------------------"

 "Computer Name: "+ $strComputer

 “DHCP Enabled:” + $objItem.DHCPEnabled

 “IP Address:” + $objItem.IPAddress

 “Subnet Mask:” + $objItem.IPSubnet

 “Gateway:” + $objItem.DefaultIPGateway

 “MAC Address:” + $ojbItem.MACAddress

}

}

Function SysInfo {

$colItems = Get-WmiObject Win32_ComputerSystem -Namespace “root\CIMV2" -ComputerName $strComputer

foreach($objItem in $colItems) {

"------------------------------ Sys Info ---------------------"

"Computer Name: "+ $strComputer

“Computer Manufacturer: ” + $objItem.Manufacturer

“Computer Model: ” + $objItem.Model

“Total Memory: ”  + $objItem.TotalPhysicalMemory + “bytes”

}

}

# Create a GUI Form

$objForm = New-Object System.Windows.Forms.Form 

$objForm.Text = "Data Entry Form"

$objForm.Size = New-Object System.Drawing.Size(800,600) 

$objForm.StartPosition = "CenterScreen"

$objForm.KeyPreview = $True

#$objForm.Add_KeyDown({if ($_.KeyCode -eq "Enter") 

#    {$x=$objTextBox.Text;$objForm.Close()}})

$objForm.Add_KeyDown({if ($_.KeyCode -eq "Escape") 

    {$objForm.Close()}})

# Add a drop-down Combo box

$objComboBox = New-Object System.Windows.Forms.Combobox

$objComboBox.Location = New-Object System.Drawing.Size(250,250)

$objComboBox.Size  = New-Object System.Drawing.Size(280,20)

$objComboBox.Text = "Please select"

# Add items to Combo box

$commands = @("SysInfo","BIOSInfo","OSInfo","CPUInfo","DiskInfo","NetworkInfo")

ForEach ($command in  $commands){

    $objComboBox.items.add($command)

 }

# Add combo box to Userform

$objForm.Controls.Add($objComboBox)

# Set to the first item

$objComboBox.SelectedIndex = 0;

# Set selection to ComboBox selected text.

$selection = $objComboBox.Text;

write-host $selection

# Add a text box to the Userform

$objTextBox = New-Object System.Windows.Forms.TextBox 

$objTextBox.Location = New-Object System.Drawing.Size(250,200) 

$objTextBox.Size = New-Object System.Drawing.Size(280,20) 

$objForm.Controls.Add($objTextBox)

# Add an OK button and name it as  "Submit"

$OKButton = New-Object System.Windows.Forms.Button

$OKButton.Location = New-Object System.Drawing.Size(250,400)

$OKButton.Size = New-Object System.Drawing.Size(75,25)

$OKButton.Text = "Submit"

$objForm.Controls.Add($OKButton)

# Add a Cancel button

$CancelButton = New-Object System.Windows.Forms.Button

$CancelButton.Location = New-Object System.Drawing.Size(350,400)

$CancelButton.Size = New-Object System.Drawing.Size(75,23)

$CancelButton.Text = "Cancel"

$CancelButton.Add_Click({$objForm.Close()})

$objForm.Controls.Add($CancelButton)

# Add an Exit button

$ExitButton = New-Object System.Windows.Forms.Button

$ExitButton.Location = New-Object System.Drawing.Size(450,400)

$ExitButton.Size = New-Object System.Drawing.Size(75,23)

$ExitButton.Text = "Exit"

$ExitButton.Add_Click({$objForm.Close()})

$objForm.Controls.Add($ExitButton)

# Add a Text label

$objLabel = New-Object System.Windows.Forms.Label

$objLabel.Location = New-Object System.Drawing.Size(250,180) 

$objLabel.Size = New-Object System.Drawing.Size(280,20) 

$objLabel.Text = "Please enter a comma separated list of servers:"

$objForm.Controls.Add($objLabel) 

 # Add a Text label

$objLabel = New-Object System.Windows.Forms.Label

$objLabel.Location = New-Object System.Drawing.Size(260,100) 

$objLabel.Size = New-Object System.Drawing.Size(280,20) 

$objLabel.Text = "Windows Resource Management Tool"

$objForm.Controls.Add($objLabel) 

# Set form on top

$objForm.Topmost = $True

# Show fim

$objForm.Add_Shown({$objForm.Activate()})

[void] $objForm.ShowDialog()

$x = $objTextbox.text

$vals = $x.split(",")

foreach ($strComputer in $vals){

   write-host $strComputer

   }

$OKButton.Add_Click({

  

  

switch ($objComboBox.SelectedItem)

{

"SysInfo" {SysInfo}

"BIOSInfo" {BiosInfo}

"OSInfo" {OSInfo}

"CPUInfo" {CPUInfo}

"DiskInfo" {DiskInfo}

"NetworkInfo" {NetworkInfo}

}

$objForm.Close()})

# Set selection to ComboBox selected text.

$selection = $objComboBox.Text;

write-host $selection

foreach ($strComputer in $vals){

          switch($selection) {

"SysInfo" { SysInfo  }

"BIOSInfo" {BiosInfo}

"OSInfo" {OSInfo}

"CPUInfo" {CPUInfo}

"DiskInfo" {DiskInfo}

"NetworkInfo" {NetworkInfo}

          }

   } 

$x

Building a respectable VBA with Excel Application

VBA with Excel is not the right tool/language to solve mankind’s perennial question regarding the purpose of life. But it can come quite handy for several tasks for e.g. in quickly creating a Proof of Concept (PoC) or a prototype. It can also be quite useful for smaller tasks for e.g. 3G networks dimensioning, determining an investment portfolio, insurance schemes or maybe a smaller version of a Windows Resource Management tool. To take a quick look at how put together a VBA application quickly take a look at my earlier post “Stir fry a VBA with Excel application quickly”. This post takes a look at some key aspects in building a respectable, decent tool. Some of essential elements are as follows a) Launch button: Launch the application from the Excel sheet. For this you could add a button to the Excel sheet. For this select “View->Toolbars-Forms”. From the toolbar select a button and place it in the Excel sheet. Once you place the button appropriately select the button and choose the “Edit code” from the Forms toolbox. Add the following code Sub Button1_Click () UserForm1.Show End Sub The Userform1 is the form that you created with VBA toolbox.

b) Minimize button Now that you are able to launch the VBA application from the Excel spreadsheet you will also want to minimize the VBA form to check the output on the Excel sheet. For this add a button to the Userform probably “_” the icon for minimizing and add Private Sub CommandButton13_Click() Unload UserForm1 End Sub You could also do a Userform1. Hide but I found that once you did that and re-launched the application the combo-box’s list started to repeat. Unload essentially resets the Form and that was fine with me. c) Getting control of the Excel sheet: This is extremely important. Make sure that in the properties window of your userform you have ShowModal set as “false”. This will allow you to edit/change your Excel sheet even when the VBA application is running. d) Status Control: VBA does provide a “Status” control in the additional controls for the Userform toolbox. But I could not get it to work. So I added a textbox and update the text box with “Working …” and “Done.” e) Progress bar: If you want to add a progress bar do so by adding this control. For this right-click in the toolbox and choose additional controls. I did not have the need to use this but a good write up is available at O’Reilly Hacks This is the userform I created

Option Explicit
Dim servername
Dim row
Dim value

Private Sub CommandButton13_Click()
Unload UserForm1
End Sub
Private Sub CommandButton14_Click()
Unload UserForm1
End Sub

Private Sub CommandButton2_Click()
ComboBox1.ListIndex = 0
Me.OptionButton1.value = True
TextBox1.value = ""
End Sub

Private Sub CommandButton3_Click()
Unload UserForm1
End Sub

Private Sub TextBox1_Change()
servername = TextBox1.value
End Sub
Private Sub UserForm_Activate()
With ComboBox1
    ComboBox1.AddItem "Physical Memory Properties"
    ComboBox1.AddItem "Get Server Info"
    ...
    ....
    End With
Me.Label17.Font.Bold = True
Me.MultiPage1.ForeColor = vbBlue
ComboBox1.ListIndex = 0
Me.OptionButton1.value = True
row = 25
End Sub
Private Sub ComboBox1_Click()
Dim x
Select Case ComboBox1.Text
   Case "Physical Memory Properties"
        value = 1
   Case "Get Server Info"
        value = 2
   ...
   ...        
End Select

End Sub
Private Sub CommandButton1_Click()

If OptionButton1.value = True Then

Select Case value
   Case 1
        Call phy_mem_prop
   Case 2
        Call GetServerInfo
   ...
   ...          
End Select
Else
  If OptionButton2.value = True Then
     
    Select Case value
    Case 1
        Call phy_mem_prop_csv
    Case 2

        Call GetServerInfo_csv
  ...
  ...          
    End Select
    End If
 

End If
End Sub

Private Sub phy_mem_prop()
On Error Resume Next
Dim strComputer, i, objWMIService, strMemory, colItems
Dim strCapacity, objItem, installedModules, totalSlots
Dim strCapacityGB
Dim r As Range
Dim arrstring
Dim slogFile, objFs, objFile
Dim col
row = row + 3

arrstring = Split(servername, ",")
For Each strComputer In arrstring
i = 1
Application.StatusBar = "Working..."
UserForm1.TextBox5.Font.Italic = True
UserForm1.TextBox5.Font.Bold = False
UserForm1.TextBox5.Font.Size = 10
UserForm1.TextBox5 = "Working..."

Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemory")

For Each objItem In colItems
    strCapacity = objItem.Capacity
    If strMemory <> "" Then strMemory = strMemory & vbCrLf
    strMemory = strMemory & "Bank" & i & " : " & (objItem.Capacity / 1048576) & " Mb"
    i = i + 1
Next
installedModules = i - 1

Set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemoryArray")
For Each objItem In colItems
    totalSlots = objItem.MemoryDevices
    strCapacity = (objItem.MaxCapacity / 1024)
    strCapacityGB = strCapacity / 1024
Next
'MsgBox "Total Slots: " & totalSlots & vbCrLf & _
         "Free Slots: " & (totalSlots - installedModules) & vbCrLf & _
         vbCrLf & "Installed Modules:" & vbCrLf & strMemory & vbCrLf & vbCrLf & _
         "Maximum Capacity for " & strComputer & ": " & strCapacityGB & " GB", vbOKOnly + vbInformation, "PC Memory Information"

Sheet1.Cells(row, 1).Font.Bold = True
Cells(row, 1) = "Physical Memory Properties"
row = row + 1

For col = 1 To 5
  Sheet1.Cells(row, col).Interior.Color = vbCyan
  Sheet1.Cells(row, col).Font.Bold = True
Next

Cells(row, 1) = "Computer Name: "
Cells(row, 2) = "Total Slots"
Cells(row, 3) = "Free Slots"
Cells(row, 4) = "Installed Modules"
Cells(row, 5) = "Maximum Capacity for"
row = row + 1
Cells(row, 1) = strComputer
Cells(row, 2) = totalSlots
Cells(row, 3) = totalSlots - installedModules
Cells(row, 4) = strMemory
Cells(row, 5) = strCapacityGB
Next
UserForm1.TextBox5.Font.Italic = False
UserForm1.TextBox5 = "Done."
Application.StatusBar = "Done."
Application.StatusBar = False
End Sub

Private Sub phy_mem_prop_csv()
On Error Resume Next
Dim arrstring
Dim strComputer, i, objWMIService, strMemory, colItems
Dim strCapacity, objItem, installedModules, totalSlots
Dim strCapacityGB
Const FOR_APPEND = 8
Dim slogFile
Dim objFs, objFile
arrstring = Split(servername, ",")
For Each strComputer In arrstring
i = 1

Application.StatusBar = "Working..."
UserForm1.TextBox5.Font.Italic = True
UserForm1.TextBox5.Font.Bold = False
UserForm1.TextBox5.Font.Size = 10
UserForm1.TextBox5 = "Working..."

Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemory")
For Each objItem In colItems
    strCapacity = objItem.Capacity
    If strMemory <> "" Then strMemory = strMemory & vbCrLf
    strMemory = strMemory & "Bank" & i & " : " & (objItem.Capacity / 1048576) & " Mb"
    i = i + 1
Next
installedModules = i - 1

Set colItems = objWMIService.ExecQuery("Select * from Win32_PhysicalMemoryArray")

For Each objItem In colItems
    totalSlots = objItem.MemoryDevices
    strCapacity = (objItem.MaxCapacity / 1024)
    strCapacityGB = strCapacity / 1024
Next

slogFile = "logfile.txt"
Set objFs = CreateObject("scripting.FileSystemObject")
Set objFile = objFs.OpenTextFile(slogFile, FOR_APPEND, True)
objFile.writeline
objFile.writeline
objFile.writeline
objFile.writeline
objFile.writeline

objFile.writeline "Physical Memory Properties"
    objFile.writeline "Total slot = " & totalSlots & _
     "Free Slots = " & totalSlots - installedModules & _
         "Installed Modules = " & strMemory + _
         "Max capacity = " & strCapacityGB

         objFile.Close
         Set objFile = Nothing
         Set objFs = Nothing
  Next

UserForm1.TextBox5.Font.Italic = False
UserForm1.TextBox5 = "Done."
UserForm1.TextBox5 = "Output in logfile.txt"
Application.StatusBar = "Done."
Application.StatusBar = False
End Sub
Sub GetServerInfo()
On Error Resume Next

Dim r As Range, i As Integer, N As Integer
Dim arrstring
Dim strComputer, colDisks, objDisk, objWMIService
Dim col
row = row + 3
Application.StatusBar = "Working..."
UserForm1.TextBox5.Font.Italic = True
UserForm1.TextBox5.Font.Bold = False
UserForm1.TextBox5.Font.Size = 10
UserForm1.TextBox5 = "Working..."

arrstring = Split(servername, ",")
For Each strComputer In arrstring


Worksheets("sheet1").Activate
Set objWMIService = GetObject _
    ("winmgmts:\\" & strComputer & "\root\cimv2")
Set colDisks = objWMIService.ExecQuery _
         ("Select * From Win32_LogicalDisk")
     
Sheet1.Cells(row, 1).Font.Bold = True
Cells(row, 1) = "Server Information"
row = row + 1

For col = 1 To 4
  Sheet1.Cells(row, col).Interior.Color = vbCyan
  Sheet1.Cells(row, col).Font.Bold = True
Next
Cells(row, 1) = "Computer Name: "
         Cells(row, 2) = "Disk"
         Cells(row, 3) = "Free Space"
         Cells(row, 4) = "Total Size"
                  row = row + 1
Cells(row, 1) = strComputer
         For Each objDisk In colDisks
                        Cells(row, 2) = objDisk.DeviceID
             If objDisk.FreeSpace < 1073741824 Then
                                        Cells(row, 3) = objDisk.FreeSpace / 1024 / 1024
                            Else
                   
                     Cells(row, 3) = objDisk.FreeSpace / 1024 / 1024
            End If
            Cells(row, 4) = objDisk.Size / 1024 / 1024
            row = row + 1
                    Next
Next
UserForm1.TextBox5.Font.Italic = False
UserForm1.TextBox5 = "Done."
Application.StatusBar = "Done."
Application.StatusBar = False
End Sub

Sub GetServerInfo_csv()
On Error Resume Next

Dim arrstring
Dim strComputer, colDisks, objDisk, objWMIService
Dim slogFile
Dim objFs, objFile
Const FOR_APPEND = 8
arrstring = Split(servername, ",")
For Each strComputer In arrstring
Application.StatusBar = "Working..."
UserForm1.TextBox5.Font.Italic = True
UserForm1.TextBox5.Font.Bold = False
UserForm1.TextBox5.Font.Size = 10
UserForm1.TextBox5 = "Working..."
Set objWMIService = GetObject _
    ("winmgmts:\\" & strComputer & "\root\cimv2")
Set colDisks = objWMIService.ExecQuery _
         ("Select * From Win32_LogicalDisk")
slogFile = "logfile.txt"
Set objFs = CreateObject("scripting.FileSystemObject")
Set objFile = objFs.OpenTextFile(slogFile, FOR_APPEND, True)
objFile.writeline
objFile.writeline
objFile.writeline
objFile.writeline
objFile.writeline
objFile.writeline "Server Information"
objFile.writeline "Computer Name: ,Disk, Free Space, Total Size"
 objFile.write strComputer & ","
         For Each objDisk In colDisks
               objFile.write objDisk.DeviceID & ","
             If objDisk.FreeSpace < 1073741824 Then
                   objFile.write objDisk.FreeSpace / 1024 / 1024 & ","
                            Else
                 
                     objFile.write objDisk.FreeSpace / 1024 / 1024 & ","
            End If
            objFile.writeline objDisk.Size / 1024 / 1024 & ","
                   
          Next
          Next
          objFile.Close
         Set objFile = Nothing
         Set objFs = Nothing
       
UserForm1.TextBox5.Font.Italic = False
UserForm1.TextBox5 = "Done."
UserForm1.TextBox5 = "Output in logfile.txt"
Application.StatusBar = "Done."
Application.StatusBar = False
       
End Sub

Sub GetService()
On Error Resume Next
Dim strstring
Dim r As Range, i As Integer, N As Integer
Dim col
Dim arrstring
Dim strComputer, colWMIThings, objItem, objWMIService
row = row + 4
Application.StatusBar = "Working..."
UserForm1.TextBox5.Font.Italic = True
UserForm1.TextBox5.Font.Bold = False
UserForm1.TextBox5.Font.Size = 10
UserForm1.TextBox5 = "Working..."
arrstring = Split(servername, ",")
For Each strComputer In arrstring
'MsgBox (servername)
Worksheets("sheet1").Activate
Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\cimv2")
Set colWMIThings = _
    objWMIService.ExecQuery("SELECT * FROM Win32_service")
Sheet1.Cells(row, 1).Font.Bold = True
Cells(row, 1) = "Services"
row = row + 1
For col = 1 To 4
  Sheet1.Cells(row, col).Interior.Color = vbCyan
  Sheet1.Cells(row, col).Font.Bold = True
Next
Cells(row, 1) = "Computer Name: "
Cells(row, 2) = "Service name"
Cells(row, 3) = "Status"
Cells(row, 4) = "Strtup Mode"
row = row + 1
Cells(row, 1) = strComputer
    For Each objItem In colWMIThings
                If objItem.State = "Stopped" And objItem.StartMode = "Auto" Then
            Cells(row, 2) = objItem.DisplayName
        Else
            Cells(row, 2) = objItem.DisplayName
        End If
        Cells(row, 3) = objItem.State
        Cells(row, 4) = objItem.StartMode
        row = row + 1
    Next
    Next
UserForm1.TextBox5.Font.Italic = False
UserForm1.TextBox5 = "Done."
Application.StatusBar = "Done."
Application.StatusBar = False
End Sub

Windows Resource Management Tool – Technology choices

There are the following technology choices for a Windows Automation Tool

a) VBA with Excel
b) Perl
c) Powershell
d) HTML for Applications (HTA)

1. VBA with Excel
VBA (Visual Basic for Applications) with Excel is good option to consider. VBA allows for a quick development of a fairly reasonable user interface. VBA includes a Userform to which one can controls like textbox, listbox, combo box, radio button etc. These controls can then invoke VBscripts in the background which can perform resource management tasks. For some more detail on how to create the Userform with controls look at my earlier post Stir fry a VBA application quickly. Besides, the results can be populated in the Excel sheet

A screen shot of a VBA with Excel is shown below

Pros
a. Ease of building a GUI using the Visual Basic User form with appropriate controls
b. The VBA will include VBscripts that will perform resource management tasks
c. Can populate the results into Excel sheet.
d. The results from the Excel sheet can be saved as CSV, HTML etc

Cons
a. Not all client sites have MS Office installed on them. This makes it difficult to deploy Excel with VBA.

2. Perl

Perl allows for easy creation of scripts to manage Windows Resources. The language is easy to use and facilitates quick prototyping. However Perl by itself does not provide for the creation of a GUI. Perl scripts can only be run in command line mode.

Pros
a. Ease of scripting

Cons
a. Does not allow for creation of a GUI


3. Powershell
Powershell is a convenient way for creating resource management scripts. It is surprising the Microsoft took such a long time to progress from the clunky “command” shell to Powershell which is more on the lines of Korn, Bourne and Unix shell. The nice part is that instead of the cryptic Unix commands the commands have a verb-noun combination for e.g. get-date, get-command etc. The benefit of Powershell is the extensive help that is available for each command. Powershell is in many ways similar to Perl. Building a GUI with Powershell is quite involved and requires quite a bit of programming. Moreover Powershell is installed by default only on Windows 7 and later. For an excellent tutorial on Powershell do read Powershell tutorial by Jesse Hamrick

Pros
a. Ease of scripting for resource management
b. Extensive help available for query while building resource management commands
c. Can format output easily into list, table or Excel sheet
d. Easy to build stand-alone scripts


Cons
a. Building a GUI based tool is fairly involved


4. HTML Applications (HTA)
HTML application brings the power of the browser for the front end with VBscript or JScript as the backend. But to build a easy to use GUI there is a need to use Web page builders like Microsoft’s FrontPage, Dreamweaver etc. The controls on the Web page can invoke VBScript to run resource management tasks

Pros
a. Can build a user-friendly front-end using Web page builder tools
b. Resource management tasks can be executed by VBscript

Cons
a. Needs a regular Web page building tool like MS FrontPage or Dreamweaver