Need ram info

Question

Hi

I need memory module's make and model of all the agents.

Answer 1

Sorry, can you please explain in more detail what you want to accomplish ?

Kind regards

Answer 2

I need to collect all my agents Ram module make and model. currently only capacity and serial number is collected.

Answer 3

what is "ram module make" .. did you mean the vendor ?

Answer 4

Yes vendor is what I need, also model number if possible

Answer 5

what about this mysql command ?

SELECT
    h.NAME as computername,
    m.CAPACITY as ram_size,
    m.TYPE as ram_vendor,
    m.DESCRIPTION as ram_description,
    m.SERIALNUMBER as ram_serial
FROM
    hardware h
JOIN
    memories m ON h.ID = m.HARDWARE_ID

yes i see there is no vendor

in wmic you can get this info from cmd with

wmic memorychip get devicelocator, capacity, speed, manufacturer, partnumber, serialnumber, memorytype

If there where the table manuafacturer of the memory in newer ocs-inventory versions it should work with this command, but i think this information is not inventoried and therefore not in the database

SELECT
    h.NAME as computername,
    m.CAPACITY as ram_size,
    m.TYPE as ram_type,
    m.DESCRIPTION as ram_description,
    m.MANUFACTURER as ram_manufacturer
FROM
    hardware h
JOIN
    memories m ON h.ID = m.HARDWARE_ID