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