How to find PC where the RAM has changed.

Use this query to track down PC where the RAM has changed.

 

SELECT Distinct

            v_GS_COMPUTER_SYSTEM.Name0 AS ‘PC Name’,

            v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 as ‘Current RAM’,

            v_HS_X86_PC_MEMORY.TotalPhysicalMemory0 as ‘Past RAM’

FROM

            v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM,

            v_GS_X86_PC_MEMORY v_GS_X86_PC_MEMORY,

            v_HS_X86_PC_MEMORY v_HS_X86_PC_MEMORY

WHERE

            v_HS_X86_PC_MEMORY.ResourceID = v_GS_X86_PC_MEMORY.ResourceID

            AND v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_X86_PC_MEMORY.ResourceID

            AND v_GS_COMPUTER_SYSTEM.ResourceID = v_HS_X86_PC_MEMORY.ResourceID

            AND v_HS_X86_PC_MEMORY.TotalPhysicalMemory0 <> v_GS_X86_PC_MEMORY.TotalPhysicalMemory0

Leave a Reply

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