→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ethanthekiwi
Engaged Sweeper II
Is there a way to report which devices in Lansweeper have Wi-Fi adapters and show what their Wi-Fi MAC addresses are? This would include Windows, Mac, printers, smartTVs, or anything in Lansweeper that uses Wi-Fi.

If that's not possible, is there a way to get a report of all devices listing all MAC addresses not just the single tblAssets.Mac (ideally excluding virtual MAC addresses, but now I'm just dreaming)?

Backstory: We're getting ready to implement a Wi-Fi enrollment system (NAC) and I need to get a list of all of the company owned devices that connect to Wi-Fi. I can export a list of all the MAC addresses connected to our Wi-Fi system with some limited description. I could then match that to MAC addresses from Lansweeper to show which ones need to be enrolled in the new system.
1 REPLY 1
Andy_Sismey
Champion Sweeper III
This is a starting point for WIFI :

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblNetworkAdapter.NetEnabled,
tblNetworkAdapter.Name,
tblNetworkAdapter.MACAddress,
tblNetworkAdapter.Manufacturer
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblNetworkAdapter On tblAssets.AssetID = tblNetworkAdapter.AssetID
Where tblNetworkAdapter.Name Like '%wireless%'