Hello everyone,
I'm working as an operator and every month we have to manually export the performance data (CPU/Memory/Network) of all the esxi hosts of one of our client.
This takes around 4 hours for 18 hosts using the Export option of the vSphere's Performance tab.
That twice a month since usable data (2 hour interval ones) get erased every month.
So it goes like:
the 16th we collect from the 1st to the 15th of the current month
the 3rd we collect from the 16th to the last day of last month
Although I didn't have any skills in powershell I looked for a way to automate this nonsense.
After reading LucD notes and others I wrote that script which does the job, but I want this to be really good before showing it to my manager.
=================================Do that on the 16th==========================================
# Make Powercli executable through a poweshell shortcut
Add-PSSnapin VMware.VimAutomation.Core
# Launch PowerCli from Powershell
. 'C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1'
# Login to vCenter
Connect-VIServer <vCenterName> -User <UserName> -Password <PW>
# Set first day of current month
$FirstDayOfMonth = Get-Date -Day 1 -Hour 0 -Minute 0 -Second 0
# Set 15th day of current month
$FirstPartOfMonth = Get-Date -Day 15 -Hour 23 -Minute 59 -Second 59
# Set hosts
$Hosts = Get-VMHost
# Set current month
$ThisMonth = Get-Date -format yyMM
# Get all hosts data
$report = Get-Stat -Entity $Hosts -Stat 'cpu.usage.average','mem.vmmemctl.average','net.usage.average' -IntervalHours 2 -Start $FirstDayOfMonth -Finish $FirstPartOfMonth
# Export data to a csv file
$report | Export-Csv "C:$ThisMonth_Usage.csv" -NoTypeInformation -UseCulture
# Logoff of vCenter
Disconnect-VIServer -confirm:$false
=================================================================================================
=================================Do that on the 3rd==========================================
# Make Powercli executable through a poweshell shortcut
Add-PSSnapin VMware.VimAutomation.Core
# Launch PowerCli from Powershell
. 'C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1'
# Login to vCenter
Connect-VIServer <vCenterName> -User <UserName> -Password <PW>
# Set last month 16th
$SecondPartOfMonth = ((Get-Date -Day 01 -Hour 0 -Minute 0 -Second 0).AddMonths(-1)).AddDays(15)
# Set last month last day 23:59
$LastDayOfLastMonth = ((Get-Date -Day 01 -Hour 23 -Minute 59 -Second 59).AddDays(-1))
# Select hosts
$Hosts = Get-VMHost
# Select CSV file to be appended
$LastMonth = (Get-Date).AddMonths(-1) | Get-Date -format yyMM
# Get all data of all hosts
$report = Get-Stat -Entity $Hosts -Stat 'cpu.usage.average','mem.vmmemctl.average','net.usage.average' -IntervalHours 2 -Start $SecondPartOfMonth -Finish $LastDayOfLastMonth
# Append last month CSV file
$report | Export-Csv -Append "C:$LastMonth_Usage.csv" -NoTypeInformation -UseCulture
# Logoff of vCenter
Disconnect-VIServer -confirm:$false
=================================================================================================
The thing I can do now:
-Training though the great powercli lab (VMware Learning Platform )
I am now able to create a single CSV file of the needed performance of all the hosts
My final goal:
-Since it's for presentation purposes I want to create a CSV file for every single host and make a chart out of them using excel
-Make a comparison to last month performance data
What I'm thinking about but doesn't fit:
-I could do the following for every host, but when a new host will be implemented I'd need to add text to the script ... which is not really an efficient method
Get-Stat -Entity Get-VMHost -name esx01 -Stat 'cpu.usage.average','mem.vmmemctl.average','net.usage.average' -Start $FirstDayOfMonth -Finish $LastDayOfMonth |
Export-Csv "C:\esx01.csv" -NoTypeInformation -UseCulture
Get-Stat -Entity Get-VMHost -name esx02 -Stat 'cpu.usage.average','mem.vmmemctl.average','net.usage.average' -Start $FirstDayOfMonth -Finish $LastDayOfMonth |
Export-Csv "C:\esx02.csv" -NoTypeInformation -UseCulture
...
What I'm asking you guys:
-make a script that can export performances (average cpu usage, memory usage, network usage) of each host to different CSV files (One CSV file for each host).
-The trick is that the script would not need to be rewritten even if a new host get added.
From there I think I can make an excel macro able to create charts and compare data.
I hope you get the idea of all this,
I'm new to all this so feel free to make remarks/questions.
Sam
