identify which hardware have Wifi Devices
Hello
Im in need of some help, i need to identify which machines have a Wifi card installed on desktops machines, i have created a smart group to exclude laptops but looking down the criteria in the sma v10.1 im unable to see something for Wifi.
I believe that some desktops may have the wifi card installed but no driver installed in the os.
But this should show in a smart group.
Also helpful to know if some machines have no wifi card installed.
Thanks
1 Comment
[ + ] Show comment
-
The SMA identifies network cards, but I'm not sure how you would know which of them are wireless. The name may be a good indicator but won't be 100% accurate. - chucksteel 4 years ago
Answers (1)
Please log in to answer
Posted by:
gwir
4 years ago
Hi,
You can try this query :
SELECT distinct m.NAME
FROM MACHINE m
LEFT JOIN MACHINE_NICS mn ON (m.ID = mn.ID)
WHERE mn.NIC like '%wifi%'
OR mn.NIC like '%wi-fi%'
OR mn.NIC like '%wireless%'
Comments:
-
many Thanks, I tried to reveerse this so to find machines not having Wifi with Not Like but there the same machines on both reports with Wifi and without Wifi
I can see that one of the machines is showing o both and i has a wifi card
any ideas?
thanks - markc0 4 years ago-
Try this :
WHERE mn.NIC not like '%wifi%'
and mn.NIC not like '%wi-fi%'
and mn.NIC not like '%wireless%' - gwir 4 years ago-
Hi, Thanks. Yes thats what i done
SELECT distinct m.NAME
FROM MACHINE m
LEFT JOIN MACHINE_NICS mn ON (m.ID = mn.ID)
WHERE mn.NIC not like '%wifi%'
OR mn.NIC not like '%Wi-fi%'
OR mn.NIC not like '%wireless%'
But im still seeing some machines in both reports - markc0 4 years ago -
* Use logical AND instead of logical OR - gwir 4 years ago
-
thanks but i still get some of the same machines on both reports (with and without wifi)using
SELECT distinct m.NAME
FROM MACHINE m
LEFT JOIN MACHINE_NICS mn ON (m.ID = mn.ID)
WHERE mn.NIC not like '%wifi%'
and mn.NIC not like '%Wi-fi%'
and mn.NIC not like '%wireless%' - markc0 4 years ago -
thanks but i still get some of the same machines on both reports (with and without wifi)using
SELECT distinct m.NAME
FROM MACHINE m
LEFT JOIN MACHINE_NICS mn ON (m.ID = mn.ID)
WHERE mn.NIC not like '%wifi%'
and mn.NIC not like '%Wi-fi%'
and mn.NIC not like '%wireless%' - markc0 4 years ago-
Look at thoses devices if wifi devices are named differently - gwir 4 years ago
-
under the network devices inventory of one machine thats in both reports it lists many network devices as follow;
Bluetooth Device (personal Area Network):
Killer(r) Wi-fi 6 Ax1650w 160mhz Wireless Network Adapter (200d2w):
Microsoft Wi-fi Direct Virtual Adapter:
Pangp Virtual Ethernet Adapter:
Realtek Usb Gbe Family Controller #2:
Wan Miniport (ip):
Wan Miniport (network Monitor):
I can see there is Killer WIFI so it should only be in one report right - markc0 4 years ago
