I query the SQL Server directly to pull infoormation for our billing system. You can query the database for this information.
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".
