VMware: Dynamic reports using PowerCLI and AngularJS

In latest articles I provided several ways to produce HTML reports out of data gathered by running a PowerCLI script. Alarms, charts and reports are produced in a simple yet effective way by running a PowerCLI script which retrieve data after querying an entity, usually a vCenter Server, then data is literally outputted as an HTML file by the script itself.
In today's post I will introduce a far more elegant way to produce HTML reports upon data retrieved from an ESXi cluster. These reports are HTML pages based on AngularJS, Google's extremely powerful framework based on MVC pattern. Extremely trivializing, the logic behind AngularJS and an MVC based framework is to separate the logic (Controller) from the content (Model) and from the style (View).

Since I'm a beginner on AngularJS I'm not the most suitable guy to explain these concepts in plain detail so let's proceed to what's the scope of this article: generate a dynamic HTML report.

Let's start by dividing the scenario in two parts:

1)Back-end: where the "magic" happens.
2)Front-end: where you will get in touch with this "magic".

Back-end is composed by GenerateJSON.ps1 PowerCLI script. This script retrieves all virtual machines from a given cluster and exports VM infos in JSON, a format that can be easily processed and consumed by the front-end.

Most of the job is done by this line of PowerCLI code:

 Get-VM -Name $vm | Select * -ExcludeProperty ExtensionData | ConvertTo-Json -Depth 1 > $OutputPath\$($vm.Id).json  

This gets data for each VM in the given cluster and exports it in JSON saving the output in the proper folder. The $OutputPath folder is really important since by default the front-end will search for JSON files in such folder so be careful to set it properly. If you wonder why we exclude ExtensionData from the report that is to prevent an error due to a conflicting naming with an already existing property.

Since this script could take some time depending on how many VMs there are in your cluster be patient.

Another advice is to add this PowerCLI script as a Windows Scheduled Task so you can have VM "fresh-data" once in while and you don't have to run it manually every time.

Front-end comprises a web page that, by using AngularJS, allow us to dynamically list all virtual machines gathered by the back-end with corresponding details like OS they are running, configured amount of memory/CPUs, power state, host on which they are currently running on, etc. AngularJS allow us to do some nice tricks like searching and sorting results without reloading the web page every time.

Who is already skilled on AngularJS will recognize that the front-end is the official AngularJS tutorial application slightly modified and styled. Of course this is just an example to point out how endless are the possibilities offered by PowerCLI for reporting. You should edit/change it according to your needs, but this could be a good starting point.

This is a diagram who gives an idea of what front-end and back-end are:

Here's how the final result will look like:

This is the PowerCLI code composing the back-end and, as usual you can find it in my GitHub repository GenerateJSON.ps1

	#Variable declaration
	$vCenterIPorFQDN="10.0.1.210"
	$vCenterUsername="Administrator@vsphere.local"
	$vCenterPassword="vmware"
	$ClusterName="My Cluster" #Name of the cluster from which you want to retrieve VM infos
	#Location where you want to place generated JSON Files.
	#Please be aware that you should place them in the "data" folder in order to make WebPowerCLI read data from them
	$OutputPath="C:\Users\Paolo\Desktop\data"
	Write-Host "Depending on how many VMs you have in your cluster this script could take a while...please be patient" -foregroundcolor "magenta"
	Write-Host "Connecting to vCenter" -foregroundcolor "magenta"
	Connect-VIServer -Server $vCenterIPorFQDN -User $vCenterUsername -Password $vCenterPassword
	$vms = Get-Cluster -Name $ClusterName | Get-VM
	$vms | ConvertTo-Json -Depth 1 > $OutputPath\vms_all.json
	foreach($vm in $vms){
	Write-Host "Generating JSON file for VM:" $vm -foregroundcolor "magenta"
	Get-VM -Name $vm | Select * -ExcludeProperty ExtensionData | ConvertTo-Json -Depth 1 > $OutputPath\$($vm.Id).json
	}
	Write-Host "Disconnecting from vCenter" -foregroundcolor "magenta"
	Disconnect-VIServer * -Confirm:$false

view raw GenerateJSON.ps1 hosted with ❤ by GitHub

Front-end is composed by some files, all of them available on my GitHub.

Download AngularJS dynamic reports

This is the folder tree, be careful to download every file in order to make web page work.

Root AngularJS folder\
|__data\
|    |_PLACE HERE GENERATED JSON FILES
|__img\
|    |_logo.png
|__js\
|    |_app.js
|    |_controllers.js
|    |_filters.js
|__partials\
|    |_vm-detail.html
|    |_vm-list.html
|_index.html
|_newstyle.css

In the AngularJS project you will notice that JSON files are fetched "statically", they are placed in data folder and read from there.It would be a nice addition to provide these files to the AngularJS page using a web service, like a PHP page which dynamically calls PowerCLI each time a JSON file is needed.

That's all!!

VMware: PowerCLI to report triggered Alarms

There's one more thing related to management that I've still not covered in previous blog posts about reporting: alarms.
They are extremely important indicators of issues occurring in our virtual infrastructure, they are triggered once there's something wrong, something that need to be resolved in order to make everything work smooth.

Alarms are of two kinds: Warnings and Alerts. A Warning indicates that something is wrong in our environment but it's not yet critical. When it becomes more serious a Warning is replaced by an Alert, dictating something needs to be addressed as soon as possible.

As usual PowerCLI allow us to retrieve and get some informations regarding triggered alarms.

The following PowerCLI script connects to a vCenter Server and retrieves all alarms from any registered host. These alarms are presented in an HTML table and, using JavaScript, we add a little bit a style. By being JavaScript interpreted at client level, browser need to have it enabled in order to work.

The following image depicts an example of what you get after running the script:

For the sake of keeping the script essential I've excluded the CSS from it but, if you have a look at my previous fancy HTML reports blog post, you will get an example about how to use it in your report.

