http://communities.vmware.com/community/vmtn/general/virtualization?view=discussions Most recent forum messages en Fri, 26 Jun 2009 19:23:25 GMT Clearspace 1.10.12 (http://jivesoftware.com/products/clearspace/) 2009-06-26T19:23:25Z en http://communities.vmware.com/message/1296268?tstart=0#1296268 I would note that this is pulling it from the SQL server for Virtual Center (just for reference) <br /> <p /> <p /> Jered Rassier<br /> <br /> ##If you have found my post has answered your question or helpful please mark it as such## Fri, 26 Jun 2009 19:23:25 GMT jayctd http://communities.vmware.com/message/1296268?tstart=0#1296268 2009-06-26T19:23:25Z 5 months, 1 day ago http://communities.vmware.com/message/1296246?tstart=0#1296246 I'm not sure what you're trying to accomplish, but this Virtual Mac Tool might give you some details <a class="jive-link-external" href="http://www.run-virtual.com/?page_id=173">http://www.run-virtual.com/?page_id=173</a> <br /> <br /> If you found this information useful, please consider awarding points for "Correct" or "Helpful". Thanks!!! <br /> <br /> Regards,<br /> <br /> Stefan Nguyen<br /> VMware vExpert 2009<br /> iGeek Systems Inc.<br /> VMware, Citrix, Microsoft Consultant Fri, 26 Jun 2009 19:05:28 GMT azn2kew http://communities.vmware.com/message/1296246?tstart=0#1296246 2009-06-26T19:05:28Z 5 months, 1 day ago http://communities.vmware.com/message/1294683?tstart=0#1294683 <br /> Hi!<br /> <p /> <p /> <p /> As soon as I ll test this solution I ll rate your answer.<br /> <p /> As for now I dont have SQL access.<br /> <p /> (I found another solution which is grepping vmx files on ESX datastores)<br /> <p /> <p /> <p /> Regards,<br /> <p /> Dawid Thu, 25 Jun 2009 11:22:12 GMT DawidM http://communities.vmware.com/message/1294683?tstart=0#1294683 2009-06-25T11:22:12Z 5 months, 2 days ago 1 http://communities.vmware.com/message/1294666?tstart=0#1294666 Did this answer your question?<br /> <p /> <p /> Charles Killmer, VCP<br /> <br /> If you found this or other information useful, please consider awarding points for "Correct" or "Helpful". Thu, 25 Jun 2009 11:06:37 GMT Chuck8773 http://communities.vmware.com/message/1294666?tstart=0#1294666 2009-06-25T11:06:37Z 5 months, 2 days ago 2 http://communities.vmware.com/message/1292395?tstart=0#1292395 I query the SQL Server directly to pull infoormation for our billing system. You can query the database for this information.<br /> <p /> select e.name, n.mac_address, n.network_name<br /> <p /> <br /> from vpx_vm v<br /> <p /> <br /> inner join vpx_nic n on (v.id = n.entity_id)<br /> <p /> <br /> inner join vpx_entity e on (v.id = e.id) <br /> <p /> <p /> <p /> <p /> <p /> <br /> I didn't quickly see how to associate the IP address with the NIC. It may be in there though. <br /> <p /> <p /> <p /> Found it.<br /> <p /> select e.name, n.mac_address, n.network_name, i.ip_address<br /> <p /> from vpx_vm v<br /> <p /> <br /> inner join vpx_nic n on (v.id = n.entity_id)<br /> <p /> <br /> inner join vpx_entity e on (v.id = e.id) <br /> <p /> <p /> <p /> <p /> <p /> <br /> inner join vpx_ip_address i on (i.entity_id = n.entity_id and i.device_id = n.device_id)<br /> <p /> <p /> <p /> <p /> <p /> <p /> <p /> <p /> <p /> If you found this or other information useful, please consider awarding points for "Correct" or "Helpful". Tue, 23 Jun 2009 12:20:11 GMT Chuck8773 http://communities.vmware.com/message/1292395?tstart=0#1292395 2009-06-23T12:20:11Z 5 months, 4 days ago 1 http://communities.vmware.com/message/1292339?tstart=0#1292339 <br /> Not exactly what I was asking...<br /> <p /> Let me clarify .<br /> <p /> Does Virtual Center or ESX softwarehave any tool to list all the VMs together with thier MAC addresses? (With IPs it is possbile)<br /> <p /> <p /> <p /> Regards,<br /> <p /> Dawid Tue, 23 Jun 2009 11:27:02 GMT DawidM http://communities.vmware.com/message/1292339?tstart=0#1292339 2009-06-23T11:27:02Z 5 months, 4 days ago 5 http://communities.vmware.com/message/1292318?tstart=0#1292318 You will need to search the arp tables to compare the mac address to the name<br /> <br /> "arp -a" will list everything in the ARP tables... so you <b>might</b> find what you want there. <br /> <p /> <p /> <p /> If you found this information useful, please consider awarding points for "Correct" or "Helpful". Tue, 23 Jun 2009 11:22:17 GMT firestartah http://communities.vmware.com/message/1292318?tstart=0#1292318 2009-06-23T11:22:17Z 5 months, 4 days ago 6 http://communities.vmware.com/message/1292199?tstart=0#1292199 <br /> Hello All!<br /> <p /> <p /> <p /> I would like to ask if it possible to find Virtual Machine's name by knowing it's MAC address only in any way ? <br /> <p /> <p /> <p /> Thanks a lot,<br /> <p /> Dawid Tue, 23 Jun 2009 09:17:03 GMT DawidM http://communities.vmware.com/message/1292199?tstart=0#1292199 2009-06-23T09:17:03Z 5 months, 4 days ago 7