Missing Brackets

SELECT DISTINCT
    SYS.Netbios_Name0,
    fcm.SiteCode,
    ROUND(CONVERT (FLOAT ,LDISK.FreeSpace0) / 1024, 2) AS FreeSpace0,
    ROUND (CONVERT (FLOAT, PROC1.MaxClockSpeed0), -2)/ 1000 AS ‘Processor (GHz)’,
    ROUND (ROUND(CONVERT (FLOAT ,MEM.TotalPhysicalMemory0) / 1048576, 2) * 1024, 0) AS C083, OPSYS.Caption0 AS ‘Operating System’,
    CONVERT(FLOAT, LEFT(OPSYS.Version0, 3)) Version
FROM
    v_FullCollectionMembership fcm
    JOIN v_R_System SYS ON fcm.ResourceID=SYS.ResourceID
    JOIN v_GS_PROCESSOR PROC1 ON SYS.ResourceID = PROC1.ResourceID
    JOIN v_GS_X86_PC_MEMORY MEM ON SYS.ResourceID = MEM.ResourceID
    JOIN v_GS_OPERATING_SYSTEM OPSYS ON SYS.ResourceID = OPSYS.ResourceID
    JOIN v_GS_LOGICAL_DISK LDISK ON SYS.ResourceID = LDISK.ResourceID AND LDISK.DeviceID0=SUBSTRING(OPSYS.WindowsDirectory0,1,2)
WHERE
    (TotalPhysicalMemory0 < 204800 or
    PROC1.MaxClockSpeed0 < 2000 or
    LDISK.FreeSpace0<16000)
    and fcm.CollectionID=@ID
GROUP BY
    SYS.Netbios_Name0,
    LDISK.FreeSpace0,
    PROC1.MaxClockSpeed0,
    MEM.TotalPhysicalMemory0,
    OPSYS.Caption0,
    OPSYS.Version0,
    fcm.SiteCode

Leave a Reply

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