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.
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:
Rate is the downlink rate. K is the unit.