1
SELECT xccdscanresult.mgm_id,
2
xccdscanresult.scan_id,
3
xccdscanresult.rule_id,
4
xccdscanresult.idref,
5
xccdscanresult.rulesystem,
6
system.system_id,
7
system.hostname,
8
system.organization,
9
xccdscanresult.ident,
10
xccdscanresult.result,
11
xccdscanresult.synced_date
12
FROM (xccdscanresult
13
LEFT JOIN system ON (((xccdscanresult.mgm_id = system.mgm_id) AND (xccdscanresult.system_id = system.system_id))))
14
ORDER BY xccdscanresult.mgm_id, xccdscanresult.scan_id, xccdscanresult.rule_id;