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 Query the Configuration of Test Group in Database

Publication Date:  2012-07-24 Views:  24 Downloads:  0
Issue Description
Q:
You need to configure the test group on the NMS or synchronize the configuration information of the test groups with the corresponding information of the device in case of internal or external line test. Then: how to query the configuration information in the database?
Alarm Information
Null
Handling Process
A:
Access the compiling environment of isql language, and query the configuration information of the test group by entering the following sentences: 
1>use BMSDB
2>go
1. Find the Device ID of the device in the database according to the device IP.
1>select * from bms_gdm_DeviceTab where IP like 'x.x.x.x'
2>go
7676013 ua5000pvm                                                          
         192.168.1.3                                                            
         PVMV100R011B02D087
The 7667713 is Device ID.
2. Query the configuration information of the test group in the corresponding table according to the Device ID obtained in the last step:
1>use BMSDB
2>go
1>select * from bms_test_TestGroupFrameTab where DeviceID=xxxxxxx
2>go
GroupID     DeviceID    FrameID    
         Frame Name                                          Frame Type   
 ----------- ----------- ----------- 
        -------------------------------------------------- ----------- 
           0     7676013           0
         Frame 0:PVUMAINHABA                                            900 
Block 0: PVUMAINHABA                                      900
          -1     7676013           1
         Frame 1:SLAVE_HABS_30(HABA)                                   1502 
Block 1: SLAVE_HABS_30(HABA)                             1502
(2 rows affected)
GroupID refers to the number of the test group where each frame is located. In general, one device only has one TSS board. Therefore, each frame is contained in the test group No. 0. The Group ID -1 indicates the frame does not belong to any test group.
At the same time, if you want to add the frame 1 to the test group No. 0, you can use the following commands and then restart the background process of the line test.
1>use BMSDB
2>go
1>update bms_test_TestGroupFrameTab set GroupID=0 where DeviceID =7676013
2>go
Root Cause
Null
Suggestions
Null

END