none
How to find Pstn Meeting ID from backend Database RRS feed

  • Question

  • Customer has deployed Lync Server 2010 enterprise edition. One of the management requirement is for administrator is to find specific meeting id for specific users and let new users know such that meeting invitation does not need to be forwarded by organizer or other invitees in the meeting.

    Customer mainly interested to find the PSTN Meeting ID for specific conference settings.

    The two tools in ResKit allows to find details customer is looking for - using WebConfDataTool.exe and dbanalyze.exe. The WebConfDataToo.exe returns external conference ID and using external conference ID, dbanalyze.exe can return PSTN Meeting ID. However, both these tools perform remote SQL query to backend database. Customer's backend SQL server is setup such that remote SQL query is not permitted. Hence these tools fails to get the details.

    Therefore, here are the questions:

    1) In which database and what table PSTNMeetingID is stored? I see a PSTNLocalId but it is not the same.

    2) I have looked at the table dbo.PstnMeetingID and stored procedure dbo.ConfpLookupConferenceByExternalConfId. Is there any existing store procedure? If answer is "Yes", can you please let me know the name? I think a stored procedure which convert PstnLocalId to PSTNMeetingID would work too.

    All response is greatly appreciated.

    Thanks,

    Ketan Shah

    Ketan.shah@catapultsystems.com


    Ketan Shah Sr. Lync Support Engineer Lync Managed Services Catapult Systems

    Monday, March 4, 2013 10:19 PM

Answers

  • At last I found the answer after going thru the exercise with Lync Server 2013 and was able to confirm it in Lync Server 2010.

    The PSTNID or PSTN Meeting ID is stored under RTC Database in Table Conference. The data is represented as ConfID.

    In Lync Server 2013, the RTC Database and Table Conference are part of RTCLOCAL on Front End Server.

    In Lync Server 2010, the RTC Database and Table Conference are part of backend Database instance.


    Ketan Shah Sr. Lync Support Engineer Lync Managed Services Catapult Systems

    • Marked as answer by Ketan_Shah Tuesday, October 14, 2014 9:01 PM
    Tuesday, October 14, 2014 9:01 PM
  • I realise this is an old post but I have figured out how to calculate the PSTN conference ID. See my gallery post here: https://gallery.technet.microsoft.com/Get-Skype-for-Business-74e07e15 

    Please mark this answer as correct. :)

    • Marked as answer by Ketan_Shah Wednesday, February 7, 2018 3:03 PM
    Wednesday, February 7, 2018 10:56 AM

