2 Replies Latest reply on Feb 11, 2015 1:19 PM by rlattin

    How to query for Wireless MAC address

    rlattin Rookie

      I'm trying to figure out how to build a query for all our wireless MAC addresses.  Right now I'm querying for "Computer"."Laptop"="Yes" so I only see devices with wireless cards in them.  I'd like to see a column for the wireless MAC addresses, or even a query for all MAC addresses on the machine would be acceptable.  The only column that I've found to add is under Network Adapters, Network Adapter, Physical Address; however this only lists one MAC address and there's no guarantee it's the wireless adapter or the Ethernet adapter.  Here's a picture of my current query.  Any ideas how I can get it to display either just the wireless MAC address, or all MAC addresses for the system?

      query.PNG

        • 1. Re: How to query for Wireless MAC address
          Peter Massa Expert

          Hello rlattin,

           

          You should be able to scope the query by using:

          "Computer"."Network"."TCPIP"."Bound Adapter"."Description" Like

           

          *Note: this is network - not network adapters.

           

          Then select each of the wireless cards that show up in the column that you wish to report on and add them using the OR operand.

          Example:

          selection.PNG

           

          Next select the data you wish to be returned for each adapter:

          I would suggest Description and Physical Address.  These would be found under: "Computer"."Network"."TCPIP"."Bound Adapter"

           

          Example:

          return.PNG

           

          This should yield the results that you are looking for.

           

          LANDESK does some magic whenever you use the same field in both the top and bottom half.  It will only display results that match perfectly to one of the search criteria that you enter.  This means that you are able to pick exactly the NICs that you want the MAC Addresses for (aka only wireless NICs) and as long as you add the Description as one of the returned values - it will automatically parse the data down.

           

          Hope this helps,

          -Peter

          • 2. Re: How to query for Wireless MAC address
            rlattin Rookie

            Thank you that worked very well!!!