RuggedCom RSG2488

RUGGEDCOM RSG2488
User Guide
Chapter 2
Using ROS
Using RSH and SQL 41
sql default into table
Where:
• table is the name of the table
Section 2.6.4.5
Using RSH and SQL
The combination of remote shell scripting and SQL commands offers a means to interrogate and maintain a
large number of devices. Consistency of configuration across sites may be verified by this method. The following
presents a simple example where the devices to interrogate are drawn from the file Devices:
C:> type Devices
10.0.1.1
10.0.1.2
10.0.1.3
c:\> for /F %i in (devices) do rsh %i -l admin,admin sql select from vlanportcfg where pvid
= 2
C:\>rsh 10.0.1.1 -l admin,admin sql select from vlanportcfg where pvid = 2
Port Trnk Port(s) Type PVID PVID Format GVRP GVRPStatus
1/2 0 1/2 Edge 2 Untagged Disabled Disabled
1 records selected
C:\>rsh 10.0.1.2 -l admin,admin sql select from vlanportcfg where pvid = 2
0 records selected
C:\>rsh 10.0.1.3 -l admin,admin sql select from vlanportcfg where pvid = 2
Port Trnk Port(s) Type PVID PVID Format GVRP GVRPStatus
1/1 0 1/1 Edge 2 Untagged Disabled Disabled
1/2 0 1/2 Edge 2 Untagged Disabled Disabled
1/3 0 1/3 Edge 2 Untagged Disabled Disabled
1/4 0 1/4 Edge 2 Untagged Disabled Disabled
5/1 0 5/1 Edge 2 Untagged Disabled Disabled
5/2 0 5/2 Edge 2 Untagged Disabled Disabled
5/3 0 5/3 Edge 2 Untagged Disabled Disabled
5/4 0 5/4 Edge 2 Untagged Disabled Disabled
8 records selected
C:\
Section 2.7
Managing the Flash File System
The following sections describe how to manage the flash file system:
• Section 2.7.1, “Viewing a List of Flash Files”
• Section 2.7.2, “Viewing a List of Flash File Details”
• Section 2.7.3, “Defragmenting the Flash File System”