1
SELECT xccdscan.mgm_id,
2
xccdscan.scan_id,
3
system.system_id,
4
xccdscan.action_id,
5
system.hostname,
6
system.organization,
7
systemnetaddressv4.address AS ip_address,
8
xccdscan.name,
9
xccdscan.benchmark,
10
xccdscan.benchmark_version,
11
xccdscan.profile,
12
xccdscan.profile_title,
13
xccdscan.end_time,
14
xccdscan.pass,
15
xccdscan.fail,
16
xccdscan.error,
17
xccdscan.not_selected,
18
xccdscan.informational,
19
xccdscan.other,
20
xccdscan.synced_date
21
FROM (((xccdscan
22
LEFT JOIN system ON (((xccdscan.mgm_id = system.mgm_id) AND (xccdscan.system_id = system.system_id))))
23
LEFT JOIN systemnetinterface ON (((system.mgm_id = systemnetinterface.mgm_id) AND (system.system_id = systemnetinterface.system_id) AND systemnetinterface.primary_interface)))
24
LEFT JOIN systemnetaddressv4 ON (((system.mgm_id = systemnetaddressv4.mgm_id) AND (system.system_id = systemnetaddressv4.system_id) AND (systemnetinterface.interface_id = systemnetaddressv4.interface_id))))
25
ORDER BY xccdscan.mgm_id, xccdscan.scan_id, system.system_id, xccdscan.end_time;