Client Management Suite

Hi, I am trying to setup a custom report to show a number of details on our desktop systems.

I cannot seem to find a field for Total Memory, i can only seem to list individual dimm slots.

Anyone able to help me ?

Many Thanks

John

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<o p=""></o>
 
 
    _itemguid = i.Guid<o p=""></o>
  
   ,Computername = i.Name<o p=""></o>
  
   ,TotalMemory = SUM(mem.[Capacity (Bytes)])<o p=""></o>
  
FROM<o p=""></o>
  
    Inv_HW_Physical_Memory mem<o p=""></o>
  
    INNER JOIN vitem i<o p=""></o>
  
        ON mem.[_ResourceGuid] = i.Guid<o p=""></o>
  
GROUP BY<o p=""></o>
  
    i.guid<o p=""></o>
  
   ,i.Name<o p=""></o>
  
ORDER BY<o p=""></o>
  
    SUM(mem.[Capacity (Bytes)]) DESC<o p=""></o>