If you found this information useful, please consider awarding points for "Correct" or "Helpful".

select e.name, n.mac_address, n.network_name

from vpx_vm v

inner join vpx_nic n on (v.id = n.entity_id)

inner join vpx_entity e on (v.id = e.id)

I didn't quickly see how to associate the IP address with the NIC. It may be in there though.

Found it.

select e.name, n.mac_address, n.network_name, i.ip_address

from vpx_vm v

inner join vpx_nic n on (v.id = n.entity_id)

inner join vpx_entity e on (v.id = e.id)

inner join vpx_ip_address i on (i.entity_id = n.entity_id and i.device_id = n.device_id)

If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".

As soon as I ll test this solution I ll rate your answer.

As for now I dont have SQL access.

(I found another solution which is grepping vmx files on ESX datastores)

Regards,

Dawid

Jered Rassier

##If you have found my post has answered your question or helpful please mark it as such##