1
SELECT systemvirtualdata.mgm_id,
2
systemvirtualdata.host_system_id AS host,
3
systemvirtualdata.virtual_system_id AS guest,
4
systemvirtualdata.synced_date
5
FROM systemvirtualdata
6
WHERE ((systemvirtualdata.host_system_id IS NOT NULL) AND (systemvirtualdata.virtual_system_id IS NOT NULL))
7
ORDER BY systemvirtualdata.mgm_id, systemvirtualdata.host_system_id, systemvirtualdata.virtual_system_id;