Client Management Suite

 Looking for SQL or a report to show Windows 7 computers capable of upgrading to windows 10.  Below are the minimum specs from Microsoft.  

Creating a hardware report with the following values using report builder..
https://www.symantec.com/connect/forums/creating-hardware-report-following-values-using-report-builder

Check 'Inv_Hardware_Summary' for the values and just add a WHERE clause for your given criteria.

That table for me is empty :(

Which Agent Plugins do you have installed? Do you run the inventory task on machines?

Empty for me as well

I am not great at SQL as I am self taught.. but I think this may work for what you want.

Report to show you the targets...

--32bit requirements
Select t0.Name, t0.[System Type], t1.Name as 'Drive', t1.Description, t1.[Free Space (Bytes)]  / (1024 * 1024 * 1024) as [Disk Space Free (GB)] ,
 t2.[Total Physical Memory (Bytes)] / (1024 * 1024) as [RAM MB], t3.[Max Clock Speed (Mega-hertz)]
from Inv_AeX_AC_Identification t0
 left join inv_hw_logical_disk t1 on t0._ResourceGuid = t1._ResourceGuid
 left join vHWComputerSystem t2 on t0._ResourceGuid = t2._ResourceGuid
 left join vHWProcessor t3 on t0._resourceGuid = t3._resourceGuid
where t0.[OS Name] like '%7%' and t0.[System Type] in('Win32')
 and t1.Name in('C:') and t1.Description in('Local Fixed Disk') and t1.[Free Space (Bytes)] > 16000000000
 and t2.[Total Physical Memory (Bytes)] > 1000000000
 and t3.[Max Clock Speed (Mega-hertz)] > 1000
Union
--64bit requirements
Select t0.Name, t0.[System Type], t1.Name as 'Drive', t1.Description, t1.[Free Space (Bytes)]  / (1024 * 1024 * 1024) as [Disk Space Free (GB)] ,
 t2.[Total Physical Memory (Bytes)] / (1024 * 1024) as [RAM MB], t3.[Max Clock Speed (Mega-hertz)]
from Inv_AeX_AC_Identification t0
 left join inv_hw_logical_disk t1 on t0._ResourceGuid = t1._ResourceGuid
 left join vHWComputerSystem t2 on t0._ResourceGuid = t2._ResourceGuid
 left join vHWProcessor t3 on t0._resourceGuid = t3._resourceGuid
where t0.[OS Name] like '%7%' and t0.[System Type] in('Win32')
 and t1.Name in('C:') and t1.Description in('Local Fixed Disk') and t1.[Free Space (Bytes)] > 20000000000
 and t2.[Total Physical Memory (Bytes)] > 2000000000
 and t3.[Max Clock Speed (Mega-hertz)] > 1000
order by t0.Name


Filter for targets
You can change the 2 select lines to just

Select t0._ResourceGuid