Turn on logs in Skype for Business Federation

Question

We have are running SFB 2015 on-perm and enabled Federation only with two external compaies. I want to be able to monitor who are utilizing the Federation connectoin to these comapies. I did try to check event logs for application\Lync and Windows Logs but I didnt see any logs showing who and when are utilizing the Federation connection (on Edge and Front End) is there are way for me to monitor who is utilizing Federation? speaical Voice calls and conference with Audio.

ramy amer · Answer

Script to provide Federated users conferencing.&nbsp;USE LcsCDR

DECLARE @StartDate datetime
DECLARE @EndDate datetime
DECLARE @DayScan datetime

SET @StartDate = '2017-04-15T00:00:00'
SET @EndDate = '2017-05-15T00:00:00'
SET @DayScan = GETDATE()-30 --Gets date from 30 prior to execution of the query

SELECT [InviteTime]
      ,[EndTime]
      ,LEFT([ConferenceUri], CHARINDEX(';', [ConferenceUri]) - 1) As [Organizer]
         ,[UserUri] AS [Participants]
         ,[UserUriType]
         ,[UserClientCategory] AS [Client Type]
      ,[IsUserInternal]
      ,[ConferenceInstance]
      ,[McuConferenceUriType]
         ,[ConferenceUri]
      ,[ConferenceClientCategory]
      ,[FrontEnd]
      ,[Pool]
      ,[MediationServer]
      ,[Gateway]
      ,[EdgeServer]
  FROM [LcsCDR].[dbo].[ConferenceSessionDetailsView]
  WHERE (InviteTime &gt;= @StartDate --Comment this line out if the DayScan variable in the next line is used 
              --WHERE InviteTime &gt;= @DayScan
        AND InviteTime &lt;= @EndDate) --Comment this line out if the DayScan variable in the previous line is used
        AND (UserClientCategory = 'OC' OR UserClientCategory = 'UCWA' OR UserClientCategory = 'OCPhone' OR UserClientCategory = 'iPhoneLync' OR UserClientCategory = 'AndroidLync' OR UserClientCategory = 'iPadLync' OR UserClientCategory = 'NokiaLync'OR UserClientCategory = 'LWA')
        AND McuConferenceUriType is not NULL
              AND UserUri NOT LIKE '%@companysipdomain.com' –Change this line and add the domain.com in question.  If multiple sip domains, copy this line and paste it on the next line and change the sip domain accordingly

AND UserUri NOT LIKE '%anonymous%'
ORDER by ConferenceInstance,InviteTime ASC

anthony caragol · Answer

Yeah, you'll want to set up monitoring for this:&nbsp;https://technet.microsoft.com/en-us/library/jj204937.aspx you'll want a SQL instance for this as well with SSRS (can't use SQL Express). &nbsp;With that you can search through the reports or write your own SQL queries to get the info.&nbsp;

ramy amer · Answer

Hi Anthony,&nbsp;I do have moniotor in place and I can see conference activity report and conference activity by authentication type but it only give me number of federated calls\Conf. I need to be able to see the user ID that participate in these calls or atleast the conference ID to check who are the participated users.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anthony caragol · Answer

Right, you'd have to dig down deeper into individual calls, or more likely if you had a specific report in mind you'd want to run your own SQL Query against the sessiondetails table joined with the Users table.

ramy amer · Answer

Thanks, Anthony,&nbsp;I still don't&nbsp;find the answer to my question but thank you anyway I will keep searching and once I figure it out I will share my results. BTW session table and Users table doesn't&nbsp;have anything related to federation. so far only activity by authentication&nbsp;type the only one that shows&nbsp;if Federation&nbsp;has been utilized.&nbsp;Again thank you, Anthony.&nbsp;

Forum Discussion

Turn on logs in Skype for Business Federation

7 Replies

Resources