Another idea - smbios:
not support:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblBIOS.ReleaseDate,
tblBIOS.SMBIOSMajorVersion,
tblBIOS.SMBIOSMinorVersion,
Coalesce(tblBIOS.SMBIOSMajorVersion, 0) + 0.1 *
Coalesce(tblBIOS.SMBIOSMinorVersion, 0) As version,
tblProcessor.Name,
tblProcessor.SocketDesignation,
TsysMemorytypes.MemoryName
From tblBIOS
Inner Join tblAssets On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID And
tblProcessor.Name Not Like '%xeon%' And tblProcessor.Name Not Like '%amd%'
Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID
Inner Join TsysMemorytypes On tblPhysicalMemory.MemoryType =
TsysMemorytypes.Memorytype
Where Not ((Coalesce(tblBIOS.SMBIOSMajorVersion, 0) + 0.1 *
Coalesce(tblBIOS.SMBIOSMinorVersion, 0) > 2.5) Or
(Coalesce(tblBIOS.SMBIOSMajorVersion, 0) + 0.1 *
Coalesce(tblBIOS.SMBIOSMinorVersion, 0) In (2.4, 2.5) And
tblProcessor.SocketDesignation In ('Socket 1155', 'Socket 1156', 'LGA1366')))
support:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblBIOS.ReleaseDate,
tblBIOS.SMBIOSMajorVersion,
tblBIOS.SMBIOSMinorVersion,
Coalesce(tblBIOS.SMBIOSMajorVersion, 0) + 0.1 *
Coalesce(tblBIOS.SMBIOSMinorVersion, 0) As version,
tblProcessor.Name,
tblProcessor.SocketDesignation,
TsysMemorytypes.MemoryName
From tblBIOS
Inner Join tblAssets On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID And
tblProcessor.Name Not Like '%xeon%' And tblProcessor.Name Not Like '%amd%'
Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID
Inner Join TsysMemorytypes On tblPhysicalMemory.MemoryType =
TsysMemorytypes.Memorytype
Where ((Coalesce(tblBIOS.SMBIOSMajorVersion, 0) + 0.1 *
Coalesce(tblBIOS.SMBIOSMinorVersion, 0) > 2.5) Or
(Coalesce(tblBIOS.SMBIOSMajorVersion, 0) + 0.1 *
Coalesce(tblBIOS.SMBIOSMinorVersion, 0) In (2.4, 2.5) And
tblProcessor.SocketDesignation In ('Socket 1155', 'Socket 1156', 'LGA1366')))
Updated:
- Ignore xeon, amd
- add socket 1366
- No logics for Nehalem processors and Westmere processors (SSE4.1, SSE4.2 and POPCNT supported, except Pentium and Celeron). I think there is no Pentium-model for Nehalem.