MAC Addresses

Find All MAC Addresses of the Devices in Your Network

Lansweeper automatically scans MAC addresses for all devices and with the help if this built-in report you can get an overview of all devices and their MAC address on your Network. In addition to the MAC address, this report also shows the IP address and operating system of the assets.

 

Click to Open - MAC Addresses Query
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tblNetwork.Description As [Network Card],
  tblNetwork.MACaddress,
  tsysOS.Image As icon,
  tblNetwork.IPAddress,
  tblNetwork.Lastchanged
From tblAssets
  Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblNetwork.IPEnabled = 1 And tblAssetCustom.State = 1
Order By tblAssets.AssetName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting