Sql Query/Script to get Skype for Business/ Lync 2013 Dial-in Conferencing QOE

0
123
Reading Time: < 1 minute

Sql Query/Script to get Skype for Business/ Lync 2013 Dial-in Conferencing QOE

This query you can use to get Skype for Business Dial-in conference media quality and also filter with time and phone number.

==============================================

select fu.URI as CallingUser, tu.URI as CalledUser, *

from [QoEMetrics].[dbo].[Session] as sd

left outer join [QoEMetrics].[dbo].[User] as tu on sd.CalleePAI = tu.UserKey

left outer join [QoEMetrics].[dbo].[User] as fu on sd.CallerPAI = fu.UserKey

where CalleePAI like ‘%1241790%’ and ConferenceDateTime > (getutcdate() – 30)

order by ConferenceDateTime

===============================================================

Here you need to modify your number in CalleePAI like ‘%yournumber%’ and define the number days in  (getutcdate() – Numberofdays)

Sometimes running sql queries affects the database performance and its data so make sure you analyse its impact on your Skype/Lync 2013 environment and run it on own risk.

LEAVE A REPLY

Please enter your comment!
Please enter your name here