0inCOMPUTER_IDNDISPLAYNAMEBYTESTOTALBYTESAVAILMAXMEMSLOTNOMAXMODULESIZEINSTALLEDSIZEtotalMaxModuletotalInstalledSELECT A0.COMPUTER_IDN, A0.DISPLAYNAME,
A1.BYTESTOTAL as BYTESTOTAL,
A1.BYTESAVAIL as BYTESAVAIL, A1.MAXMEM, A2.SLOTNO, A2.MAXMODULESIZE,
A2.INSTALLEDSIZE, t2.totalMaxModule, t2.totalInstalled
FROM Computer A0
LEFT OUTER JOIN SCOPECOMPUTER
ON A0.COMPUTER_IDN = SCOPECOMPUTER.COMPUTER_IDN
LEFT OUTER JOIN Memory A1
ON A0.Computer_Idn = A1.Computer_Idn
LEFT OUTER JOIN MemorySlot A2
ON A0.Computer_Idn = A2.Computer_Idn
INNER JOIN
(
SELECT COMPUTER_IDN, SUM(MAXMODULESIZE) totalMaxModule,
SUM(INSTALLEDSIZE) totalInstalled FROM
(
SELECT A0.COMPUTER_IDN, A0.DISPLAYNAME, A1.BYTESTOTAL,
A1.BYTESAVAIL, A1.MAXMEM, A2.SLOTNO, A2.MAXMODULESIZE, A2.INSTALLEDSIZE
FROM Computer A0
LEFT OUTER JOIN SCOPECOMPUTER
ON A0.COMPUTER_IDN = SCOPECOMPUTER.COMPUTER_IDN
LEFT OUTER JOIN Memory A1
ON A0.Computer_Idn = A1.Computer_Idn
LEFT OUTER JOIN MemorySlot A2
ON A0.Computer_Idn = A2.Computer_Idn WHERE
--$P!{USER_SCOPE_CLAUSE}
--AND
(A0.DEVICENAME IS NOT NULL)
) t1
GROUP BY COMPUTER_IDN
) t2
ON A0.COMPUTER_IDN=t2.COMPUTER_IDN
ORDER BY A0.DISPLAYNAMELDMSMasterReportC:\USLetterPortrait.rdlx-master