database

Displays database-related statistics and status

Supported in the following platforms:

Syntax

show database [backup-status|keyfile|restore-status|statistics|status|users] 
{on <DEVICE-NAME>}

Parameters

show database [backup-status|keyfile|restore-status|statistics|status|users] 
{on <DEVICE-NAME>}
database Displays all configured database-related statistics and status
backup-status Displays the last database backup status
keyfile Displays the keyfiles generated on the database host to enable authenticated database access
back-restore Displays the last database restore status
statistics Displays database-related statistics, such as name of the database (NSight or captive portal), data size, storage size, free disk space available, etc.
status Displays database status, such as online time.
users Displays database users created. These are the users that can access the databases.
on <DEVICE-NAME> Optional. Displays database-related information on a specified device
  • <DEVICE-NAME> – Specify the name of the AP, wireless controller, or service platform.

Examples

vx9000-D031F2(config)#show database backup-status detail
Last Database Backup Status : Failed(Error in ftp: 1)
Last Database Backup Time   : 2017-04-11 08:03:10
-----------------------------------------------
Starting backup of mart ...
connected to: 127.0.0.1
2015-05-20T14:02:46.340+0530 DATABASE: mart         to         dump/mart
2015-05-20T14:02:46.341+0530         mart.system.indexes to dump/mart/system.indexes.bson
2015-05-20T14:02:46.341+0530                  61 documents
2015-05-20T14:02:46.341+0530         mart.wlan_info to dump/mart/wlan_info.bson
2015-05-20T14:02:46.341+0530                  5 documents
2015-05-20T14:02:46.342+0530         Metadata for mart.wlan_info to dump/mart/wlan_info.metadata.json
2015-05-20T14:02:46.342+0530         mart.rf_domain_info to dump/mart/rf_domain_info.bson
2015-05-20T14:02:46.342+0530                  21 documents
2015-05-20T14:02:46.342+0530         Metadata for mart.rf_domain_info to dump/mart/rf_domain_info.metadata.json
--More--
vx9000-D031F2(config)#
vx9000-D031F2(config)#show database status
--------------------------------------------------------------------------------
        MEMBER             STATE                     ONLINE TIME
--------------------------------------------------------------------------------
  localhost           PRIMARY           2 days 3 hours 45 min 24 sec
--------------------------------------------------------------------------------
 Authentication: Disabled                Authentication User: None
--------------------------------------------------------------------------------
[*] indicates this device.
vx9000-D031F2(config)#
vx9000-D031F2(config)#show database statistics
--------------------------------------------------------------------------------
       DATABASE        STORAGE SIZE   DATA SIZE     INDEX SIZE     DISK FREE
--------------------------------------------------------------------------------
  admin               32k             335          48k           594.5G
  captive-portal      4k              0            24k           594.5G
  nsightcache         96k             2.0k         264k          594.5G
  nsight              26.1M           136.6M       18.9M         594.5G
--------------------------------------------------------------------------------
vx9000-D031F2(config)#
nx9500-6C8809#show database keyfile

SLz6lVXyi9vyTCChUKs04THRo3mWOjZheM58Dt6NC0MDkdgV+5+wWN9/IT6zfy1s
KPut4BPpUWyM8MEaRmapg4kRrN/SMSMlH6sPITMGTLMu6wRYFEUgKgO01Wn/BohE
5n+uuhY0xiZQsN0LS7IaA8Yb9rX859YRQ7v9By5aEpi1NIDR4KX09Xs3TqIB+5v2
jE3vv7OsKK+LX63bCIoYo35MX251T2pHdL+fMdLfKPMt8ZbzYzx2b22Yvukfg0gm
xHsMCB+bLAsfkjeCPgHCAq/WWi3Kxna6ysFjp8J4US2Bm+GL1COvALbCQBwkPPN+
o7M90qT40AubibBkeID2S9rkQkKcXqGESbL5xG6ip+26jIxiLv7GP6/SQZGFOqC/
ZZEkCNhGhkiyktiOIxBfoXwoy66sqQ4KBwLF449eqBe7Svel/dzpFPNfYZpW8SMY
LD6iLTPR9BddjsBBej8kGGc5R+M0R6lgQFEew2WX6Rqz45YTGEcfOkl8c9wl3taD
xn4imhI/esjMppFDu5muxRHF5RHa5RncTGnsMfc7ndvUl78QaGHLZvDqjNLBUnuP
c8QmyohEnKf70TYx/ruG9Vb2AP0Jw5OODTNh2lmaoFjicKYQr+xIHUJpHc0qY43C
5WzlWf84CK67cu7kOPiJoaxvufzSXhJB18BiCXTuv40+ZZ6e3PcisZuIrPXxCZup
GJ3KpuHq61IJyVCydFd5zl4Fho+RGaQ9dlDIlaLjbW+YT4CEH1bTiUmreUt+D/X2
zcB9nec77wIIAcdfl2qysgGIqmkI3jRI89d3XM5Y7Kc2TuXBVZOazYldPj+qE/yi
EgVWcbtvyS834jit35MGbVXhvQ2d45qgo42WZwdTVLXC9memzoKa3YIZoj32uP3U
iOrzD8E1gMte4gDE/KmGkYya+hsWswBmKC1v0gj5NQ6TejYS4z+nefqLHUSVXbQ8
NxRel1huGi8P1ns4dWCwClWp8GpxUTa7GuN1DySA7/l2OJM=

nx9500-6C8809#