Lync Server 2013 Microsoft SQL Script Skype for Business Server 2015 Tech Community Troubleshooting

Skype for Business Mirroring setup fails with “An exception occurred while executing a Transact-SQL statement or batch”

Skype for Business Mirroring setup fails with “An exception occurred while executing a Transact-SQL statement or batch” Error setting up mirroring or witness for database rtcxds: Microsoft.Rtc.Management.Deployment.MirrorDatabaseException: Cannot set up witness for database “rtcxds”. Exception: Microsoft.SqlServer.Management.Smo.FailedOperationException: Alter failed for Database ‘rtcxds’. —> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. —> System.Data.SqlClient.SqlException: The […]

Tech Community Lync Server 2013 Microsoft SQL Script Skype for Business Server 2015 Skype for Business Server 2019 Troubleshooting

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

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 […]