systempackagesinstalledreport

SELECT systempackageinstalled.mgm_id,

    systempackageinstalled.system_id,

    system.organization,

    systempackageinstalled.name AS package_name,

    systempackageinstalled.epoch AS package_epoch,

    systempackageinstalled.version AS package_version,

    systempackageinstalled.release AS package_release,

    systempackageinstalled.arch AS package_arch,

    systempackageinstalled.synced_date

   FROM (systempackageinstalled

     JOIN system ON ((system.system_id = systempackageinstalled.system_id)))

  ORDER BY systempackageinstalled.mgm_id, systempackageinstalled.system_id, systempackageinstalled.name;