scapscanresultreport

SELECT xccdscanresult.mgm_id,

    xccdscanresult.scan_id,

    xccdscanresult.rule_id,

    xccdscanresult.idref,

    xccdscanresult.rulesystem,

    system.system_id,

    system.hostname,

    system.organization,

    xccdscanresult.ident,

    xccdscanresult.result,

    xccdscanresult.synced_date

   FROM (xccdscanresult

     LEFT JOIN system ON (((xccdscanresult.mgm_id = system.mgm_id) AND (xccdscanresult.system_id = system.system_id))))

  ORDER BY xccdscanresult.mgm_id, xccdscanresult.scan_id, xccdscanresult.rule_id;