03-30-2015 10:15 AM
I've exhausted my search to find a SQL select statement to list device names that are not in visualrf. Can someone help me with this?
Ryan Holland, ACDX #1 ACMX #1
The Ohio State University
Solved! Go to Solution.
03-31-2015 09:14 AM
dbc 'select id, name from visualrf.managed_device where id not in (select managed_device_id from visualrf.floor_managed_device) order by id;'
Ignore the IDs that look like: 019a1252-9d6a-4bec-b934-d5c18a523f3b as they are planned APs. The tables don't treat planned APs like real APs, which is why they appear in this output.
Controllers / Switches are excluded from this output.
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company