→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Anhle
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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?

View solution in original post

2 REPLIES 2
Anhle
Engaged Sweeper
This does not give me exactly what i want but helps me a lot. Thanks a lot.
Hemoco
Lansweeper Alumni
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?