Anonymous

mysql> SELECT cdp_entries.switch_name,cdp_entries.device_name,cdp_entries.platform_name,INET_NTOA(cdp_entries.route) AS cdp,INET_NTOA(names.dstip) AS solarwinds FROM cdp_entries LEFT JOIN names ON cdp_entries.route = names.dstip WHERE names.dstip IS NULL AND INET_NTOA(cdp_entries.route) LIKE '%172.16%' AND cdp_entries.platform_name NOT REGEXP 'Cisco (720[46]VXR|3845)';
+-------------+-----------------+---------------------+----------------+------------+
| switch_name | device_name     | platform_name       | cdp            | solarwinds |
+-------------+-----------------+---------------------+----------------+------------+
| 7600-UT01   | 2851-VoUT09     | Cisco 2851          | 172.16.252.41  | NULL       | 
| 7600-UT01   | 2851-VoUT07     | Cisco 2851          | 172.16.252.49  | NULL       | 
| 7600-UT01   | 2611XM-VPNUT01  | cisco 2611XM        | 172.16.2.11    | NULL       | 
| 7600-UT01   | 2611XM-VPNUT02  | cisco 2611XM        | 172.16.2.12    | NULL       | 
| 6509-SF01   | SEP003094C3FAAD | Cisco IP Phone 7960 | 172.16.253.193 | NULL       | 
+-------------+-----------------+---------------------+----------------+------------+