Wireless network card MAC report

[Powen]

Hi,

How to query and export the wireless network card MAC of all computers? Does not include other wired NICs or virtual MACs, thanks

[RCorbeil]

Starting point:

Select Top 1000000
  tblassets.AssetID,
  tblassets.AssetName,
  tsysassettypes.AssetTypename,
  tsysassettypes.AssetTypeIcon10 As icon,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  tblNetwork.Description,
  tblNetwork.IPEnabled,
  tblNetwork.MACaddress
From
  tblassets
  Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
  Inner Join tblNetwork On tblassets.AssetID = tblNetwork.AssetID
Where
  tblassetcustom.State = 1
  And (tblNetwork.Description Like '%802.11%'
       Or tblNetwork.Description Like '%wireless%'
       Or tblNetwork.Description Like '%wifi%'
       Or tblNetwork.Description Like '%wi-fi%')

The filter conditions are based on what I see in my inventory. You may want to run a list of NICs in your database to see if there are other common elements you can use to identify wireless NICs.

SELECT Distinct Description
FROM tblNetwork
ORDER BY Description

[Powen]

Thank you for your report, but the result of my query shows that all the computers, including the data of the PC without a wireless network card, maybe there is a problem, and I mainly want to export the MAC data of the wireless network card, not only AssetName, AssetTypename , IPAddress, is there any other way to find it? thanks

RC62N wrote:
Starting point:

Select Top 1000000
  tblassets.AssetID,
  tblassets.AssetName,
  tsysassettypes.AssetTypename,
  tsysassettypes.AssetTypeIcon10 As icon,
  tblassets.IPAddress,
  tblassets.Lastseen,
  tblassets.Lasttried,
  tblNetwork.Description,
  tblNetwork.IPEnabled,
  tblNetwork.MACaddress
From
  tblassets
  Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
  Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
  Inner Join tblNetwork On tblassets.AssetID = tblNetwork.AssetID
Where
  tblassetcustom.State = 1
  And (tblNetwork.Description Like '%802.11%'
       Or tblNetwork.Description Like '%wireless%'
       Or tblNetwork.Description Like '%wifi%'
       Or tblNetwork.Description Like '%wi-fi%')

The filter conditions are based on what I see in my inventory. You may want to run a list of NICs in your database to see if there are other common elements you can use to identify wireless NICs.

SELECT Distinct Description
FROM tblNetwork
ORDER BY Description