1
SELECT systempackageinstalled.mgm_id,
2
systempackageinstalled.system_id,
3
system.organization,
4
systempackageinstalled.name AS package_name,
5
systempackageinstalled.epoch AS package_epoch,
6
systempackageinstalled.version AS package_version,
7
systempackageinstalled.release AS package_release,
8
systempackageinstalled.arch AS package_arch,
9
systempackageinstalled.synced_date
10
FROM (systempackageinstalled
11
JOIN system ON ((system.system_id = systempackageinstalled.system_id)))
12
ORDER BY systempackageinstalled.mgm_id, systempackageinstalled.system_id, systempackageinstalled.name;