Notebook query needed

[nknippen]

Hello, I am looking for a SQL query that lists me the following:

1. All active Notebooks in the Domain
2. That do not have a WIFI Adapter installed.

Is such a query possible?

I Need to info so I can make a calculation of how much the wireless functionality would cost.

Regards,

Nils

[Daniel_B · Accepted solution]

The following report lists all laptops (laptops have an entry in table tblPortableBattery😞

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Username,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblPortableBattery
    On tblAssets.AssetID = tblPortableBattery.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName

This report lists those which don't have a Wi-Fi adapter:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Username,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tblPortableBattery
    On tblAssets.AssetID = tblPortableBattery.AssetID
Where tblAssets.AssetID Not In (Select tblNetworkAdapter.AssetID
  From tblNetworkAdapter Where (tblNetworkAdapter.Name Like '%wireless%') Or
    (tblNetworkAdapter.Name Like '%wi-fi%') Or
    (tblNetworkAdapter.NetConnectionID Like '%wireless%')) And
  tblAssetCustom.State = 1
Order By tblAssets.AssetName