Version 1

    This SWQL can be used in situations where the caption used to search for client endpoints differs between the NPM wireless functionality, and UDT. You can search based on IP, MAC and Caption.

     

    Use a custom query resource, and enable search.

     

    Custom SWQL Query:

    SELECT LastSeen, MACAddress as [MAC], MacUrl as [_linkfor_MAC], NodeAccessPoint,  APUrl as [_linkfor_NodeAccessPoint],  PortName, PortUrl as [_linkfor_PortName], MCI.IPAddress , MACVendor ,  VendorIcon as [_linkfor_MACVendor]
    FROM Orion.UDT.MACCurrentInformation MCI 
    inner JOIN Orion.Packages.Wireless.Clients C on mci.RawMAC = c.MAC

     

     

    Search SWQL Query:

    SELECT LastSeen, MACAddress as [MAC], MacUrl as [_linkfor_MAC], NodeAccessPoint,  APUrl as [_linkfor_NodeAccessPoint],  PortName, PortUrl as [_linkfor_PortName], MCI.IPAddress , MACVendor ,  VendorIcon as [_linkfor_MACVendor]
    FROM Orion.UDT.MACCurrentInformation MCI 
    inner JOIN Orion.Packages.Wireless.Clients C on mci.RawMAC = c.MAC
    where ( c.ipaddress like  '%${SEARCH_STRING}%' OR
            c.MAC like  '%${SEARCH_STRING}%' OR
            c.Name like '%${SEARCH_STRING}%'
    )