Network Management

last person joined: yesterday 

Keep an informative eye on your network with HPE Aruba Networking network management solutions
Back to discussions
Expand all | Collapse all

Show APs not in visualrf

This thread has been viewed 0 times

  • 1.  Show APs not in visualrf

    Posted Mar 30, 2015 01:16 PM

    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?



  • 2.  RE: Show APs not in visualrf
    Best Answer

    EMPLOYEE
    Posted Mar 31, 2015 12:15 PM

    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.



  • 3.  RE: Show APs not in visualrf

    Posted Apr 07, 2015 10:48 AM

    Rob, you are my favorite person ever!