Thefollowing SQL query provides Machine name, MAC address and IP Address.

Linux Query Mac Address Ip
Query Mac Address From Ip

This can be used to get mac address for remote computers also. Below are few examples on how to use this command. It works on XP, Vista, Windows 7, Server 2003 and Server 2008 operating systems. Get mac addresses from CMD. Just run the command getmac to get the mac addresses. Saints row 3 for mac.

*****************************************************************

Java provides no direct way to query the MAC address of a host in your network, as this is abstracted away by Java's socket libraries. In a way, this makes sense, because the MAC address of a host actually says very little. There is no such thing as 'the' MAC address of a host.
This query has added logic that will enable you to filter out those machines that do not have a specified Default Gateway set as well as those machines that do not have a specified IP address set or have an IP address that is 0.0.0.0 which is typically the case for machines with multiple Network Interface Card's (NIC's) installed where the NIC is not in use.

SELECTv_RA_System_ResourceNames.Resource_Names0AS [Resource name], v_RA_System_MACAddresses.MAC_Addresses0 AS [MAC Address],

v_RA_System_IPAddresses.IP_Addresses0 AS [IP Address]
FROMv_RA_System_MACAddresses INNER JOIN
v_RA_System_ResourceNamesON v_RA_System_MACAddresses.ResourceID = v_RA_System_ResourceNames.ResourceIDINNER JOIN
v_RA_System_IPAddressesON v_RA_System_MACAddresses.ResourceID = v_RA_System_IPAddresses.ResourceID

Linux Query Mac Address Ip

***************************************************************

More SCCM custom reports can be found here

Linux Query Mac Address Ip

Query Mac Address From Ip

Query Mac Address For Ip