SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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

Published Mar 10 2007, 05:14 PM by Garth
Filed under: , , ,

Comments

 

MSFAQ [dot] SE » Blog Archive » v_HS vs v_GS said:

Pingback from  MSFAQ [dot] SE  &raquo; Blog Archive   &raquo; v_HS vs v_GS

August 11, 2008 5:27 PM

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems