Hardware Report

[Anhle]

I’d like to create a report which shows all laptops and their wireless adapters. I could not find any similar build-in hardware report so that I can use it as a reference. Could anyone please help?

By the way, How can i create a table like tblNetworkController? There is a tblUSBController build-in but there is no tblNetworkController build-in.

Regards,

Anh.

[Anhle]

This does not give me exactly what i want but helps me a lot. Thanks a lot.

[Hemoco · Accepted solution]

You can use this report.

You will need to filter the network cards.
Lansweeper does not know which ones are wireless.

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, TsysChassisTypes.ChassisName, tblNetwork.Description
From tblComputers Inner Join                        
  tblSystemEnclosure On tblComputers.Computername =
    tblSystemEnclosure.Computername Inner Join
  TsysChassisTypes On TsysChassisTypes.Chassistype =
    tblSystemEnclosure.ChassisTypes Inner Join
  tblNetwork On tblComputers.Computername = tblNetwork.Computername
Where (tblSystemEnclosure.ChassisTypes = 8 Or tblSystemEnclosure.ChassisTypes =
    9 Or tblSystemEnclosure.ChassisTypes = 10)
Order By tblComputers.ComputerUnique

By the way, How can i create a table like tblNetworkController?

What exactly do you mean by this?