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

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.

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,

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.

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

If anyone has an answer to this I would very much like to know as well.

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.  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

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.

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.