How to find SPECint2006 Rates value for all esxi host ?
There is a Exchange Processor Query Tool - v1.1.xlsm file , where I can put the process typ in a field and get the specint for a server.
http://blogs.technet.com/b/exchange/archive/2012/04/30/3495285.aspx
Is there a powershell script which gets a list of the processors of all esxi host ?
I did it in a other way : Took rvtools and export the results to excel file.
Then Pivot Table to get the processors.
Now what to match the Exchange Processor Query Tool with pivot table.
Target is to get the specint rate of all esxi and compare to new Intel server with new specint rate .
Here is an expample for one of my farms : I did this manual.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Next what happens when I consolidate the 109 Servers to the new Dell 920 : I devided the 40990.3 specint rate 2006 through 2390 which means 17-18 Dell 17 servers
|
|
|
That is cooll
Found this powercli script to get esxi host cpu
<a href="http://jreypo.wordpress.com/2011/06/07/retrieving-esxi-hardware-info-with-powercli/">http://jreypo.wordpress.com/2011/06/07/retrieving-esxi-hardware-info-with-powercli/</a>
After opening the exchange processor query tool and switch to VBA
Three is following code.
'create and execute web query to spec.org site
With oSh.QueryTables.Add( _
"URL;http://www.spec.org/cgi-bin/osgresults?conf=rint2006&op=fetch&field=CPU&proj-BASE=0&proj-COPIES=0&proj-CPU_MHZ=256&pattern=[""System""]" _
, oSh.Range("$I$1"))
'get the parameter that defines the processor to query on from cell G13
With .Parameters(1)
.SetParam xlRange, oSh.Range("$G$32")
.RefreshOnChange = True
End With
Show to match this two code?