Find all PCs where Virtual RAM is more than twice Physical RAM.

SELECT
CS.Name0,
CS.UserName0,
RAM.TotalPageFileSpace0,
RAM.TotalPhysicalMemory0,
RAM.TotalVirtualMemory0
FROM
v_GS_COMPUTER_SYSTEM CS,
v_GS_X86_PC_MEMORY RAM
WHERE  CS.ResourceID = RAM.ResourceID
AND RAM.TotalVirtualMemory0 > (RAM.TotalPhysicalMemory0 * 2)

Leave a Reply

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