What are the commands to check the database of Aruba Access Points effectively?

MVP Expert
MVP Expert
Q:

What are the commands to check the database of Aruba Access Points effectively?



A:

"Show ap database" is the CLI command, which is very frequently used by WLAN administrators. In general this command will provide the details of all the Access
Points associated to the mobility domain.

In some situations if we need to narrow our search of the Access Points we can execute the below commands to get exactly what we need.


Command: show ap database 
This will provide the basic information of all the Access Points associated to the mobility domain regardless of which controller it is associated too.
(ArubaMaster) #show ap database

AP Database
-----------
Name               Group  AP Type  IP Address     Status             Flags  Switch IP      Standby IP
----               -----  -------  ----------     ------             -----  ---------      ----------
00:0b:86:8e:f5:50  RAP    RAP-3WN  10.10.10.2     Down               Rc2    10.17.171.107  0.0.0.0
ac:a3:1e:cd:80:3c  Test   325      10.17.171.124  Up 91d:0h:30m:8s   I      10.17.171.99   0.0.0.0
AP1                LC1    225      10.17.170.126  Down                      10.17.171.106  0.0.0.0
AP2                LC1    105      10.17.171.123  Up 91d:0h:17m:18s         10.17.171.100  10.17.171.101
AP3                LC2    115      10.17.171.125  Up 91d:0h:14m:32s         10.17.171.101  10.17.171.100

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:5
Command: show ap database long 
This command will provide more information about the Access Points (Wired MAC Address , Serial # , Port , FQLN , Outer IP  and User).
(ArubaMaster) #show ap database long

AP Database
-----------
Name               Group  AP Type  IP Address     Status             Flags  Switch IP      Standby IP     Wired MAC Address  Serial #   Port  FQLN  Outer IP      
User
----               -----  -------  ----------     ------             -----  ---------      ----------     -----------------  --------   ----  ----  --------      
----
00:0b:86:8e:f5:50  RAP    RAP-3WN  10.10.10.2     Down               Rc2    10.17.171.107  0.0.0.0        00:0b:86:8e:f5:50  BF0051739        N/A   10.17.171.120
ac:a3:1e:cd:80:3c  Test   325      10.17.171.124  Up 91d:0h:57m:0s   I      10.17.171.99   0.0.0.0        ac:a3:1e:cd:80:3c  DD0010217  N/A   N/A   N/A
AP1                LC1    225      10.17.170.126  Down                      10.17.171.106  0.0.0.0        18:64:72:c9:97:54  CT0074976        N/A   N/A
AP2                LC1    105      10.17.171.123  Up 91d:0h:44m:10s         10.17.171.100  10.17.171.101  24:de:c6:cc:fa:c6  BT0684904        N/A   N/A
AP3                LC2    115      10.17.171.125  Up 91d:0h:41m:22s         10.17.171.101  10.17.171.100  18:64:72:c2:07:fe  CJ0087056        N/A   N/A

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Port information is available only on 6xx.

Total APs:5
Command: show ap database flags <flag>
This command will provide the information about the Access Points that are UP with flag mentioned.
(ArubaMaster) #show ap database flags I

AP Database
-----------
Name               Group  AP Type  IP Address     Status             Flags  Switch IP     Standby IP
----               -----  -------  ----------     ------             -----  ---------     ----------
ac:a3:1e:cd:80:3c  Test   325      10.17.171.124  Up 91d:0h:57m:38s  I      10.17.171.99  0.0.0.0

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:1
Command show ap database inactive 
This command will provide the information about the Access Point that are UP but inactive.
(ArubaMaster) #show ap database inactive

AP Database
-----------
Name               Group  AP Type  IP Address     Status             Flags  Switch IP     Standby IP
----               -----  -------  ----------     ------             -----  ---------     ----------
ac:a3:1e:cd:80:3c  Test   325      10.17.171.124  Up 91d:0h:59m:59s  I      10.17.171.99  0.0.0.0

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:1
Command: show ap database group <group name>
This command will provide the information about the Access Points that are up within the specific group.
(ArubaMaster) #show ap database group LC1

AP Database
-----------
Name  Group  AP Type  IP Address     Status             Flags  Switch IP      Standby IP
----  -----  -------  ----------     ------             -----  ---------      ----------
AP1   LC1    225      10.17.170.126  Down                      10.17.171.106  0.0.0.0
AP2   LC1    105      10.17.171.123  Up 91d:0h:47m:59s         10.17.171.100  10.17.171.101

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:2
Command : show ap database status <up/down>
This command will provide the details of the Access Points based on their status.
(ArubaMaster) #show ap database status up

AP Database
-----------
Name               Group  AP Type  IP Address     Status             Flags  Switch IP      Standby IP
----               -----  -------  ----------     ------             -----  ---------      ----------
ac:a3:1e:cd:80:3c  Test   325      10.17.171.124  Up 91d:1h:3m:4s    I      10.17.171.99   0.0.0.0
AP2                LC1    105      10.17.171.123  Up 91d:0h:50m:14s         10.17.171.100  10.17.171.101
AP3                LC2    115      10.17.171.125  Up 91d:0h:47m:25s         10.17.171.101  10.17.171.100

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:3
Command: show ap database <indoor/outdoor>
This command will provide the details of the Access Points based on how it has provisioned.
(ArubaMaster) #show ap database indoor

AP Database
-----------
Name               Group  AP Type  IP Address     Status            Flags  Switch IP     Standby IP
----               -----  -------  ----------     ------            -----  ---------     ----------
ac:a3:1e:cd:80:3c  Test   325      10.17.171.124  Up 91d:1h:5m:44s  I      10.17.171.99  0.0.0.0

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:1
Command: show ap database page <number>
This command will provide the details of the Access Points based on the number of lines we mention.
(ArubaMaster) #show ap database page 4

AP Database
-----------
Name               Group  AP Type  IP Address     Status             Flags  Switch IP      Standby IP
----               -----  -------  ----------     ------             -----  ---------      ----------
00:0b:86:8e:f5:50  RAP    RAP-3WN  10.10.10.2     Down               Rc2    10.17.171.107  0.0.0.0
ac:a3:1e:cd:80:3c  Test   325      10.17.171.124  Up 91d:1h:17m:50s  I      10.17.171.99   0.0.0.0
AP1                LC1    225      10.17.170.126  Down                      10.17.171.106  0.0.0.0
AP2                LC1    105      10.17.171.123  Up 91d:1h:5m:0s           10.17.171.100  10.17.171.101

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:5
Command: show ap database switch <ip address of the controller>
This command will provide the details of the Access Points to which controller it is associated based on the controller IP address mentioned.
(ArubaMaster) #show ap database switch 10.17.171.101

AP Database
-----------
Name  Group  AP Type  IP Address     Status            Flags  Switch IP      Standby IP
----  -----  -------  ----------     ------            -----  ---------      ----------
AP3   LC2    115      10.17.171.125  Up 91d:1h:5m:29s         10.17.171.101  10.17.171.100

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:1
Command: show ap database unprovisioned 
This command will provide the details of the Access Points that are unprovisioned, which are missing some provisioning parameters (antenna gain, etc.,).
(ArubaMaster) #show ap database unprovisioned

AP Database
-----------
Name  Group  AP Type  IP Address  Status  Flags  Switch IP  Standby IP
----  -----  -------  ----------  ------  -----  ---------  ----------

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:0
Command: show ap database usb
This command will provide the details of the Access Points that are provisioned with USB parameters.
(ArubaMaster) #show ap database usb

AP Database
-----------
Name               Group  AP Type  IP Address     Status             Flags  Switch IP      Standby IP     USB Status  USB Vendor  USB Product  USB RSSI  USB N/w
Service  USB Firmware Version
----               -----  -------  ----------     ------             -----  ---------      ----------     ----------  ----------  -----------  --------  
---------------  --------------------
00:0b:86:8e:f5:50  RAP    RAP-3WN  10.10.10.2     Down               Rc2    10.17.171.107  0.0.0.0
ac:a3:1e:cd:80:3c  Test   325      10.17.171.124  Up 91d:1h:24m:13s  I      10.17.171.99   0.0.0.0
AP1                LC1    225      10.17.170.126  Down                      10.17.171.106  0.0.0.0
AP2                LC1    105      10.17.171.123  Up 91d:1h:11m:23s         10.17.171.100  10.17.171.101
AP3                LC2    115      10.17.171.125  Up 91d:1h:8m:32s          10.17.171.101  10.17.171.100

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:5
Command: show ap database sort-direction <ascending/descending>
This command will provide the details of the Access Points that are sorted based on the ascending/descending considering the name of the AP.
(ArubaMaster) #show ap database sort-direction ascending

AP Database
-----------
Name               Group  AP Type  IP Address     Status             Flags  Switch IP      Standby IP
----               -----  -------  ----------     ------             -----  ---------      ----------
00:0b:86:8e:f5:50  RAP    RAP-3WN  10.10.10.2     Down               Rc2    10.17.171.107  0.0.0.0
ac:a3:1e:cd:80:3c  Test   325      10.17.171.124  Up 91d:1h:30m:39s  I      10.17.171.99   0.0.0.0
AP1                LC1    225      10.17.170.126  Down                      10.17.171.106  0.0.0.0
AP2                LC1    105      10.17.171.123  Up 91d:1h:17m:49s         10.17.171.100  10.17.171.101
AP3                LC2    115      10.17.171.125  Up 91d:1h:14m:58s         10.17.171.101  10.17.171.100

Flags: U = Unprovisioned; N = Duplicate name; G = No such group; L = Unlicensed
       I = Inactive; D = Dirty or no config; E = Regulatory Domain Mismatch
       X = Maintenance Mode; P = PPPoE AP; B = Built-in AP; s = LACP striping
       R = Remote AP; R- = Remote AP requires Auth; C = Cellular RAP;
       c = CERT-based RAP; 1 = 802.1x authenticated AP; 2 = Using IKE version 2
       u = Custom-Cert RAP; S = Standby-mode AP; J = USB cert at AP
       i = Indoor; o = Outdoor
       M = Mesh node; Y = Mesh Recovery

Total APs:5
Command: show ap database sort-by <ap-flags><ap-group><ap-ip><ap-mac><ap-name><ap-serial><ap-type><fqln><provisioned><status><uptime><switch-ip>
This command will provide the details of the Access Points sort by many parameters.
Version history
Revision #:
2 of 2
Last update:
‎03-18-2019 02:12 AM
Updated by:
 
Labels (1)
Contributors
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: