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
