Try this:
SELECT p.probe_name,p.ip,c1.name,p.last_action,p.times_activated,p.timespec,p.pid,p.pkg_build,p.probe_type,p.probe_status
FROM CM_NIMBUS_PROBE p
Left JOIN CM_COMPUTER_SYSTEM c1 ON p.ip = c1.ip
where p.probe_name = 'net_connect'
order by c1.name