Handling of existing Conference Dial-in numbers


Summary

This article provides a summary for handling of existing Conference Dial-in numbers.

Applies To

This article applies to MachPanel build v5.3.10.

Dial-in Conferencing Access Numbers

1. Existing Conference Numbers

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
2. New Numbers

Add/ Edit new numbers will work fine with the new implementation.

3. Call Records Processing    

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.