Notification

Icon
Error

Report showing only Wi-Fi Devices and MAC addresses

Posted: Thursday, May 6, 2021 9:18:07 PM(UTC)
ethanthekiwi

ethanthekiwi

Member Original PosterPosts: 10
0
Like
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.S
#1Andy.S Member Posts: 93  
posted: 5/11/2021 2:23:24 PM(UTC)
This is a starting point for WIFI :

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

Active Discussions

Lansweeper Enterprise Options in Menu Bar/Configuration
by  mk@allan   Go to last post Go to first unread
Last post: 6/18/2021 7:38:43 PM(UTC)
Lansweeper No One getting back to me from Lansweeper
by  Kenneth Lindsay  
Go to last post Go to first unread
Last post: 6/18/2021 3:31:06 PM(UTC)
Lansweeper INFO DateTimeService time refresh
by  miharix   Go to last post Go to first unread
Last post: 6/18/2021 10:48:57 AM(UTC)
Lansweeper RPC Unavailable error
by  Greeno  
Go to last post Go to first unread
Last post: 6/17/2021 7:15:07 PM(UTC)
Lansweeper Exclude Search
by  pryan67  
Go to last post Go to first unread
Last post: 6/16/2021 4:01:43 PM(UTC)
Lansweeper Report: All Apple Mac devices with Memory RAM asset
by  gabrielo   Go to last post Go to first unread
Last post: 6/16/2021 3:17:24 PM(UTC)
Lansweeper Does technical support for LS really respond?
by  tosch  
Go to last post Go to first unread
Last post: 6/16/2021 12:48:50 PM(UTC)