scapscanreport

SELECT xccdscan.mgm_id,

    xccdscan.scan_id,

    system.system_id,

    xccdscan.action_id,

    system.hostname,

    system.organization,

    systemnetaddressv4.address AS ip_address,

    xccdscan.name,

    xccdscan.benchmark,

    xccdscan.benchmark_version,

    xccdscan.profile,

    xccdscan.profile_title,

    xccdscan.end_time,

    xccdscan.pass,

    xccdscan.fail,

    xccdscan.error,

    xccdscan.not_selected,

    xccdscan.informational,

    xccdscan.other,

    xccdscan.synced_date

   FROM (((xccdscan

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

     LEFT JOIN systemnetinterface ON (((system.mgm_id = systemnetinterface.mgm_id) AND (system.system_id = systemnetinterface.system_id) AND systemnetinterface.primary_interface)))

     LEFT JOIN systemnetaddressv4 ON (((system.mgm_id = systemnetaddressv4.mgm_id) AND (system.system_id = systemnetaddressv4.system_id) AND (systemnetinterface.interface_id = systemnetaddressv4.interface_id))))

  ORDER BY xccdscan.mgm_id, xccdscan.scan_id, system.system_id, xccdscan.end_time;