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.
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