CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more

TRY NOW

MAC Addresses

Hardware

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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.