1
SELECT systemaction.mgm_id,
2
systemaction.system_id,
3
systemaction.action_id,
4
systemaction.earliest_action,
5
systemaction.pickup_time,
6
systemaction.completion_time,
7
systemaction.status,
8
systemaction.event,
9
systemaction.event_data,
10
systemaction.synced_date
11
FROM systemaction
12
WHERE ((systemaction.event)::text = 'OpenSCAP xccdf scanning'::text)
13
ORDER BY systemaction.mgm_id, systemaction.system_id, systemaction.action_id;