Skype for business CDR database - how to determine if user joined by phone

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

This query you can use to get Dial-in 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.

https://tech24online.com/2018/03/01/hello-world/