Report showing only Wi-Fi Devices and MAC addresses

[ethanthekiwi]

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.

[Andy_Sismey]

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%'