Network Management

Reply
MVP
Posts: 485
Registered: ‎04-03-2007

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
Posts: 1,216
Registered: ‎10-16-2008

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
Posts: 485
Registered: ‎04-03-2007

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
Showing results for 
Search instead for 
Did you mean: