Filter
Top Products
RuggedSwitch™ User Guide
Finding The Correct Table
Many sql commands operate upon specific tables in the database, and require the
table name to be specified. The name can easily be determined by navigating the
menu system to the desired menu and pressing <CTRL Z>. The menu name and
the corresponding database table name will be cited.
Another way to find a table name is to run the “sql info tables” command. This
command also displays menu names and their corresponding database table names.
Figure 70 The sql command and SQL help
Retrieving Information
Retrieving A Table
The sql select subcommand is used to retrieve table information. The command
“sql select from tablename” provides a summary of the parameters within the
table, as well as their values.
Figure 71 Selecting a table
Retrieving A Parameter From A Table
A particular parameter from a table can be retrieved by selecting it, e.g. “sql select
parameter_name from tablename”. The parameter name is always the same as
those displayed in the menu system. If the parameter name has spaces in it (e.g.
“IP Address”) the spaces must be replaced with underscores or the name must be
quoted.
Figure 72 Select a parameter with a table
>sql info tables
Table Description
-------------------------------------------------------------------------------
alarms Alarms
cpuDiags CPU Diagnostics
ethPortCfg Port Parameters
ethPortStats Ethernet Statistics
ethPortStatus Port Status
ipCfg IP Services
>sql select from ipcfg
IP Address Type IP Address Subnet Gateway Inactivity Timeo
ut Telnet Sessions Allowed TFTP Server SNMP Get Community
Static 10.9.0.2 255.0.0.0 10.0.0.254 Disabled
8 Enabled public
>sql select “ip address” from ipcfg
IP Address
10.9.0.2
RuggedCom