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 Full asset report with and without ad relationship
by  teddyh2o   Go to last post Go to first unread
Last post: 6/18/2021 8:28:24 PM(UTC)
Report Center Show newly discovered software
by  CyberCitizen  
Go to last post Go to first unread
Last post: 6/16/2021 12:06:21 AM(UTC)
Lansweeper Multiple Devices Owned by Users (asset relations)
by  Charles S.   Go to last post Go to first unread
Last post: 6/15/2021 9:38:26 PM(UTC)
Lansweeper Show Date Without Time
by  RC62N  
Go to last post Go to first unread
Last post: 6/15/2021 9:04:47 PM(UTC)
Lansweeper Windows 10 Version Chart
by  RC62N   Go to last post Go to first unread
Last post: 6/14/2021 6:16:52 PM(UTC)
Lansweeper LSAgent Report
by  brodiemac-too  
Go to last post Go to first unread
Last post: 6/14/2021 5:27:29 PM(UTC)