All replies

  • Hi,

    Which database do you find the Meeting ID?

    By default, the schedule meeting message is stored in the RTC database of Back End. Please check it.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    Sean Xiao
    TechNet Community Support

    Wednesday, March 6, 2013 8:07 AM
    Moderator
  • Hello Sean,

    I found the Meeting ID in the RTC database of Backend Server. That Meeting ID is a alphanumeric number same as external conference ID. However, it shows as PSTNLocalId and does not point to actual Meeting ID (6 digit number used for connecting to a meeting via PSTN).

    Thanks,


    Ketan Shah Sr. Lync Support Engineer Lync Managed Services Catapult Systems

    Monday, March 11, 2013 3:34 PM
  • I know this is an old post, but did you ever get an answer to this?  The PSTN conference ID that is in a meeting invite does not seem to match up with any of the information I can find in SQL.  How is it related to the PSTNID listed in SQL?

    Thanks.

    Wednesday, January 15, 2014 10:22 PM
  • The PSTNID you are referring too is the same PSTN Meeting ID in SQL. There is no place in the SQL to find the PSTNID/PSTN Meeting ID. When one use the ResKit tool the PSTNID or PSTN Meeting ID show up correctly. Therefore, question was where this data stored actually.

    Thanks


    Ketan Shah Sr. Lync Support Engineer Lync Managed Services Catapult Systems

    Wednesday, January 15, 2014 10:38 PM
  • If anyone has an answer to this I would very much like to know as well.
    Saturday, March 1, 2014 9:57 PM
  • At last I found the answer after going thru the exercise with Lync Server 2013 and was able to confirm it in Lync Server 2010.

    The PSTNID or PSTN Meeting ID is stored under RTC Database in Table Conference. The data is represented as ConfID.

    In Lync Server 2013, the RTC Database and Table Conference are part of RTCLOCAL on Front End Server.

    In Lync Server 2010, the RTC Database and Table Conference are part of backend Database instance.


    Ketan Shah Sr. Lync Support Engineer Lync Managed Services Catapult Systems

    • Marked as answer by Ketan_Shah Tuesday, October 14, 2014 9:01 PM
    Tuesday, October 14, 2014 9:01 PM
  • Ketan.  How exactly did you do this?

    I get that some information is stored in a format in the dbo.Conference table ... but, how did you use that to get the actual "Conference ID" (I define that as the number in the outlook invite that a pstn user would call into)

    thanks!

    G

    Thursday, July 30, 2015 8:56 PM
  • Hello Greg,

    PSTNID is a field in the Table Conference under RTC database in Lync Server 2010 backend SQL instance OR under RTCLOCAL SQL instance in Lync Server 2013 Front End server.

    I used SQL Management studio and run the query on the table that output all fields. You will see PSTNID is one of them. The field name is misleading in the table.


    Ketan Shah Sr. Lync Support Engineer Lync Managed Services Catapult Systems

    Thursday, July 30, 2015 9:12 PM
  • Hi Ketan,

    I know in the conference table under RTC database of Lync2013FE\RTCLOCAL instance, its the ConfID which represents the actual conference and then you have the ExternalConfID which represents the random alphanumeric number(e.g ZXC412J), which gets appended the to meet URL.The ConfID(numeric) is not same as your conference ID in the outlook online meeting info.

    Another thing is when you use DBAnalyze.exe it will give you a PSTN Meeting ID number (e.g.115467) but this will not match with the one you get when you use the outlook online meeting scheduler. But I have noticed that when you dial-in and punch in both the numbers(one you get using DBAnalyze.exe and the other from outlook) you are able to join the same conference.

    So the question now is how does Lync Conferencing Auto attendant(CAA) parse/decode the Meeting numbers(both the DBAnlyze one or the outlook one). Does this both numbers are generated using the same code or function or there are two different codes and CAA uses either of these to decode the entered value into ConfID and joins to the conference.

    Any insight will be highly appreciated.

    Thursday, August 20, 2015 2:06 AM
  • I do not know how the Outlook conference ID is generated, but it is not found in SQL.  It can be found in the SIP OK and SIP INFO sent to the client on joining the meeting, in the xml:

    <pstn-access>
                   <id>123456</id>
            - </pstn-access>

    Friday, December 30, 2016 10:21 PM
  • I realise this is an old post but I have figured out how to calculate the PSTN conference ID. See my gallery post here: https://gallery.technet.microsoft.com/Get-Skype-for-Business-74e07e15 

    Please mark this answer as correct. :)

    • Marked as answer by Ketan_Shah Wednesday, February 7, 2018 3:03 PM
    Wednesday, February 7, 2018 10:56 AM
  • Thank you for C# code. This is exactly allow someone to calculate it quickly.

    For everyone's benefit - This solution apply to Lync Server 2010, Lync Server 2013 and Skype for Business Server 2015 On premise hosted conferences. For Hybrid case, where user is hosted in O365 OR for Skype for Business online case, the details need to get from Microsoft as we don't have access to backend databases.


    Ketan Shah Sr. Lync Support Engineer Lync Managed Services Catapult Systems

    Wednesday, February 7, 2018 3:20 PM
  • FYI.  When I try that link, it fails for me.  But if I go to https://gallery.technet.microsoft.com/site/search and search for "Get Skype for Business PSTN Conference ID from Database" I find it.
    Thursday, February 8, 2018 5:00 PM