This article provides a summary for handling of existing Conference Dial-in numbers.
This article applies to MachPanel build v5.3.10.
Please update existing numbers with the help of following scripts:
Update “SGMemberId” of all numbers
UPDATE HB_tblLyncConferenceDialIn SET SGMemberId = 123*
Update “SGMemberId” of numbers starting with some digits
UPDATE HB_tblLyncConferenceDialIn SET SGMemberId = 123*
WHERE Number LIKE '+21%'
Update “SGMemberId” of some specific number
UPDATE HB_tblLyncConferenceDialIn SET SGMemberId = 123*
WHERE Number = '+21345678'
Update “SIPUri” of a number
UPDATE HB_tblLyncConferenceDialIn SET SIPUri = 'sip:+123456@somedomain.com'
WHERE Number = '+213456789'
Note: Replace 123* with the corresponding Lync Server Group Member Id and can be obtained from “HB_tblOCSServerGroupMembers”
Following columns must be set for the existing numbers:
- SGMemberId
- SIPURI
- PrimaryLanguage
- Regions
Add/ Edit new numbers will work fine with the new implementation.
Conference numbers are used to separate conference calls from the normal
calls. In Call Records Processing for each organization, please keep in
mind that only the numbers associated to any Server Group member will
be sent for call records processing for an organization associated to
that server group member.