packagesupdatesallreport

SELECT system.mgm_id,

    system.system_id,

    system.organization,

    systempackageupdate.name AS package_name,

    systempackageinstalled.epoch AS package_epoch,

    systempackageinstalled.version AS package_version,

    systempackageinstalled.release AS package_release,

    systempackageinstalled.arch AS package_arch,

    systempackageupdate.epoch AS newer_epoch,

    systempackageupdate.version AS newer_version,

    systempackageupdate.release AS newer_release,

    systempackageupdate.synced_date

   FROM ((system

     JOIN systempackageupdate ON (((system.mgm_id = systempackageupdate.mgm_id) AND (system.system_id = systempackageupdate.system_id))))

     JOIN systempackageinstalled ON (((system.mgm_id = systempackageinstalled.mgm_id) AND (system.system_id = systempackageinstalled.system_id) AND ((systempackageinstalled.name)::text = (systempackageupdate.name)::text))))

  ORDER BY system.mgm_id, system.organization, system.system_id, systempackageupdate.name;