SELECT
Distinct
SYS.Netbios_Name0
,
SYS.Operating_System_Name_and0
,
MEM
.TotalPhysicalMemory0/1024 As C083
FROM
v_R_System SYS
JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID
WHERE
User_Name0
= ‘Garth’
SELECT
Distinct
SYS.Netbios_Name0
,
SYS.Operating_System_Name_and0
,
MEM
.TotalPhysicalMemory0/1024 As C083
FROM
v_R_System SYS
JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID
WHERE
User_Name0
= ‘Garth’