Here's the code for creating reports based on triggered alarms, as usual, you can also find it in my GitHub repository: Alarm Reports.ps1

	#Variable declaration
	$vCenterIPorFQDN="10.0.1.210"
	$vCenterUsername="Administrator@vsphere.local"
	$vCenterPassword="vmware"
	$OutputFile="C:\Users\Paolo\Desktop\Report.html" #Where you want to place generated report
	Write-Host "Connecting to vCenter" -foregroundcolor "magenta"
	Connect-VIServer -Server $vCenterIPorFQDN -User $vCenterUsername -Password $vCenterPassword
	#A JavaScript to add some style to our report
	$htmlheader = @"
	<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
	<script type="text/javascript">
	`$(document).ready(function(){
	`$( "td:contains('yellow')" ).css('background-color', '#FDF099'); //If yellow alarm triggered set cell background color to yellow
	`$( "td:contains('yellow')" ).text('Warning'); //Replace text 'yellow' with 'Warning'
	`$( "td:contains('red')" ).css('background-color', '#FCC' ); //If yellow alarm triggered set cell background color to red
	`$( "td:contains('red')" ).text('Alert'); //Replace text 'red' with 'Alert'
	});
	</script>
	"@
	$hosts = Get-VMHost | Get-View #Retrieve all hosts from vCenter
	foreach ($esxihost in $hosts){ #For each Host
	foreach($triggered in $esxihost.TriggeredAlarmState){ #For each triggered alarm of each host
	$arrayline={} | Select HostName, AlarmType, AlarmInformations #Initialize line
	$alarmDefinition = Get-View -Id $triggered.Alarm #Get info on Alarm
	$arrayline.HostName = $esxihost.Name #Get host which has this alarm triggered
	$arrayline.AlarmType = $triggered.OverallStatus #Get if this is a Warning or an Alert
	$arrayline.AlarmInformations = $alarmDefinition.Info.Name #Get infos about alarm
	$HostList += $arrayline #Add line to array
	$HostList = @($HostList) #Post-Declare this is an array
	}
	}
	#Outputs the report as an HTML file
	ConvertTo-Html -Title "Test Title" -Head "<div id='title'>PowerCLI Alarms</div><div id='subtitle'>Report generated: $(Get-Date)</div>$htmlheader" -Body $($HostList |
	select HostName, AlarmType, AlarmInformations | ConvertTo-Html -Fragment) | Out-File $OutputFile

view raw Alarm Reports.ps1 hosted with ❤ by GitHub

That's all!!

VMware: VM stats using PowerCLI and Google Charts

Let me start today's post by pointing out that this is more a proof of concept than a real thing, but I hope from this piece of code you get the idea of how many different tasks can be accomplished by using PowerCLI and how versatile it is for reporting capabilities. After producing fancy reports using PowerCLI why not also include some charts in them?

This can be easily accomplished by using Google Charts, JavaScript pieces of code that generates charts/tables just by passing data to them and the resulting charts can be embedded in web pages.

The idea behind this PowerCLI script is to generate an HTML page and retrieve stats from an entity (a virtual machine) by using the Get-Stat cmdlet. These stats will be passed as data upon which charts will be created.

If you have a look at a sample chart code, for example a donut chart, you can slice it up into three different areas: an header in which javascript function is defined, a body, the most important part, in which you insert all the data and some options like title, measures to be used on x-y-axis, etc. Third and final part is a sort of a footer in which javascript and html tags are closed.

The PowerCLI cmdlet Get-Stat retrieve stats from any powered on virtual machine:

 Get-Stat -Entity (Get-VMHost -Name 10.0.1.62 | Get-VM | Where-Object PowerState -match "PoweredOn") -Stat $stat -Start (Get-Date).AddHours(-24) -MaxSamples (10) -IntervalMins 10 | Measure-Object Value -Average  

Where:

-Entity: the object against you want to retrieve stats from. This could be a datacenter, a virtual machine, a host, etc. In the line above it retrieves all powered on VMs running on host 10.0.1.62.
-Stat: the statistic you want to retrieve.

The following values are accepted:

cpu.usage.average
cpu.usagemhz.average
mem.usage.average
disk.usage.average
net.usage.average
sys.uptime.latest

-Start: start time of statistics retrieval
-MaxSamples: how many samples consider for the measurement
-IntervalMins: the amount of time that separates two consecutive measurements
-Measure-Object Value: we need to specify we are going to use this value as a measure.
-Average: how this measure will be considered. Average, Maximum and Minimum are accepted values. Average consider the average resulting value from all collected samples. Please note that for every of the available stats the Average value is a good indicator since the average usage of CPU, Memory, Disk or Network over an amount of time could be considered as a good indicator of how well the measured entity performs. sys.uptime.latest is the only measure for that average is not suited, since we need to retrieve only the last value of uptime in this case Maximum is the correct way to measure it.

The output produced by the PowerCLI script is an HTML file and this means that you can style it applying a proper CSS.

This is an example of a chart report I generated:

The following is the sample PowerCLI code used to generate a donut chart, as usual you can find it also on my GitHub repository: Stats using Google charts.ps1

	#Variable declaration
	$vCenterIPorFQDN="192.168.243.40"
	$vCenterUsername="Administrator@vsphere.local"
	$vCenterPassword="vmware"
	$ESXiHost="192.168.243.62"
	$outputFile="C:\Users\Paolo\Desktop\mycharts.html"
	$stat = "mem.usage.average" #Stat to measure
	#Available stats
	#cpu.usage.average
	#cpu.usagemhz.average
	#mem.usage.average
	#disk.usage.average
	#net.usage.average
	#sys.uptime.latest
	Connect-VIServer -Server $vCenterIPorFQDN -User $vCenterUsername -Password $vCenterPassword
	$htmlheader = @"
	<html>
	<head>
	<script type="text/javascript" src="https://www.google.com/jsapi"></script>
	<script type="text/javascript">
	google.load("visualization", "1", {packages:["corechart"]});
	google.setOnLoadCallback(drawChart);
	function drawChart() {
	var data = google.visualization.arrayToDataTable([
	['Virtual Machine', 'Average Usage'], //What we are measuring
	"@
	$vms = Get-VMHost -Name $ESXiHost | Get-VM | Where-Object PowerState -match "PoweredOn" #Retrieves all powered on VMs from a specific host
	#$vms = Get-VM -Server $vCenterIPorFQDN | Where-Object PowerState -match "PoweredOn" #Retrieves all powered on VMs from a vCenter, depending on the number of hosts/VMs this could take a while
	foreach ($vm in $vms) {
	$value = Get-Stat -Entity $vm.Name -Stat $stat -Start (Get-Date).AddHours(-24) -MaxSamples (10) -IntervalMins 10 | Measure-Object Value -Average
	$data += "['$vm', $($value.Average)],"
	}
	$htmlfooter=@"
	]);
	var options = {
	title: 'Average Network Usage', //Chart Title
	pieHole: 0.4, //Option regarding this specific kind of chart
	};
	var chart = new google.visualization.PieChart(document.getElementById('donutchart'));
	chart.draw(data, options);
	}
	</script>
	</head>
	<body>
	<div id='title'>PowerCLI Google Charts</div>$br<div id='subtitle'>Report generated: $(Get-Date)</div>
	<div id="box1">
	<div id='boxheader'>Average Memory Usage</div>
	<div id='boxcontent'>
	<div id="donutchart" style="width: 900px; height: 500px;"></div>
	</div>
	</div>
	</body>
	</html>
	"@
	#Generating the output by concatenating strings
	$htmlheader + $data + $htmlfooter | Out-File $outputFile

view raw Stats using Google charts.ps1 hosted with ❤ by GitHub

As you can see this time HTML page is generated by simply concatenating variables $htmlheader, $data and $htmlfooter containing the HTML code. This is another, less elegant way though, to generate the HTML page. Conversely you can use the ConvertTo-Html cmdlet as in fancy reports using PowerCLI.

VMware: A PowerCLI GUI to edit VM hardware version 10

Hardware version 10 was introduced by VMware in late 2013 with ESXi 5.5. It brought several new improvements to VM capabilities like, for example, the maximum size of a single VMDK file up to 62TB au contraire to the 2TB of the hardware version 9 used in ESXi 5.0.

Despite the several indisputable improvements introduced by hardware version 10 some users pointed out some limitations in managing virtual machines adopting this hw version.

As you probably know virtual machine settings can only be modified using vSphere Web Client. Try to modify these VMs using the classic vSphere C# Client and you will incur in this message:

This limitation can be identified in VMware's strategy to soon discontinue the good 'ol vSphere C# Client and adopt the vSphere Flex Web Client as the standard tool to perform any kind of operation on the virtual infrastructure. Despite some features, like Site Recovery Manager, still require the C# Client others are only manageable through the Flex Client like the vSphere Data Protection or the brand new VSAN.

But what about changing a VM setting while a vCenter Server is unavailable? This of course results in Web Client unavailability. Or what about adding a new hard disk to a VM while in extreme hurry?

To answer first question a vCenter Server should NEVER be unavailable since by being the central point of infrastructure management its unavailability could introduce several limitations, not to mention the lack of several capabilities like DRS, vMotion, etc.

Second question instead was brought to my attention by several technicians working at my company. They simply find unbearably slow vSphere Web Client (maybe while editing VMs at customer site in late evening?) so to perform simple VM tasks like increasing CPUs, adding hard disks, etc. they tend to still use the C# Client. But as you know this is not possible for hardware version 10 VMs.

To keep a long story short I first try to encourage them to re-evaluate the Web Client and get used to use it even for the smallest things since this will be the future, but at the same time I embraced theyr cause and developed this little tool to help them to change, hopefully in a way smaller amount of time, settings for hardware version 10 virtual machines.

This tool was scripted in PowerCLI and once run will bring up a .NET like graphical user interface (GUI) from which perform all operations.

To use it you need to insert credentials to connect to a vCenter Server or directly to an host. Then you will have to select the host (in case you are connecting to a vCenter) on which is running/placed the VM you need to edit settings.Select the VM and modify vCPUs, RAM, increase disk size, or add new hardware like a new hard disk or a new network adapter.

Hardware version 10 VMs can be edited using PowerCLI in exactly the same way as for hw version 9 (or older) VMs.

The main cmdlets used in this script to edit VM settings are: 

Set-VM: Used to set many parameters of an existing VM like, for example, the amount of RAM, vCPUs, the High Availability Restart Priority, the hardware version, etc. 
Set-HardDisk: Edit Hard Disk properties/size for a specified Disk of a specified VM
New-HardDisk: Adds a new Hard Disk of a specified size to a specified VM.
Set-NetworkAdapter: Edit Network Adapter properties like wake on LAN, network to which the VM will be connected to, port group, MAC Address(*), etc.
New-NetworkAdapter: Adds a Network Adapter to a specified VM.

(*)In the code below I struggled, and failed, to find a proper way to edit MAC Address of a VM. I always got "Not a valid MAC Address or not in range..." error. Due to time limitations for article release I cannot overcame this obstacle and forced to leave in the code some lines regarding MAC changes: my bad. If you find a proper way to make it work you can also enable the MAC address editing feature.

Here's the PowerCLI code, as usual you can find it in my GitHub repository: Edit hw v10 VMs.ps1

	##################BEGIN FUNCTIONS
	function connectServer{
	try {
	$connect = Connect-VIServer -Server $serverTextBox.Text -User $usernameTextBox.Text -Password $passwordTextBox.Text
	$buttonConnect.Enabled = $false #Disable controls once connected
	$serverTextBox.Enabled = $false
	$usernameTextBox.Enabled = $false
	$passwordTextBox.Enabled = $false
	$buttonDisconnect.Enabled = $true #Enable Disconnect button
	getVmHosts #Populate DropDown list with all hosts connected (if vCenter)
	$HostDropDownBox.Enabled=$true
	$outputTextBox.text = "`nCurrently connected to $($serverTextBox.Text)" #If connection is successfull let user know it
	}
	catch {
	$outputTextBox.text = "`nSomething went wrong connecting to server!!"
	}
	}
	function disconnectServer{
	try {
	Disconnect-VIServer -Confirm:$false -Force:$true
	$buttonConnect.Enabled = $true #Enable login controls once disconnected
	$serverTextBox.Enabled = $true
	$usernameTextBox.Enabled = $true
	$passwordTextBox.Enabled = $true
	$buttonDisconnect.Enabled = $false #Disable Disconnect button
	$HostDropDownBox.Items.Clear() #Remove all items from DropDown boxes
	$HostDropDownBox.Enabled=$false #Disable DropDown boxes since they are empty
	$VmDropDownBox.Items.Clear()
	$VmDropDownBox.Enabled=$false
	$HardDiskDropDownBox.Items.Clear()
	$HardDiskDropDownBox.Enabled=$false
	$NetworkNameDropDownBox.Items.Clear()
	$NetworkNameDropDownBox.Enabled=$false
	$networkLabelDropDownBox.Items.Clear()
	$networkLabelDropDownBox.Enabled=$false
	$NetworkAdapterDropDownBox.Items.Clear()
	$NetworkAdapterDropDownBox.Enabled=$false
	$numVCpuTextBox.Text = ""
	$numVCpuTextBox.Enabled=$false
	$memSizeGBTextBox.Text = ""
	$memSizeGBTextBox.Enabled=$false
	$diskSizeGBTextBox.Text = ""
	$diskSizeGBTextBox.Enabled=$false
	$macAddressTextBox.Text = ""
	$macAddressTextBox.Enabled=$false
	$wolEnabled.Checked = $false
	$wolEnabled.Enabled = $false
	$connectedEnabled.Checked = $false
	$connectedEnabled.Enabled = $false
	$AddNewHardwareDropDownBox.Items.Clear()
	$AddNewHardwareDropDownBox.Enabled=$false
	$buttonAddHardware.Enabled = $false
	$newDiskSizeGBTextBox.Text = ""
	$newDiskSizeGBTextBox.Enabled=$false
	$independentEnabled.Enabled = $false
	$connectedAtPoweron.Checked = $false
	$connectedAtPoweron.Enabled = $false
	$adapterTypeDropDownBox.Items.Clear()
	$adapterTypeDropDownBox.Enabled = $false
	$networkLabelDropDownBox.Items.Clear()
	$networkLabelDropDownBox.Enabled = $false
	$outputTextBox.text = "`nSuccessfully disconnected from $($serverTextBox.Text)" #If disconnection is successfull let user know it
	}
	catch {
	$outputTextBox.text = "`nSomething went wrong disconnecting from server!!"
	}
	}
	function getVmHosts{
	try {
	$vmhosts = Get-VMHost | Where-Object {$_.PowerState -eq "PoweredOn" -and $_.ConnectionState -eq "Connected"} #Returns only powered On VmHosts
	foreach ($vm in $vmhosts) {
	$HostDropDownBox.Items.Add($vm.Name) #Add Hosts to DropDown List
	}
	}
	catch {
	$outputTextBox.text = "`nSomething went wrong getting VMHosts!!"
	}
	}
	function getVmsOnHost{
	try {
	$outputTextBox.text = "`nGetting Virtual Machines with Hardware Version 10 on VMHost: $($HostDropDownBox.SelectedItem.ToString())"
	$v10vms = Get-VM | Where-Object {$_.Version -eq "v10" -and $_.VMHost -eq $(Get-VMHost | Where-Object {$_.Name -eq $HostDropDownBox.SelectedItem.ToString()})} #Returns hardware v10 VMs
	foreach ($vm in $v10vms) {
	$VmDropDownBox.Items.Add($vm.Name) #Add VMs to DropDown List
	}
	$VmDropDownBox.Enabled=$true
	}
	catch {
	$outputTextBox.text = "`nSomething went wrong getting VMHosts!!"
	}
	}
	function getDisks{
	try {
	$HardDiskDropDownBox.Enabled = $true #Enable dropdownbox
	$harddisks = Get-HardDisk -VM $VmDropDownBox.SelectedItem.ToString()
	foreach ($disk in $harddisks) {
	$HardDiskDropDownBox.Items.Add($disk.Name) #Add Hosts to DropDown List
	}
	$HardDiskDropDownBox.SelectedItem = $harddisks.Name #Pre-Select Hard Disk
	}
	catch{
	$outputTextBox.text = "`nSomething went wrong getting VmHardDisks!!"
	}
	}
	function getSelectedDiskSize{
	try {
	$diskSizeGBTextBox.text = "" #Clear
	$diskSizeGBTextBox.Enabled = $true
	$harddisks = Get-HardDisk -VM $VmDropDownBox.SelectedItem.ToString() -Name $HardDiskDropDownBox.SelectedItem.ToString()
	$diskSizeGBTextBox.text = $harddisks.CapacityGB
	}
	catch{
	$outputTextBox.text = "`nSomething went wrong getting SelectedDiskSize!!"
	}
	}
	function getNetwork{
	try{
	$NetworkAdapterDropDownBox.Enabled = $true #Enable DropDown Box
	$wolEnabled.Enabled = $true
	$connectedEnabled.Enabled = $true
	$NetworkAdapterDropDownBox.Items.Clear() #Remove all items from DropDown Box since it may be dirtied by previous executions
	$networks= Get-NetworkAdapter -VM $VmDropDownBox.SelectedItem.ToString()
	foreach ($network in $networks) {
	$NetworkAdapterDropDownBox.Items.Add($network.Name) #Add Networks to DropDown List
	}
	$NetworkAdapterDropDownBox.SelectedItem = $networks.Name #Pre-Select Network
	if($network.WakeOnLanEnabled -match "True"){ #If WOL enabled
	$wolEnabled.Checked = $true
	}else{
	$wolEnabled.Checked = $false
	}
	if(-Not ($network.ConnectionState -match "NotConnected")){ #If connected
	$connectedEnabled.Checked = $true
	}else{
	$connectedEnabled.Checked = $false
	}
	}
	catch{
	$outputTextBox.text = "`nSomething went wrong getting Networks!!"
	}
	}
	function getSelectedNetworkName{
	try {
	$NetworkNameDropDownBox.Enabled = $true #Enable DropDown Box
	#$macAddressTextBox.Enabled = $true
	$NetworkNameDropDownBox.Items.Clear() #Remove all items from DropDown Box since it may be dirtied by previous executions
	$networkLabelDropDownBox.Items.Clear()
	$networks = Get-VirtualPortGroup -VMHost $HostDropDownBox.SelectedItem.ToString()
	foreach ($network in $networks) {
	$NetworkNameDropDownBox.Items.Add($network.Name) #Add Networks to DropDown List
	$networkLabelDropDownBox.Items.Add($network.Name)
	}
	$adapterNetwork = Get-NetworkAdapter -VM $VmDropDownBox.SelectedItem.ToString() -Name $NetworkAdapterDropDownBox.SelectedItem.ToString() #Get networks used by the adapter VM
	$NetworkNameDropDownBox.SelectedItem = $adapterNetwork.NetworkName #Pre-select by default the VM Network used by the selected VM
	$macAddressTextBox.text = $adapterNetwork.MacAddress
	$Label15.Text = $adapterNetwork.Type
	}
	catch{
	$outputTextBox.text = "`nSomething went wrong getting SelectedNetworkName!!"
	}
	}
	function getAddNewHardware{
	try{
	if($AddNewHardwareDropDownBox.SelectedItem -match "Hard Disk"){ #Add new Hard Disk
	if($independentEnabled.Checked -eq $true){ #Independent
	if($persistentRadioButton.Checked -eq $true) { #Independent Persistent
	$persistence = "IndependentPersistent"
	}elseif($nonPersistentRadioButton.Checked -eq $true){ #Independent Non Persistent
	$persistence = "IndependentNonPersistent"
	}
	}elseif($independentEnabled.Checked -eq $false){ #Persistent
	$persistence = "Persistent"
	}
	Get-VM -Name $VmDropDownBox.SelectedItem.ToString() | New-HardDisk -CapacityGB $newDiskSizeGBTextBox.Text -Persistence $persistence -Confirm:$false
	}
	elseif($AddNewHardwareDropDownBox.SelectedItem.ToString() -match "Network Adapter"){ #Add new Network Adapter
	if($connectedAtPoweron.Checked -eq $true){ #Connected at Poweron
	$startpoweron = $true
	}elseif($connectedAtPoweron.Checked -eq $false){
	$startpoweron = $false
	}
	if ($adapterTypeDropDownBox.SelectedItem.ToString() -match "E1000"){ #E1000
	$adaptertype = "e1000"
	}elseif($adapterTypeDropDownBox.SelectedItem.ToString() -match "VMXNET3"){ #VMXNET3
	$adaptertype = "vmxnet3"
	}elseif($adapterTypeDropDownBox.SelectedItem.ToString() -match "E1000E"){ #E1000E
	$adaptertype = "EnhancedVmxnet"
	}
	Get-VM -Name $VmDropDownBox.SelectedItem.ToString() | New-NetworkAdapter -NetworkName $networkLabelDropDownBox.SelectedItem.ToString() -StartConnected:$startpoweron -Type $adaptertype
	}
	getVmConfigs #Refresh data in Text Boxes
	}catch{
	$outputTextBox.text = "`nSomething went wrong getting AddNewHardware!!"
	}
	}
	function getVmConfigs{
	try {
	$outputTextBox.text = "`nGetting configs for VM: $($VmDropDownBox.SelectedItem.ToString())"
	$numVCpuTextBox.Enabled = $true #Enable TextBoxes
	$memSizeGBTextBox.Enabled = $true
	$buttonSetVm.Enabled = $true
	$AddNewHardwareDropDownBox.Enabled=$true #Enable Add new Hardware
	$HardDiskDropDownBox.Items.Clear() #Remove all items from GroupBox since it may be dirtied by previous executions
	$NetworkNameDropDownBox.Items.Clear()
	$NetworkAdapterDropDownBox.Items.Clear()
	$AddNewHardwareDropDownBox.Items.Clear()
	$connectedAtPoweron.Checked = $false
	$connectedAtPoweron.Enabled = $false
	$adapterTypeDropDownBox.Items.Clear()
	$adapterTypeDropDownBox.Enabled = $false
	$networkLabelDropDownBox.Items.Clear()
	$networkLabelDropDownBox.Enabled = $false
	$independentEnabled.Enabled = $false
	$persistentRadioButton.Enabled = $false
	$nonPersistentRadioButton.Enabled = $false
	$numVCpuTextBox.Text = "";
	$memSizeGBTextBox.Text = "";
	$diskSizeGBTextBox.Text = ""
	$macAddressTextBox.Text = ""
	$newDiskSizeGBTextBox.Text = ""
	$newDiskSizeGBTextBox.Enabled = $false
	$VmInfos = Get-VM -Name $VmDropDownBox.SelectedItem.ToString()
	$numVCpuTextBox.text = $VmInfos.NumCPU
	$memSizeGBTextBox.text = $VmInfos.MemoryGB
	getDisks
	getNetwork
	$hwsList=@("Hard Disk","Network Adapter") #Populate DropDownBox. By calling it in this method list is populated even if a reconnection occurs.
	foreach ($hw in $hwsList) {
	$AddNewHardwareDropDownBox.Items.Add($hw)
	}
	$typeList=@("E1000","VMXNET3", "E1000E")
	foreach ($types in $typeList) {
	$adapterTypeDropDownBox.Items.Add($types)
	}
	}
	catch{
	$outputTextBox.text = "`nSomething went wrong getting VmConfigs!!"
	}
	}
	function setVmConfigs{
	try {
	$numVCpu = $numVCpuTextBox.Text -as [int] #Convert values to integer
	$memSizeGB = $memSizeGBTextBox.Text -as [int]
	$diskSizeGB = $diskSizeGBTextBox.Text -as [int]
	Get-VM -Name $VmDropDownBox.SelectedItem.ToString() | Set-VM -NumCpu $numVCpu -MemoryGB $memSizeGB -Confirm:$false
	if ($HardDiskDropDownBox.Text.Length -gt 0) {
	Get-HardDisk -VM $VmDropDownBox.SelectedItem.ToString() -Name $HardDiskDropDownBox.SelectedItem.ToString() | Set-HardDisk -CapacityGB $diskSizeGB -Confirm:$false
	}else {
	$outputTextBox.text = "`nTo change HardDisk size you must first select one virtual disk!!"
	}
	if (($NetworkAdapterDropDownBox.Text.Length -gt 0) -and ($NetworkNameDropDownBox.Text.Length -gt 0)) {
	if ($wolEnabled.Checked -eq $true){ #Set Wake On LAN
	$wol = $true
	}elseif($wolEnabled.Checked -eq $false){
	$wol = $false
	}
	if ($connectedEnabled.Checked -eq $true){ #Set Connected
	$connected = $true
	}elseif($connectedEnabled.Checked -eq $false){
	$connected = $false
	}
	#Set-NetworkAdapter -MacAddress $macAddressTextBox.Text
	Set-NetworkAdapter -NetworkAdapter (Get-NetworkAdapter -VM $VmDropDownBox.SelectedItem.ToString() -Name $NetworkAdapterDropDownBox.SelectedItem.ToString()) -NetworkName $NetworkNameDropDownBox.SelectedItem.ToString() -WakeOnLan $wol -Connected $connected -Confirm:$false
	}else {
	$outputTextBox.text = "`nTo change Network Adapter settings you must first select one!!"
	}
	getVmConfigs #Refresh data in Text Boxes
	}
	catch{
	$outputTextBox.text = "`nSomething went wrong setting VmConfigs!!"
	}
	}
	##################END FUNCTIONS
	[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Drawing")
	[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
	##################Main Form Definition
	$main_form = New-Object System.Windows.Forms.Form
	$main_form.Text = "Edit VM Hardware v10" #Form Title
	$main_form.Size = New-Object System.Drawing.Size(425,815)
	$main_form.StartPosition = "CenterScreen"
	$main_form.KeyPreview = $True
	$main_form.Add_KeyDown({if ($_.KeyCode -eq "Escape")
	{$main_form.Close()}})
	##################GroupBox Definition
	$groupBox1 = New-Object System.Windows.Forms.GroupBox
	$groupBox1.Location = New-Object System.Drawing.Size(10,5)
	$groupBox1.size = New-Object System.Drawing.Size(190,200) #Width, Heigth
	$groupBox1.text = "Connect to vCenter or ESXi host:"
	$main_form.Controls.Add($groupBox1)
	$groupBox2 = New-Object System.Windows.Forms.GroupBox
	$groupBox2.Location = New-Object System.Drawing.Size(10,215)
	$groupBox2.size = New-Object System.Drawing.Size(390,60) #Width, Heigth
	$groupBox2.text = "Hosts Operations:"
	$main_form.Controls.Add($groupBox2)
	$groupBox3 = New-Object System.Windows.Forms.GroupBox
	$groupBox3.Location = New-Object System.Drawing.Size(10,285)
	$groupBox3.size = New-Object System.Drawing.Size(390,410) #Width, Heigth
	$groupBox3.text = "VMs Operations:"
	$main_form.Controls.Add($groupBox3)
	$groupBox4 = New-Object System.Windows.Forms.GroupBox
	$groupBox4.Location = New-Object System.Drawing.Size(10,700)
	$groupBox4.size = New-Object System.Drawing.Size(390,70) #Width, Heigth
	$groupBox4.text = "Output:"
	$main_form.Controls.Add($groupBox4)
	$groupBox5 = New-Object System.Windows.Forms.GroupBox
	$groupBox5.Location = New-Object System.Drawing.Size(210,5)
	$groupBox5.size = New-Object System.Drawing.Size(190,200) #Width, Heigth
	$groupBox5.text = "Instructions:"
	$main_form.Controls.Add($groupBox5)
	##################Label Definition
	$Label1 = New-Object System.Windows.Forms.Label
	$Label1.Location = New-Object System.Drawing.Point(10, 20)
	$Label1.Size = New-Object System.Drawing.Size(120, 14)
	$Label1.Text = "IP Address or FQDN:"
	$groupBox1.Controls.Add($Label1) #Member of GroupBox1
	$Label2 = New-Object System.Windows.Forms.Label
	$Label2.Location = New-Object System.Drawing.Point(10, 70)
	$Label2.Size = New-Object System.Drawing.Size(120, 14)
	$Label2.Text = "Username:"
	$groupBox1.Controls.Add($Label2) #Member of GroupBox1
	$Label3 = New-Object System.Windows.Forms.Label
	$Label3.Location = New-Object System.Drawing.Point(10, 120)
	$Label3.Size = New-Object System.Drawing.Size(120, 14)
	$Label3.Text = "Password:"
	$groupBox1.Controls.Add($Label3) #Member of GroupBox1
	$Label4 = New-Object System.Windows.Forms.Label
	$Label4.Location = New-Object System.Drawing.Point(10, 15)
	$Label4.Size = New-Object System.Drawing.Size(120, 14)
	$Label4.Text = "Select Host:"
	$groupBox2.Controls.Add($Label4) #Member of GroupBox2
	$Label5 = New-Object System.Windows.Forms.Label
	$Label5.Location = New-Object System.Drawing.Point(10, 15)
	$Label5.Size = New-Object System.Drawing.Size(120, 14)
	$Label5.Text = "Select VM:"
	$groupBox3.Controls.Add($Label5) #Member of GroupBox3
	$Label6 = New-Object System.Windows.Forms.Label
	$Label6.Location = New-Object System.Drawing.Point(10, 55)
	$Label6.Size = New-Object System.Drawing.Size(90, 14)
	$Label6.Text = "Num vCPU:"
	$groupBox3.Controls.Add($Label6) #Member of GroupBox3
	$Label7 = New-Object System.Windows.Forms.Label
	$Label7.Location = New-Object System.Drawing.Point(200, 55)
	$Label7.Size = New-Object System.Drawing.Size(160, 14)
	$Label7.Text = "Memory size in GB:"
	$groupBox3.Controls.Add($Label7) #Member of GroupBox3
	$Label8 = New-Object System.Windows.Forms.Label
	$Label8.Location = New-Object System.Drawing.Point(10, 95)
	$Label8.Size = New-Object System.Drawing.Size(80, 14)
	$Label8.Text = "Hard Disk:"
	$groupBox3.Controls.Add($Label8) #Member of GroupBox3
	$Label9 = New-Object System.Windows.Forms.Label
	$Label9.Location = New-Object System.Drawing.Point(10, 15)
	$Label9.Size = New-Object System.Drawing.Size(170, 180)
	$Label9.Text = "1)Connect to vCenter or ESXi host `r`n`r`n2)Select host and get v10 VMs `r`n`r`n3)Select VM `r`n`r`n4)Modify VM settings`r`n`r`n5)Apply Changes `r`n`r`n6)If needed add new hardware`r`n`r`n`Developed by @HostileCoding"
	$groupBox5.Controls.Add($Label9) #Member of GroupBox3
	$Label10 = New-Object System.Windows.Forms.Label
	$Label10.Location = New-Object System.Drawing.Point(200, 95)
	$Label10.Size = New-Object System.Drawing.Size(120, 14)
	$Label10.Text = "Hard Disk size in GB:"
	$groupBox3.Controls.Add($Label10) #Member of GroupBox3
	$Label11 = New-Object System.Windows.Forms.Label
	$Label11.Location = New-Object System.Drawing.Point(10, 135)
	$Label11.Size = New-Object System.Drawing.Size(120, 14)
	$Label11.Text = "Network Adapter:"
	$groupBox3.Controls.Add($Label11) #Member of GroupBox3
	$Label12 = New-Object System.Windows.Forms.Label
	$Label12.Location = New-Object System.Drawing.Point(200, 135)
	$Label12.Size = New-Object System.Drawing.Size(120, 14)
	$Label12.Text = "Network Name:"
	$groupBox3.Controls.Add($Label12) #Member of GroupBox3
	$Label13 = New-Object System.Windows.Forms.Label
	$Label13.Location = New-Object System.Drawing.Point(10, 175)
	$Label13.Size = New-Object System.Drawing.Size(120, 14)
	$Label13.Text = "MAC Address:"
	$groupBox3.Controls.Add($Label13) #Member of GroupBox3
	$Label14 = New-Object System.Windows.Forms.Label
	$Label14.Location = New-Object System.Drawing.Point(200, 175)
	$Label14.Size = New-Object System.Drawing.Size(40, 14)
	$Label14.Text = "Type:"
	$groupBox3.Controls.Add($Label14) #Member of GroupBox3
	$Label15 = New-Object System.Windows.Forms.Label
	$Label15.Location = New-Object System.Drawing.Point(240, 175)
	$Label15.Size = New-Object System.Drawing.Size(100, 14)
	$groupBox3.Controls.Add($Label15) #Member of GroupBox3
	$Label16 = New-Object System.Windows.Forms.Label
	$Label16.Location = New-Object System.Drawing.Point(10, 240)
	$Label16.Size = New-Object System.Drawing.Size(120, 14)
	$Label16.Text = "Add New Hardware:"
	$groupBox3.Controls.Add($Label16) #Member of GroupBox3
	$Label17 = New-Object System.Windows.Forms.Label
	$Label17.Location = New-Object System.Drawing.Point(10, 280)
	$Label17.Size = New-Object System.Drawing.Size(120, 14)
	$Label17.Text = "Hard Disk size in GB:"
	$groupBox3.Controls.Add($Label17) #Member of GroupBox3
	$Label18 = New-Object System.Windows.Forms.Label
	$Label18.Location = New-Object System.Drawing.Point(10, 320)
	$Label18.Size = New-Object System.Drawing.Size(120, 14)
	$Label18.Text = "Adapter Type:"
	$groupBox3.Controls.Add($Label18) #Member of GroupBox3
	$Label19 = New-Object System.Windows.Forms.Label
	$Label19.Location = New-Object System.Drawing.Point(200, 320)
	$Label19.Size = New-Object System.Drawing.Size(120, 14)
	$Label19.Text = "Network Label:"
	$groupBox3.Controls.Add($Label19) #Member of GroupBox3
	##################Button Definition
	$buttonConnect = New-Object System.Windows.Forms.Button
	$buttonConnect.add_click({connectServer})
	$buttonConnect.Text = "Connect"
	$buttonConnect.Top=170
	$buttonConnect.Left=10
	$groupBox1.Controls.Add($buttonConnect) #Member of GroupBox1
	$buttonDisconnect = New-Object System.Windows.Forms.Button
	$buttonDisconnect.add_click({disconnectServer})
	$buttonDisconnect.Text = "Disconnect"
	$buttonDisconnect.Top=170
	$buttonDisconnect.Left=100
	$buttonDisconnect.Enabled = $false #Disabled by default
	$groupBox1.Controls.Add($buttonDisconnect) #Member of GroupBox1
	$buttonvGetVms = New-Object System.Windows.Forms.Button
	$buttonvGetVms.Size = New-Object System.Drawing.Size(180,25)
	$buttonvGetVms.add_click({getVmsOnHost})
	$buttonvGetVms.Text = "Get VMs for selected Host"
	$buttonvGetVms.Left=200
	$buttonvGetVms.Top=25
	$groupBox2.Controls.Add($buttonvGetVms) #Member of GroupBox2
	$buttonSetVm = New-Object System.Windows.Forms.Button
	$buttonSetVm.Size = New-Object System.Drawing.Size(370,20)
	$buttonSetVm.add_click({setVmConfigs})
	$buttonSetVm.Text = "Apply Changes"
	$buttonSetVm.Left=10
	$buttonSetVm.Top=215
	$buttonSetVm.Enabled = $false #Disabled by default
	$groupBox3.Controls.Add($buttonSetVm) #Member of GroupBox3
	$buttonAddHardware = New-Object System.Windows.Forms.Button
	$buttonAddHardware.Size = New-Object System.Drawing.Size(370,20)
	$buttonAddHardware.add_click({getAddNewHardware})
	$buttonAddHardware.Text = "Add Hardware"
	$buttonAddHardware.Left=10
	$buttonAddHardware.Top=380
	$buttonAddHardware.Enabled = $false #Disabled by default
	$groupBox3.Controls.Add($buttonAddHardware) #Member of GroupBox3
	##################CheckBox Definition
	$wolEnabled = New-Object System.Windows.Forms.checkbox
	$wolEnabled.Location = New-Object System.Drawing.Size(200, 190)
	$wolEnabled.Size = New-Object System.Drawing.Size(100,20)
	$wolEnabled.Enabled = $false
	$wolEnabled.Checked = $false
	$wolEnabled.Text = "Wake on LAN"
	$groupBox3.Controls.Add($wolEnabled) #Member of GroupBox3
	$connectedEnabled = New-Object System.Windows.Forms.checkbox
	$connectedEnabled.Location = New-Object System.Drawing.Size(300, 190)
	$connectedEnabled.Size = New-Object System.Drawing.Size(80,20)
	$connectedEnabled.Enabled = $false
	$connectedEnabled.Checked = $false
	$connectedEnabled.Text = "Connected"
	$groupBox3.Controls.Add($connectedEnabled) #Member of GroupBox3
	$independentEnabled = New-Object System.Windows.Forms.checkbox
	$independentEnabled.Location = New-Object System.Drawing.Size(200, 280)
	$independentEnabled.Size = New-Object System.Drawing.Size(150,20)
	$independentEnabled.Enabled = $false
	$independentEnabled.Checked = $false
	$independentEnabled.Text = "Independent"
	$groupBox3.Controls.Add($independentEnabled) #Member of GroupBox3
	$independentEnabled.Add_CheckStateChanged({ #Checkbox Enabled
	if ($independentEnabled.Checked) {
	$persistentRadioButton.Enabled = $true
	$nonPersistentRadioButton.Enabled = $true
	}else{
	$persistentRadioButton.Enabled = $false
	$nonPersistentRadioButton.Enabled = $false
	}
	})
	$connectedAtPoweron = New-Object System.Windows.Forms.checkbox
	$connectedAtPoweron.Location = New-Object System.Drawing.Size(10, 360)
	$connectedAtPoweron.Size = New-Object System.Drawing.Size(150,20)
	$connectedAtPoweron.Enabled = $false
	$connectedAtPoweron.Checked = $false
	$connectedAtPoweron.Text = "Connect at poweron"
	$groupBox3.Controls.Add($connectedAtPoweron) #Member of GroupBox3
	##################RadioButton Definition
	$persistentRadioButton = New-Object System.Windows.Forms.RadioButton
	$persistentRadioButton.Location = new-object System.Drawing.Point(200,300)
	$persistentRadioButton.size = New-Object System.Drawing.Size(80,20)
	$persistentRadioButton.Checked = $true
	$persistentRadioButton.Enabled = $false
	$persistentRadioButton.Text = "Persistent"
	$groupBox3.Controls.Add($persistentRadioButton)
	$nonPersistentRadioButton = New-Object System.Windows.Forms.RadioButton
	$nonPersistentRadioButton.Location = new-object System.Drawing.Point(280,300)
	$nonPersistentRadioButton.size = New-Object System.Drawing.Size(100,20)
	$nonPersistentRadioButton.Checked = $false
	$nonPersistentRadioButton.Enabled = $false
	$nonPersistentRadioButton.Text = "Non Persistent"
	$groupBox3.Controls.Add($nonPersistentRadioButton)
	##################TextBox Definition
	$serverTextBox = New-Object System.Windows.Forms.TextBox
	$serverTextBox.Location = New-Object System.Drawing.Size(10,40) #Left, Top, Right, Bottom
	$serverTextBox.Size = New-Object System.Drawing.Size(165,20)
	$groupBox1.Controls.Add($serverTextBox) #Member of GroupBox1
	$usernameTextBox = New-Object System.Windows.Forms.TextBox
	$usernameTextBox.Location = New-Object System.Drawing.Size(10,90)
	$usernameTextBox.Size = New-Object System.Drawing.Size(165,20)
	$groupBox1.Controls.Add($usernameTextBox) #Member of GroupBox1
	$passwordTextBox = New-Object System.Windows.Forms.MaskedTextBox #Password TextBox
	$passwordTextBox.PasswordChar = '*'
	$passwordTextBox.Location = New-Object System.Drawing.Size(10,140)
	$passwordTextBox.Size = New-Object System.Drawing.Size(165,20)
	$groupBox1.Controls.Add($passwordTextBox) #Member of GroupBox1
	$numVCpuTextBox = New-Object System.Windows.Forms.TextBox
	$numVCpuTextBox.Location = New-Object System.Drawing.Size(10,70)
	$numVCpuTextBox.Size = New-Object System.Drawing.Size(180,20)
	$numVCpuTextBox.Enabled=$false
	$groupBox3.Controls.Add($numVCpuTextBox) #Member of GroupBox3
	$memSizeGBTextBox = New-Object System.Windows.Forms.TextBox
	$memSizeGBTextBox.Location = New-Object System.Drawing.Size(200,70)
	$memSizeGBTextBox.Size = New-Object System.Drawing.Size(180,20)
	$memSizeGBTextBox.Enabled=$false
	$groupBox3.Controls.Add($memSizeGBTextBox) #Member of GroupBox3
	$diskSizeGBTextBox = New-Object System.Windows.Forms.TextBox
	$diskSizeGBTextBox.Location = New-Object System.Drawing.Size(200,110)
	$diskSizeGBTextBox.Size = New-Object System.Drawing.Size(180,20)
	$diskSizeGBTextBox.Enabled=$false
	$groupBox3.Controls.Add($diskSizeGBTextBox) #Member of GroupBox3
	$macAddressTextBox = New-Object System.Windows.Forms.TextBox
	$macAddressTextBox.Location = New-Object System.Drawing.Size(10,190)
	$macAddressTextBox.Size = New-Object System.Drawing.Size(180,20)
	$macAddressTextBox.Enabled=$false
	$groupBox3.Controls.Add($macAddressTextBox) #Member of GroupBox3
	$newDiskSizeGBTextBox = New-Object System.Windows.Forms.TextBox
	$newDiskSizeGBTextBox.Location = New-Object System.Drawing.Size(10,295)
	$newDiskSizeGBTextBox.Size = New-Object System.Drawing.Size(180,20)
	$newDiskSizeGBTextBox.Enabled=$false
	$groupBox3.Controls.Add($newDiskSizeGBTextBox) #Member of GroupBox3
	$outputTextBox = New-Object System.Windows.Forms.TextBox
	$outputTextBox.Location = New-Object System.Drawing.Size(10,20)
	$outputTextBox.Size = New-Object System.Drawing.Size(370,40)
	$outputTextBox.MultiLine = $True
	$outputTextBox.ReadOnly = $True
	$outputTextBox.ScrollBars = "Vertical"
	$groupBox4.Controls.Add($outputTextBox) #Member of groupBox4
	##################DropDownBox Definition
	$VmDropDownBox = New-Object System.Windows.Forms.ComboBox
	$VmDropDownBox.DropDownStyle = [System.Windows.Forms.ComboBoxStyle]::DropDownList #Disable user input in ComboBox
	$VmDropDownBox.Location = New-Object System.Drawing.Size(10,30)
	$VmDropDownBox.Size = New-Object System.Drawing.Size(370,20)
	$VmDropDownBox.DropDownHeight = 200
	$VmDropDownBox.Enabled=$false
	$groupBox3.Controls.Add($VmDropDownBox)
	$handler_VmDropDownBox_SelectedIndexChanged={ #DropDownBox SelectedIndexChanged Handler
	try{
	if ($VmDropDownBox.Text.Length -gt 0) {
	getVmConfigs
	}
	}catch{
	}
	}
	$VmDropDownBox.add_SelectedIndexChanged($handler_VmDropDownBox_SelectedIndexChanged)
	$HostDropDownBox = New-Object System.Windows.Forms.ComboBox
	$HostDropDownBox.DropDownStyle = [System.Windows.Forms.ComboBoxStyle]::DropDownList #Disable user input in ComboBox
	$HostDropDownBox.Location = New-Object System.Drawing.Size(10,30)
	$HostDropDownBox.Size = New-Object System.Drawing.Size(180,20)
	$HostDropDownBox.DropDownHeight = 200
	$HostDropDownBox.Enabled=$false
	$groupBox2.Controls.Add($HostDropDownBox)
	$HardDiskDropDownBox = New-Object System.Windows.Forms.ComboBox
	$HardDiskDropDownBox.DropDownStyle = [System.Windows.Forms.ComboBoxStyle]::DropDownList #Disable user input in ComboBox
	$HardDiskDropDownBox.Location = New-Object System.Drawing.Size(10,110)
	$HardDiskDropDownBox.Size = New-Object System.Drawing.Size(180,20)
	$HardDiskDropDownBox.DropDownHeight = 200
	$HardDiskDropDownBox.Enabled=$false
	$groupBox3.Controls.Add($HardDiskDropDownBox)
	$handler_HardDiskDropDownBox_SelectedIndexChanged={ #DropDownBox SelectedIndexChanged Handler
	try{
	if ($HardDiskDropDownBox.Text.Length -gt 0) {
	getSelectedDiskSize
	}
	}catch{
	}
	}
	$HardDiskDropDownBox.add_SelectedIndexChanged($handler_HardDiskDropDownBox_SelectedIndexChanged)
	$NetworkAdapterDropDownBox = New-Object System.Windows.Forms.ComboBox
	$NetworkAdapterDropDownBox.DropDownStyle = [System.Windows.Forms.ComboBoxStyle]::DropDownList #Disable user input in ComboBox
	$NetworkAdapterDropDownBox.Location = New-Object System.Drawing.Size(10,150)
	$NetworkAdapterDropDownBox.Size = New-Object System.Drawing.Size(180,20)
	$NetworkAdapterDropDownBox.DropDownHeight = 200
	$NetworkAdapterDropDownBox.Enabled=$false
	$groupBox3.Controls.Add($NetworkAdapterDropDownBox)
	$handler_NetworkAdapterDropDownBox_SelectedIndexChanged={ #DropDownBox SelectedIndexChanged Handler
	try{
	if ($NetworkAdapterDropDownBox.Text.Length -gt 0) {
	getSelectedNetworkName
	}
	}catch{
	}
	}
	$NetworkAdapterDropDownBox.add_SelectedIndexChanged($handler_NetworkAdapterDropDownBox_SelectedIndexChanged)
	$NetworkNameDropDownBox = New-Object System.Windows.Forms.ComboBox
	$NetworkNameDropDownBox.DropDownStyle = [System.Windows.Forms.ComboBoxStyle]::DropDownList #Disable user input in ComboBox
	$NetworkNameDropDownBox.Location = New-Object System.Drawing.Size(200,150)
	$NetworkNameDropDownBox.Size = New-Object System.Drawing.Size(180,20)
	$NetworkNameDropDownBox.DropDownHeight = 200
	$NetworkNameDropDownBox.Enabled=$false
	$groupBox3.Controls.Add($NetworkNameDropDownBox)
	$AddNewHardwareDropDownBox = New-Object System.Windows.Forms.ComboBox
	$AddNewHardwareDropDownBox.DropDownStyle = [System.Windows.Forms.ComboBoxStyle]::DropDownList #Disable user input in ComboBox
	$AddNewHardwareDropDownBox.Location = New-Object System.Drawing.Size(10,255)
	$AddNewHardwareDropDownBox.Size = New-Object System.Drawing.Size(370,20)
	$AddNewHardwareDropDownBox.DropDownHeight = 200
	$AddNewHardwareDropDownBox.Enabled=$false
	$groupBox3.Controls.Add($AddNewHardwareDropDownBox)
	$handler_AddNewHardwareDropDownBox_SelectedIndexChanged={ #DropDownBox SelectedIndexChanged Handler
	try{
	if ($AddNewHardwareDropDownBox.Text.Length -gt 0) {
	$buttonAddHardware.Enabled = $true
	if ($AddNewHardwareDropDownBox.SelectedItem.ToString() -match "Hard Disk") {
	$newDiskSizeGBTextBox.Enabled = $true #Enable components
	$independentEnabled.Enabled = $true
	$connectedAtPoweron.Enabled = $false #Disable components
	$adapterTypeDropDownBox.Enabled = $false
	$networkLabelDropDownBox.Enabled = $false
	}
	elseif($AddNewHardwareDropDownBox.SelectedItem.ToString() -match "Network Adapter"){
	$connectedAtPoweron.Enabled = $true #Enable components
	$adapterTypeDropDownBox.Enabled = $true
	$networkLabelDropDownBox.Enabled = $true
	$newDiskSizeGBTextBox.Enabled = $false #Disable components
	$independentEnabled.Enabled = $false
	$persistentRadioButton.Enabled = $false
	$nonPersistentRadioButton.Enabled = $false
	$adapterTypeDropDownBox.Items.Clear() #Clear DropDown Box since it could be dirtied
	$typeList=@("E1000","VMXNET3", "E1000E")
	foreach ($types in $typeList) {
	$adapterTypeDropDownBox.Items.Add($types)
	}
	}
	}
	}catch{
	}
	}
	$AddNewHardwareDropDownBox.add_SelectedIndexChanged($handler_AddNewHardwareDropDownBox_SelectedIndexChanged)
	$adapterTypeDropDownBox = New-Object System.Windows.Forms.ComboBox
	$adapterTypeDropDownBox.DropDownStyle = [System.Windows.Forms.ComboBoxStyle]::DropDownList #Disable user input in ComboBox
	$adapterTypeDropDownBox.Location = New-Object System.Drawing.Size(10,335)
	$adapterTypeDropDownBox.Size = New-Object System.Drawing.Size(180,20)
	$adapterTypeDropDownBox.DropDownHeight = 200
	$adapterTypeDropDownBox.Enabled=$false
	$groupBox3.Controls.Add($adapterTypeDropDownBox)
	$networkLabelDropDownBox = New-Object System.Windows.Forms.ComboBox
	$networkLabelDropDownBox.DropDownStyle = [System.Windows.Forms.ComboBoxStyle]::DropDownList #Disable user input in ComboBox
	$networkLabelDropDownBox.Location = New-Object System.Drawing.Size(200,335)
	$networkLabelDropDownBox.Size = New-Object System.Drawing.Size(180,20)
	$networkLabelDropDownBox.DropDownHeight = 200
	$networkLabelDropDownBox.Enabled=$false
	$groupBox3.Controls.Add($networkLabelDropDownBox)
	##################Show Form
	$main_form.Add_Shown({$main_form.Activate()})
	[void] $main_form.ShowDialog()

view raw Edit hw v10 VMs.ps1 hosted with ❤ by GitHub

That's all!!

VMware: Fancy HTML reports using PowerCLI

In today's blog post how to create fancy HTML reports using PowerCLI. Sysadmins are well known to be data nerds, they like to constantly monitor all datacenter parameters, either using real time stats monitoring solutions, like VMware vCenter Operations, either producing periodical reports to analyze changes that occurrs in the virtual infrastructure.

Reports must be functional and readable, but if you are not the only one consuming these reports why not to make them look good too?

Fancy reports can be generated using PowerCLI - actually the capability is provided by PowerShell - by using the ConvertTo-Html cmdlet which generates an HTML output.

The trick to generate these good looking reports is to consider them as a webpage, that will be generated by script, to which a Cascading Style Sheet (CSS) will be applied.

Page is composed by an header, a CSS and a body. CSS part is the most important for our purpose because it will describe how output will be styled. Body section of the page will contain correct div IDs assignation and all statistics composing our report and in this example I get infos regarding Datacenter, Cluster and VMs. Of course you can include in the report whatever you want.

This is the expected result:

Here's the code. As usual I've uplaoded it to my GitHub page: Fancy Reports.ps1

	#Variable declaration
	$vCenterIPorFQDN="10.0.1.210"
	$vCenterUsername="Administrator@vsphere.local"
	$vCenterPassword="vmware"
	$LocationName="Datacenter" #This could be: Datacenter Name, Cluster Name, Host Name
	$ClusterName="TestCluster" #Name of the Cluster on which you need to run the report
	$OutputPath="C:\" #Location where you want to place generated report
	Write-Host "Connecting to vCenter" -foregroundcolor "magenta"
	Connect-VIServer -Server $vCenterIPorFQDN -User $vCenterUsername -Password $vCenterPassword
	#This is the CSS used to add the style to the report
	$Css="<style>
	body {
	font-family: Verdana, sans-serif;
	font-size: 14px;
	color: #666666;
	background: #FEFEFE;
	}
	#title{
	color:#90B800;
	font-size: 30px;
	font-weight: bold;
	padding-top:25px;
	margin-left:35px;
	height: 50px;
	}
	#subtitle{
	font-size: 11px;
	margin-left:35px;
	}
	#main {
	position:relative;
	padding-top:10px;
	padding-left:10px;
	padding-bottom:10px;
	padding-right:10px;
	}
	#box1{
	position:absolute;
	background: #F8F8F8;
	border: 1px solid #DCDCDC;
	margin-left:10px;
	padding-top:10px;
	padding-left:10px;
	padding-bottom:10px;
	padding-right:10px;
	}
	#boxheader{
	font-family: Arial, sans-serif;
	padding: 5px 20px;
	position: relative;
	z-index: 20;
	display: block;
	height: 30px;
	color: #777;
	text-shadow: 1px 1px 1px rgba(255,255,255,0.8);
	line-height: 33px;
	font-size: 19px;
	background: #fff;
	background: -moz-linear-gradient(top, #ffffff 1%, #eaeaea 100%);
	background: -webkit-gradient(linear, left top, left bottom, color-stop(1%,#ffffff), color-stop(100%,#eaeaea));
	background: -webkit-linear-gradient(top, #ffffff 1%,#eaeaea 100%);
	background: -o-linear-gradient(top, #ffffff 1%,#eaeaea 100%);
	background: -ms-linear-gradient(top, #ffffff 1%,#eaeaea 100%);
	background: linear-gradient(top, #ffffff 1%,#eaeaea 100%);
	filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#ffffff', endColorstr='#eaeaea',GradientType=0 );
	box-shadow:
	0px 0px 0px 1px rgba(155,155,155,0.3),
	1px 0px 0px 0px rgba(255,255,255,0.9) inset,
	0px 2px 2px rgba(0,0,0,0.1);
	}
	table{
	width:100%;
	border-collapse:collapse;
	}
	table td, table th {
	border:1px solid #98bf21;
	padding:3px 7px 2px 7px;
	}
	table th {
	text-align:left;
	padding-top:5px;
	padding-bottom:4px;
	background-color:#90B800;
	color:#fff;
	}
	table tr.alt td {
	color:#000;
	background-color:#EAF2D3;
	}
	</style>"
	#These are divs declarations used to properly style HTML using previously defined CSS
	$PageBoxOpener="<div id='box1'>"
	$ReportVmHost="<div id='boxheader'>Get-VMHost $LocationName</div>"
	$BoxContentOpener="<div id='boxcontent'>"
	$PageBoxCloser="</div>"
	$br="<br>" #This should have been defined in CSS but if you need new line you could also use it this way
	$ReportGetCluster="<div id='boxheader'>Get-Cluster $ClusterName</div>"
	$ReportGetVmCluster="<div id='boxheader'>Get-VM $ClusterName</div>"
	#Get VMHost infos
	$VmHost=Get-VMHost -Location $LocationName | Select-Object @{Name = 'Host'; Expression = {$_.Name}},State,ConnectionState,PowerState,Model,Version,Build,NumCpu,@{Name = 'CpuTotalGhz'; Expression = {"{0:N2}" -f ($_.CpuTotalMhz/1000)}},@{Name = 'CpuUsageGhz'; Expression = {"{0:N2}" -f ($_.CpuUsageMhz/1000)}},@{Name = 'MemoryTotalGB'; Expression = {"{0:N2}" -f $_.MemoryTotalGB}}, @{Name = 'MemoryUsageGB'; Expression = {"{0:N2}" -f $_.MemoryUsageGB}} | ConvertTo-HTML -Fragment
	#Get Cluster infos
	$GetCluster=Get-Cluster -Name $ClusterName | Select-Object Name, HAEnabled, HAIsolationResponse,@{Name = 'DRS Enabled'; Expression = {$_.DrsEnabled}},@{Name = 'DRS'; Expression = {$_.DrsAutomationLevel}},VsanEnabled,VsanDiskClaimMode | ConvertTo-HTML -Fragment
	#Get VM infos
	$GetVmCluster=Get-VM -Location (Get-Cluster -Name $ClusterName) | Select-Object Name,PowerState,NumCPU, MemoryGB | Sort-Object Name | ConvertTo-HTML -Fragment
	#Create HTML report
	#-Head parameter could be omitted if header is declared in body
	ConvertTo-Html -Title "Test Title" -Head "<div id='title'>PowerCLI Reporting</div>$br<div id='subtitle'>Report generated: $(Get-Date)</div>
	" -Body " $Css $PageBoxOpener $ReportVmHost $BoxContentOpener $VmHost $PageBoxCloser $br $ReportGetCluster $BoxContentOpener $GetCluster $PageBoxCloser $br $ReportGetVmCluster $BoxContentOpener $GetVmCluster $PageBoxCloser
	" | Out-File $OutputPath\Report.html

view raw Fancy Reports.ps1 hosted with ❤ by GitHub

$PageBoxOpener, $ReportVmHost, $BoxContentOpener, etc. variables are used to delimit the divs upon which CSS style will be applied.

To better understand how this works the schema of the page generated by the script above can be represented as:

 <div id='title'>  
      PowerCLI Reporting  
 </div>  
 <div id='subtitle'>  
      Report generated: $(Get-Date)  
 </div>  
 <div id='box1'> #Box Delimiting Report  
      <div id='boxheader'> #First Report Header  
           Get-VMHost $LocationName  
      </div>  
      <div id='boxcontent'> #First Report Table  
           Get-VMHost ...  
      </div>  
      <div id='boxheader'>  
           Get-Cluster $ClusterName  
      </div>  
      <div id='boxcontent'>  
           Get-VMHost ...  
      </div>  
      <div id='boxheader'>  
           Get-VM $ClusterName  
      </div>  
      <div id='boxcontent'>  
           Get-VMHost ...  
      </div>  
 </div>  

That's all!!

PowerCLI: Automate Oracle DB install using Invoke-VMScript

I only recently discovered how cool and powerful is Invoke-VMScript, a VMware PowerCLI cmdlet that allows you to run scripts inside the guest VM operating system.
It requires VMware Tools installed and running inside the guest OS in order to successfully inject commands and scripts from the ESXi host to the VM and it is noteworthy to say that not all operating systems are supported by Invoke-VMScript cmdlet.
Supported ones, according to official documentation, are: Windows XP 32bit SP3, Windows Server 2003 32bit SP2, Windows Server 2003 64bit SP2, Windows 7 64bit, Windows Server 2008 R2 64bit and RHEL 5.

Invoke-VMScript syntax is:

Invoke-VMScript [-ScriptText] <String> [-VM] <VirtualMachine[]> [-HostCredential <PSCredential>] [-HostUser <String>] [-HostPassword <SecureString>] [-GuestCredential <PSCredential>] [-GuestUser <String>] [-GuestPassword <SecureString>] [-ToolsWaitSecs <Int32>] [-ScriptType <ScriptType>] [-RunAsync] [-Server <VIServer[]>] [-WhatIf] [-Confirm] [<CommonParameters>]

Where:

HostCredential: username and password for the ESXi host on which resides the virtual machine.
GuestCredential: username and password for the guest OS. The user must have administrative access.
ScriptType: what kind of script you want to invoke: PowerShell, Bat or Bash.

In this article I provide a simple PowerCLI script which allows you to deploy virtual machines from a Win2008 R2 template and perform an automated silent install of Oracle Database 11g R2.

This is just an example of Invoke-VMScript usage and this only provides a software install, neither listener neither instance are configured. This script could also be readapted/improved for RHEL installs.

How this script works:

-Connects to a vCenter or ESXi host.
-Deploys "N" virtual machines from a properly prepared (read a few lines below to find how) Win2008 template.
-Power on the virtual machine.
-Perform a silent, fully automated, install of Oracle Database 11g R2 software by using Invoke-VMScript cmdlet.

Preprequisite for this PowerCLI script are:

-A Windows 2008 R2 virtual machine
-Oracle Database 11g R2 11.2.0.X. Unzip installation files on the Desktop. This script assumes that your installation directory is placed on: C:\Users\Administrator\Desktop\database
-Response file: a response file is a text file which is used by Oracle to perform silent installs. It contains all infos that usually are inserted by the user in a common GUI installation. This script assumes that your response file is: C:\Users\Administrator\Desktop\install.rsp

This is the content of my install.rsp response file.

 oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0  
 oracle.install.option=INSTALL_DB_SWONLY  
 UNIX_GROUP_NAME=oinstall  
 INVENTORY_LOCATION=C:\Program Files\Oracle\Inventory\logs  
 ORACLE_HOME=C:\app\Administrator\product\11.2.0\dbhome_1  
 ORACLE_BASE=C:\app\Administrator  
 oracle.install.db.InstallEdition=EE  
 oracle.install.db.isCustomInstall=false  
 oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0  
 oracle.install.db.DBA_GROUP=dba  
 oracle.install.db.OPER_GROUP=dba  
 SECURITY_UPDATES_VIA_MYORACLESUPPORT=false  
 DECLINE_SECURITY_UPDATES=true  

So, to recap: unzip Oracle DB installation files on the Desktop and place install.rsp in the same location as depicted by the following image.

This is the PowerCLI code, as usual you can also find it on my GitHub repository: Invoking Scripts in Guest-VM.ps1

	#Variable declaration
	$vCenterIPorFQDN="10.0.1.210"
	$vCenterUsername="Administrator@vsphere.local"
	$vCenterPassword="vmware"
	$ESXiHost="10.0.1.62"
	$NumberOfVmToDeploy=2 #How many VM deploy from template
	$OracleTemplate="OraTemplate"
	$DestinationDatastore="datastore1"
	$ESXiHostUsername="root" #ESXi Host username
	$ESXiHostPassword="mypassword" #ESXi Host password
	$GuestVmUsername="local\Administrator" #Guest VM username
	$GuestVmPassword="MyGuestVmPassword" #Guest VM password
	$ScriptContent="C:\Users\Administrator\Desktop\database\setup.exe -silent -noconfig -responseFile C:\Users\Administrator\Desktop\install.rsp" #Command to run inside Guest VM
	Write-Host "Connecting to vCenter" -foregroundcolor "magenta"
	Connect-VIServer -Server $vCenterIPorFQDN -User $vCenterUsername -Password $vCenterPassword
	1..$NumberOfVmToDeploy | Foreach {
	Write-Host "Creating" OracleDB$_ "VM" -foregroundcolor "magenta"
	New-VM -VMHost (Get-VMHost -Name $ESXiHost) -Name OracleDB$_ -Template $OracleTemplate -Datastore $DestinationDatastore | Start-VM
	Write-Host "Waiting 90 seconds in order to finish VM poweron" -foregroundcolor "magenta"
	Start-Sleep -s 90
	Write-Host "Calling setup.exe inside guest VM in order to perform an Oracle Database silent install" -foregroundcolor "magenta"
	Invoke-VMScript -VM OracleDB$_ -HostUser $ESXiHostUsername -HostPassword $ESXiHostPassword -GuestUser $GuestVmUsername -GuestPassword $GuestVmPassword -ScriptType bat -ScriptText $ScriptContent
	}

view raw Invoking Scripts in Guest-VM.ps1 hosted with ❤ by GitHub

Run it and deployment of virtual machines from template begins:

After script completion VMs are correctly added to vCenter Server inventory

and Oracle Database is installed inside guest OS.

To perform a full install of Oracle Database the listener and an instance must also be configured. This can be done using a response file and run using PowerCLI Invoke-VMScript.

If you need a standard listener configuration netca.rsp file provided in database\response installation directory does the job.

Listener silent install is performed by running:

 netca -silent -responseFile C:\Users\Administrator\Desktop\database\response\netca.rsp  

Similarly database instance can be added by invoking the Database Configuration Assistant (dbca) in silent install mode using a response file or passing all required configurations as parameters.

For example:

 dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname orcl -sid orcl -gdbName orcl -memoryPercentage 30 -sysPassword welcome1 -systemPassword welcome1 -dbsnmppassword welcome1 -emConfiguration LOCAL -redoLogFileSize 100 -storageType FS -datafileDestination C:\app\Administrator\oradata -datafileJarLocation C:\app\Administrator\product\11.2.0\dbhome_1\assistants\dbca\templates -characterSet AL32UTF8 -sampleSchema false -totalMemory 512  

That's all!!