select ccs.name, ccs.ip, ccs.cs_id, ccs.cs_key, ccs.origin, ccs.os_description, ccs.create_TIme, ccs.domain, ccs.dedicated, ccsa.cs_attr_value as OS
from cm_computer_system ccs
LEFT OUTER JOIN cm_group_member cgm ON cgm.cs_id = ccs.cs_id
LEFT OUTER JOIN cm_computer_system_attr ccsa ON ccsa.cs_id = ccs.cs_id and cs_attr_key = 'PrimaryOSType'
LEFT OUTER JOIN cm_group cg ON cg.grp_id = cgm.grp_id
where cg.grp_id is null
ORDER BY ccs.name