Physical Memory Query

Sherry Kissinger pointed out this query today that some of you might find interesting. It help you understand your Physical Memory within  each PC, you will need the sms_def.mof edit to capture this info.

 

SELECT
CS.Name0,
MEM.BankLabel0,
(mem.Capacity0/1048576) [Total in MB],
MEM.Caption0,
MEM.DeviceLocator0,
CASE MEM.FormFactor0
WHEN 0 THEN ‘unknown’
WHEN 1 THEN ‘Other’
WHEN 2 THEN ‘SIP’
WHEN 3 THEN ‘DIP’
WHEN 4 THEN ‘ZIP’
WHEN 5 THEN ‘SOJ’
WHEN 6 THEN ‘Proprietary’
WHEN 7 THEN ‘SIMM’
WHEN 8 THEN ‘DIMM’
WHEN 9 THEN ‘TSOP’
WHEN 10 THEN ‘PGA’
WHEN 11 THEN ‘RIMM’
WHEN 12 THEN ‘SODIMM’
WHEN 13 THEN ‘SRIMM’
WHEN 14 THEN ‘SMD’
WHEN 15 THEN ‘SSMP’
WHEN 16 THEN ‘QFP’
WHEN 17 THEN ‘TQFP’
WHEN 18 THEN ‘SOIC’
WHEN 19 THEN ‘LCC’
WHEN 20 THEN ‘PLCC’
WHEN 21 THEN ‘BGA’
WHEN 22 THEN ‘FPBGA’
WHEN 23 THEN ‘LGA’
ELSE ‘not defined’
END AS FormFactor,
CASE MEM.MemoryType0
WHEN 0 THEN ‘Unknown’
WHEN 1 THEN ‘Other’
WHEN 2 THEN ‘DRAM’
WHEN 3 THEN ‘Synchronus DRAM’
WHEN 4 THEN ‘Cache DRAM’
WHEN 5 THEN ‘EDO’
WHEN 6 THEN ‘EDRAM’
WHEN 7 THEN ‘VRAM’
WHEN 8 THEN ‘SRAM’
WHEN 9 THEN ‘RAM’
WHEN 10 THEN ‘ROM’
WHEN 11 THEN ‘Flash’
WHEN 12 THEN ‘EEPROM’
WHEN 13 THEN ‘FEPROM’
WHEN 14 THEN ‘EPROM’
WHEN 15 THEN ‘CDRAM’
WHEN 16 THEN ‘3DRAM’
WHEN 17 THEN ‘SDRAM’
WHEN 18 THEN ‘SGRAM’
WHEN 19 THEN ‘RDRAM’
WHEN 20 THEN ‘DDR’
ELSE ‘not defined’
END AS MemoryType,
MEM.PositionInRow0,
MEM.Speed0,
MEM.Tag0
FROM v_GS_Computer_System CS
JOIN v_GS__Physical_Memory0 MEM ON CS.ResourceID = MEM.ResourceID
Order by
CS.Name0,
MEM.Tag0

Leave a Reply

Your email address will not be published. Required fields are marked *