STEP 1
STEP 2
select jsonb_pretty(val) from "MobilityMigrations" where val->>'migrationId' = 'MIG ID' and val->>'rowType' = 'DEFINITION_ROW';
IMP NOTE:- Replace the MIG ID with the migration ID for a BULK migration with respect to a source VM. The migration ID can be obtained from HCX mobility migration UI.
SAMPLE OUTPUT
$cat info_collection select jsonb_pretty(val) from "MobilityMigrations" where val->>'migrationId' = '#####################################' and val->>'rowType' = 'DEFINITION_ROW';
STEP 3
psql -U postgres hybridity -h localhost < info_collection | grep -A30 guestCustomization
SAMPLE OUTPUT
$ psql -U postgres hybridity -h localhost < info_collection | grep -A30 guestCustomization
"guestCustomization": { +
"identity": { +
"name": "################" +
}, +
"changeSID": false, +
"dnsCustomizations": { +
"dns": [ +
"#########", +
"#########" +
], +
"dnsSuffixes": [ +
"hcxsrelab.com" +
] +
}, +
"networkCustomizations": [ +
{ +
"dns": [ +
], +
"netmask": "#############33#", +
"gateways": [ +
"#############" +
], +
"ipAddress": "#############", +
"macAddress": "#############" +
} +
], +
"personalizationScript": "" +
}, +
"creationOrganization": "HybridityAdmin", +
"lastUpdateEnterprise": "HybridityAdmin", +
"lastUpdateOrganization": "HybridityAdmin" +