Hi John,

yes - DCM reports memory per slots. you may need to write a query to sum up the capacity. There is a  column _Capacity which has the data as a bigint.

Thank you,
Misha Shevchenko

Not sure about the tables for DCM, but this works for me using the regular inventory tables:

 SELECT
 
 
    _itemguid = i.Guid
  
   ,Computername = i.Name
  
   ,TotalMemory = SUM(mem.[Capacity (Bytes)])
  
FROM
  
    Inv_HW_Physical_Memory mem
  
    INNER JOIN vitem i
  
        ON mem.[_ResourceGuid] = i.Guid
  
GROUP BY
  
    i.guid
  
   ,i.Name
  
ORDER BY
  
    SUM(mem.[Capacity (Bytes)]) DESC