Processor Families or cpukey identifier

[neiroatopelcc]

Hi. Does anyone on the internet know how to interprit cpu family information or cpu identification numbers? Everything google returns is assembler jibberish.

For instance an sql query for two I5 computers returns the following: (edited to two lines)

And for the mobile processor a wmi call gives the following information:


PSComputerName : [removed]
Availability : 3
CpuStatus : 1
CurrentVoltage : 12
DeviceID : CPU0
ErrorCleared :
ErrorDescription :
LastErrorCode :
LoadPercentage : 15
Status : OK
StatusInfo : 3
AddressWidth : 64
DataWidth : 64
ExtClock : 100
L2CacheSize : 256
L2CacheSpeed :
MaxClockSpeed : 2295
PowerManagementSupported : False
ProcessorType : 3
Revision : 10759
SocketDesignation : CPU 1
Version :
VoltageCaps :
__GENUS : 2
__CLASS : Win32_Processor
__SUPERCLASS : CIM_Processor
__DYNASTY : CIM_ManagedSystemElement
__RELPATH : Win32_Processor.DeviceID="CPU0"
__PROPERTY_COUNT : 51
__DERIVATION : {CIM_Processor, CIM_LogicalDevice, CIM_LogicalElement, CIM_ManagedSystemEleme
nt}
__SERVER : [removed]
__NAMESPACE : root\cimv2
__PATH : \\[removed]\root\cimv2:Win32_Processor.DeviceID="CPU0"
Architecture : 9
Caption : Intel64 Family 6 Model 42 Stepping 7
ConfigManagerErrorCode :
ConfigManagerUserConfig :
CreationClassName : Win32_Processor
CurrentClockSpeed : 2295
Description : Intel64 Family 6 Model 42 Stepping 7
Family : 205
InstallDate :
L3CacheSize : 3
L3CacheSpeed : 0
Level : 6
Manufacturer : GenuineIntel
Name : Intel(R) Core(TM) i5-2410M CPU @ 2.30GHz
NumberOfCores : 2
NumberOfLogicalProcessors : 4
OtherFamilyDescription :
PNPDeviceID :
PowerManagementCapabilities :
ProcessorId : BFEBFBFF000206A7
Role : CPU
SecondLevelAddressTranslationExtensions : False
Stepping :
SystemCreationClassName : Win32_ComputerSystem
SystemName : [removed]
UniqueId :
UpgradeMethod : 4
VirtualizationFirmwareEnabled : False
VMMonitorModeExtensions : False
Scope : System.Management.ManagementScope
Path : \\[removed]\root\cimv2:Win32_Processor.DeviceID="CPU0"
Options : System.Management.ObjectGetOptions
ClassPath : \\[removed]\root\cimv2:Win32_Processor
Properties : {AddressWidth, Architecture, Availability, Caption...}
SystemProperties : {__GENUS, __CLASS, __SUPERCLASS, __DYNASTY...}
Qualifiers : {dynamic, Locale, provider, UUID}
Site :
Container :




I've tried googling 2410M along with the 205 family number reported with no luck, and with the 1703 cpukey with no luck.

I need to build a sql query to figure out which systems are of which hardware generation, and I wanted to use the cpu identification to do so (as opposed to filtering cpu model naming)

 

[neiroatopelcc]

As is mostly the case when I post here, I figured out out on my own.
It's a bit messy and I ignored AMD as we almost exclusively have Intel in the company.


sql code:
[cpp]SELECT v_GS_PROCESSOR.Name0,Count(v_GS_PROCESSOR.Name0) as 'Count'
,[ProcessorId0]=CASE
when substring(ProcessorId0,12,4)='306A' then 'IvyBridge'
when substring(ProcessorId0,12,4)='206A' then 'SandyBridge'
when substring(ProcessorId0,12,4)='206D' then 'SandyBridge-E/EN/EP'
when substring(ProcessorId0,12,4)='2065' then 'Arrandale/Clarksdale'
when substring(ProcessorId0,12,4)='206C' then 'Gulftown/Westmere-EP'
when substring(ProcessorId0,12,4)='206F' then 'Westmere-EX'
when substring(ProcessorId0,12,4)='106E' then 'Clarksfield/Lynnfield/Jasper Forest'
when substring(ProcessorId0,12,4)='106A' then 'Bloomfield/Nehalem-EP'
when substring(ProcessorId0,12,4)='206E' then 'Nehalem-EX'
when substring(ProcessorId0,12,4)='1067' then 'Yorkfield/Wolfdale/Penryn/Harpertown'
when substring(ProcessorId0,12,4)='106D' then 'Donnington'
when substring(ProcessorId0,12,4)='006F' then 'Clovertown/Kentsfield/Conroe/Merom/Woodcrest'
when substring(ProcessorId0,12,4)='1066' then 'Merom Conroe'
when substring(ProcessorId0,12,4)='0066' then 'Cedar Mill/Presler'
when substring(ProcessorId0,12,4)='0063' then 'Nocona'
when substring(ProcessorId0,12,4)='0064' then 'Irwindale/Prescott'
when substring(ProcessorId0,12,4)='006D' then 'Dothan'
when substring(ProcessorId0,12,4)='3066' then 'Cedarview'
when substring(ProcessorId0,12,4)='0266' then 'Lincroft'
when substring(ProcessorId0,12,4)='016C' then 'Pineview/Silverthorne'
when substring(ProcessorId0,12,4)='006C' then 'Undocumented Xeon 5000'
when substring(ProcessorId0,12,4)='00F2' then 'Northwood/Barnias/Prestonia/Gallatin'
when substring(ProcessorId0,12,4)='00F4' then 'Prescott/Paxville'
when substring(ProcessorId0,12,4)='106C' then 'Diamondville/Pineview/Silverthorne/Lincroft'
when substring(ProcessorId0,9,8)='00000000' then 'Unknown'
else 'Undocumented/AMD '+substring(ProcessorId0,9,8)
end,
[IsMobile0]


FROM v_GS_PROCESSOR

inner join v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_GS_PROCESSOR.ResourceID)

Where v_FullCollectionMembership.CollectionID = @CollectionID and v_GS_PROCESSOR.ResourceID not in (select v_GS_VIDEO_CONTROLLER.ResourceID from v_GS_VIDEO_CONTROLLER where v_GS_VIDEO_CONTROLLER.Name0 like '%virtual%')

group by v_GS_PROCESSOR.Name0
,v_GS_PROCESSOR.IsMobile0,v_GS_PROCESSOR.ProcessorID0

order by 'Count' desc[/cpp]

Basically I used http://software.intel.com/en-us/articles/intel-architecture-and-processor-identification-with-cpuid-model-and-family-numbers and the Table 5-4 from http://www.intel.com/content/dam/www/public/us/en/documents/application-notes/processor-identification-cpuid-instruction-note.pdf along with a bit of wikipedia and a calculator.

I'm sure the processor manufacturers coun't have made it much harder to figure out!

Edit: The query is work in progress. This was just to see if it actually works.