Below is the ConfigMgr Query that I used and also it's SQL equivalent. Below is the ConfigMgr Query that will pull out the Computer Name, Serial Number, BIOS Version, IP and MAC Address. The ConfigMgr query is: When you look at your query statement window, it should look like this.

We can find mac address (physical address) of a computer using the command ‘getmac‘. 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.

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. How MAC address converter tool works? This free MAC address converter can convert any MAC address to an IPV4 IP Address and an IPV6 internet protocol Address (IP). It takes MAC Address as an input string and generates a query against given MAC address and selected conversion like MAC to IPV6 or MAC to IPV4 or both then performs above steps.

Get mac addresses from CMD

Just run the command getmac to get the mac addresses. Find an example below.

This command does not show mac addresses for the network connections which are disabled. You can run ncpa.cpl and check which NICs are disabled. Further, I have received comments that this command does not help identify the mac address for a specific device. For example, if I need to get the mac address for my WiFi card, output of getmac command is not helpful. We can use ipconfig command to deal with this.

Get mac address of a remote computer

We can retrieve the mac addressses for a remote computer using nbtstat command.
Example:

Alternatively, We can run the below command to retrieve the mac addresses of a remote computer.

remote_computer : Full name of the remote computer or IP address
username and password are of the account on the remote computer.

Example:

If you do not want to specify the password, you can skip /p parameter. You will be prompted to enter the password and the command execution will take place after that.

Errors:

Using getmac command we can retrieve the mac addresses of the machines running windows OS only. If you try this for a Linux machine you would get the error “The RPC server is unavailable.”

If you provide incorrect password, the command would fail with the error message “Logon failure: unknown user name or bad password.”

Also Read:
Windows CMD commands reference

These queries were last tested with Configuration Manager version 2006

I recently had to pull together some information on several servers and I made used of ConfigMgr in order to collate the information. Below is the ConfigMgr Query that I used and also it's SQL equivalent. Below is the ConfigMgr Query that will pull out the Computer Name, Serial Number, BIOS Version, IP and MAC Address.

Query Mac Address To Get Ip

The ConfigMgr query is:

When you look at your query statement window, it should look like this.

Here is the SQL equivalent if you wish to use that instead to pull the information out of your ConfigMgr database:

Conclusion

Even if you can't use this query right away I would suggest take a copy of it and storing it. You never know when this might come in handy, or it could be the start of a query that you need.

Sql Get Ip Address