This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Lookup NPM Wireless Data in UDT

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}%'
)

pastedImage_5.png