Network Management

Reply
MVP

Show APs not in visualrf

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
Moderator

Re: Show APs not in visualrf

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.


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company
MVP

Re: Show APs not in visualrf

Rob, you are my favorite person ever!

==========
Ryan Holland, ACDX #1 ACMX #1
The Ohio State University
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: