Windows 10 hardware readiness Query

select *,

CASE WHEN

(([CPU (GHz)] >=1 and version like '6.%') and

(([RAM (GB)] >=2 and Architecture = 'x64-based PC' and [System Disk Size (GB)] >=20)

or ([RAM (GB)] >=1 and Architecture = 'X86-based PC' and [System Disk Size (GB)] >=16))




)
THEN 'Yes' ELSE 'No' END AS [HW Ok for Windows 10]

from (SELECT distinct SYS.Netbios_Name0 as Name, Ops.Caption0 as OS, Ops.CSDVersion0 as SP,

LEFT(Ops.Version0,3) as Version,

ROUND(CONVERT(FLOAT,CPU.MaxClockSpeed0), -2)/1000 AS [CPU (GHz)],

ROUND(ROUND(CONVERT(FLOAT,MEM.TotalPhysicalMemory0) / 1048576, 2) , 1) AS [RAM (GB)],

CS.SystemType0 as Architecture,

LDISK.Size0/1024 AS [System Disk Size (GB)],

cs.model0,

MAX(VID.VideoModeDescription0) as [Screen resolution]

FROM v_R_System SYS LEFT JOIN v_GS_LOGICAL_DISK LDISK on SYS.ResourceID = LDISK.ResourceID

LEFT JOIN v_GS_COMPUTER_SYSTEM CS on SYS.ResourceID = CS.ResourceID

LEFT JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID

LEFT JOIN v_GS_Processor CPU on SYS.ResourceID = CPU.ResourceID

LEFT JOIN v_GS_VIDEO_CONTROLLER VID on SYS.ResourceID = VID.ResourceID

LEFT JOIN v_GS_OPERATING_SYSTEM Ops on SYS.ResourceID = Ops.ResourceID

WHERE (LDISK.DeviceID0 = 'C:' and SYS.Operating_System_Name_and0 not like 'Microsoft Windows NT%Server%')

Group by SYS.Netbios_Name0,Ops.Caption0,Ops.CSDVersion0,

Ops.Version0,CPU.MaxClockSpeed0,MEM.TotalPhysicalMemory0,CS.SystemType0,cs.model0,LDISK.Size0) as Assessment order by

10,1