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".
Charles Killmer, VCP4
If you found this or other information useful, please consider awarding points for "Correct" or "Helpful".
