hostguestsreport

SELECT systemvirtualdata.mgm_id,

    systemvirtualdata.host_system_id AS host,

    systemvirtualdata.virtual_system_id AS guest,

    systemvirtualdata.synced_date

   FROM systemvirtualdata

  WHERE ((systemvirtualdata.host_system_id IS NOT NULL) AND (systemvirtualdata.virtual_system_id IS NOT NULL))

  ORDER BY systemvirtualdata.mgm_id, systemvirtualdata.host_system_id, systemvirtualdata.virtual_system_id;