Sccm Query report for basic Server properties

SELECT distinct
 CS.name0 AS 'Server Name',
 OS.Caption0 AS 'OS',
 CU.Manufacturer0 AS 'Manufacturer',
 CU.Model0 AS 'Model',
 RAM.TotalPhysicalMemory0/1024 AS [RAM (MB)],
 Processor.Name0 AS 'Processor',
 BIOS.ReleaseDate0 AS 'BIOS Manufacture Date',
 OS.InstallDate0 AS 'OS Install Date'
 FROM
 v_R_System CS
 FULL JOIN v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceID
 FULL JOIN v_GS_OPERATING_SYSTEM OS on OS.ResourceID = CS.ResourceID
 FULL JOIN V_GS_X86_PC_MEMORY RAM on RAM.ResourceID = CS.ResourceID
 FULL JOIN v_GS_PROCESSOR Processor on Processor.ResourceID=CS.ResourceID
 FULL JOIN v_GS_SYSTEM_ENCLOSURE SE on SE.ResourceID = CS.ResourceID
 FULL JOIN v_GS_COMPUTER_SYSTEM CU on CU.ResourceID = CS.ResourceID
 WHERE CS.Operating_System_Name_and0 LIKE '%nt%server%' and CS.Client0 = 1
 GROUP BY
 CS.Name0,
 OS.Caption0,
 CU.Manufacturer0,
 CU.Model0,
 RAM.TotalPhysicalMemory0,
 BIOS.ReleaseDate0,
 OS.InstallDate0,
 Processor.Name0,
 BIOS.ReleaseDate0
 ORDER BY CS.Name0