/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


identify which hardware have Wifi Devices

02/27/2020 229 views

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

Comments

  • 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.

All Answers

0

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%'
Answered 03/02/2020 by: gwir
Brown Belt

  • 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
    • Try this :
      WHERE mn.NIC not like '%wifi%'
      and mn.NIC not like '%wi-fi%'
      and mn.NIC not like '%wireless%'
      • 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
      • * Use logical AND instead of logical OR
  • 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%'
  • 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%'
    • Look at thoses devices if wifi devices are named differently
      • 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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