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 get the sum of line profiles which are refered by all devices

Publication Date:  2012-07-24 Views:  45 Downloads:  0
Issue Description
Q:
The customer want to know the sum of line profiles which are refered by all devices UA5000. Please refer to the attachment,we can see that lots of devices are referring to the line profile "Bigfoot_Profile2_8M_384K", it's not easy to count all the reference ports number. And the reference ports number can't be copied from the BMS to the Microsoft Office Excel.
Alarm Information
null
Handling Process
A:
The BMS version is R8
The problem can be solved by querying the Database. The detail steps is as following:
isql -U*** -P*** -SN2000DBServer
1>use BMSDB
2>go
1>select count(*) from ua5000_adsl_PortTab where adslNMSLineProfileName = 'Bigfoot_Profile2_8M_384K'
2>go
Root Cause
null
Suggestions
null

END