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.
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>select count(*) from ua5000_adsl_PortTab where adslNMSLineProfileName = 'Bigfoot_Profile2_8M_384K'