SCCM – SQL Query to List Amount of RAM per DIMM Slot

SCCM – Basic SQL query to report on  each memory slot in computer

Not flash, but it works 🙂 SCCM 2012 CB

select sys.netbios_name0, mem.banklabel0 [Bank Label], mem.capacity0 [Capacity in MB], mem.FormFactor0 [Form Factor],
MEM.memorytype0 [Memory Type], mem.tag0 [TAG] from v_gs_physical_memory as MEM
inner join v_r_system as SYS on SYS.resourceid=MEM.resourceid 
order by  sys.netbios_name0,mem.tag0