RuggedCom RSG2488 User Manual

RUGGEDCOM RSG2488
User Guide
Chapter 2
Using ROS
Retrieving Information 39
IP Address Subnet IfIndex IfStats IfTime IfName
172.30.146.88 255.255.224.0 1001 17007888 2994 default
192.168.0.1 255.255.255.0 1002 17007672 3195 vlan1
2 records selected
Retrieving Information About a Parameter from a Table
Use the following command to retrieve information about a specific parameter from a table:
NOTE
The parameter name must be the same as it is displayed in the menu system, unless the name
contains spaces (e.g. ip address). Spaces must be replaced with underscores (e.g. ip_address) or the
parameter name must be wrapped in double quotes (e.g. "ip address").
sql select parameter from table
Where:
• parameter is the name of the parameter
• table is the name of the table
Example:
>sql select "ip address" from ipSwitchIfCfg
IP Address
192.168.0.1
1 records selected
Retrieving Information from a Table Using the Where Clause
Use the following command to display specific parameters from a table that have a specific value:
sql select from table where parameter = value
Where:
• table is the name of the table
• parameter is the name of the parameter
• value is the value of the parameter
Example:
>sql select from ethportcfg where media = 1000T
Port Name ifName Media State AutoN Speed Dupx FlowCtrl LFI
Alarm
1/1 Port 1 1/1 1000T Enabled On Auto Auto Off Off On
1/2 Port 2 1/2 1000T Enabled On Auto Auto Off Off On
1/3 Port 3 1/3 1000T Enabled On Auto Auto Off Off On
1/4 Port 4 1/4 1000T Enabled On Auto Auto Off Off On
4 records selected
Further refine the results by using and or or operators:

RuggedCom RSG2488 Specifications

General

Brand	RuggedCom
Model	RSG2488
Category	Switch
Language	English