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.
