Missing SCCM Client

Missing SCCM Client:

SELECT DISTINCT
SYS.Netbios_Name0 "Hostname", SYS.User_Name0, SYS.Client0 "Client", SYS.Client_Version0 "Client Version", SYS.Client_Type0 "Client Type",
OPSYS.Caption0 as C054, OPSYS.Version0,
MEM.TotalPhysicalMemory0 "RAM",
CSYS.Manufacturer0, CSYS.Model0,
Processor.Manufacturer0, Processor.Name0, Processor.MaxClockSpeed0,
DSYS.Size0 "HD Size (MB)"
FROM v_R_System SYSLEFT JOIN v_RA_System_IPAddresses IPAddr on SYS.ResourceID = IPAddr.ResourceIDLEFT JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceIDLEFT JOIN v_GS_COMPUTER_SYSTEM CSYS on SYS.ResourceID = CSYS.ResourceIDLEFT JOIN v_GS_PROCESSOR Processor on Processor.ResourceID = SYS.ResourceIDLEFT JOIN v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID = OPSYS.ResourceIDLEFT JOIN v_GS_DISK DSYS on SYS.ResourceID = DSYS.ResourceIDWHERE SYS.Client0 IS NULLORDER BY SYS.Netbios_Name0