How to find SPECint2006 Rates value for all esxi host

[meistermn]

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 .

[meistermn]

Here is an expample for one of my farms :  I did this manual.

Processortyp	Number of Servers	Single Specint per Server	Total Secint
AMD Opteron(tm) Processor 6174	6	782	4692
AMD Opteron(TM) Processor 6276	2	973	1946
Dual-Core AMD Opteron(tm) Processor 2218	1	50.3	50.3
Intel(R) Xeon(R) CPU           E5405  @ 2.00GHz	1	108	108
Intel(R) Xeon(R) CPU           X5560  @ 2.80GHz	18	280	5040
Intel(R) Xeon(R) CPU           X5570  @ 2.93GHz	14	266	3724
Intel(R) Xeon(R) CPU           X5670  @ 2.93GHz	6	358	2148
Intel(R) Xeon(R) CPU           X7560  @ 2.27GHz	8	834	6672
Intel(R) Xeon(R) CPU E5-2690 0 @ 2.90GHz	2	693	1386
Intel(R) Xeon(TM) CPU 3.20GHz	2		0
Quad-Core AMD Opteron(tm) Processor 2384	2	134	268
Quad-Core AMD Opteron(tm) Processor 8354	9	176	1584
Six-Core AMD Opteron(tm) Processor 2431	8	194	1552
Six-Core AMD Opteron(tm) Processor 8435	30	394	11820
Total	109		40990.3

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

PowerEdge R920 (Intel Xeon E7-4890 v2, 2.80 GHz)

2390

17.1507531

That is cooll

[meistermn]

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?