No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FAQ-How to Export the Information of the ADSL Port State and the Bandwidth From the Database

Publication Date:  2012-07-24 Views:  38 Downloads:  0
Issue Description
Q:
The graphic interface displays the port information of a single board once. To query the port information of the whole network equipment through the graphic interface is very complex and difficult. Extract the information of the ADSL port state and the bandwidth from the database. The case provides the export method under the V200R008B02D061 version.
Alarm Information
Null
Handling Process
A:
Copy the attachment to disk C (For Solaris system, transfer the files to the server through the ASCII).
Open a CMD window, and then run isql -Usa -Pxxx -Sxxx -iscript.txt -output.scv. The result is recorded in output.csv. P is followed by the password of the sa database. S is followed by the database name.
For the exported data, name is the node name; FN, SN, PN is the port number of the frame; adslAtucCurrStatus is the port state. The numerated value is defined as:
9: Activate
10: Activating
11: Deactivate
20: Block
Rate is the downlink rate. K is the unit.
Root Cause
Null
Suggestions
Null

END