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
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #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 |
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.
This is a great idea, thanks. I am new to this, so I have a question: do you put all of this code in a html file and run it or in a ps1 file and run it through powershell/powercli?
RispondiElimina