参数说明
音频
视频
共享
导出命令
音频
点对点音频
/****** Script for SelectTopNRows command from SSMS ******/
SELECT [ConferenceDateTime]
,[SessionTime]
,[SessionSeq]
,[ClassifiedPoorCall]
,[CallerPAI]
,[CalleePAI]
,[CallerUAType]
,[CalleeUAType]
,[CallerUserAgent]
,[CalleeUserAgent]
,[CallerEndpoint]
,[CalleeEndpoint]
,[ConferenceKey]
,[DialogCategory]
,[MediationServerBypassFlag]
,[CallerCaptureDev]
,[CalleeCaptureDev]
,[CallerRenderDev]
,[CalleeRenderDev]
,[IsPSTNCall]
,[IsConfCall]
,[IsUCCall]
,[CallInside]
,[CallVPN]
,[CallNetworkType]
FROM [QoEMetrics].[dbo].[QoEReportsCallListView]
where ClassifiedPoorCall = 1
and StartTime > '2023-8-1' and StartTime <'2023-8-31'
and IsConfCall = 0
and CallInside = 1
Order by StartTime
会议音频
/****** Script for SelectTopNRows command from SSMS ******/
SELECT [ConferenceDateTime] = dateadd(HOUR,8,ConferenceDateTime),
,[SessionTime]
,[SessionSeq]
,[ClassifiedPoorCall]
,[CallerPAI]
,[CalleePAI]
,[CallerUAType]
,[CalleeUAType]
,[CallerUserAgent]
,[CalleeUserAgent]
,[CallerEndpoint]
,[CalleeEndpoint]
,[ConferenceKey]
,[DialogCategory]
,[MediationServerBypassFlag]
,[CallerCaptureDev]
,[CalleeCaptureDev]
,[CallerRenderDev]
,[CalleeRenderDev]
,[IsPSTNCall]
,[IsConfCall]
,[IsUCCall]
,[CallInside]
,[CallVPN]
,[CallNetworkType]
FROM [QoEMetrics].[dbo].[QoEReportsCallListView]
where ClassifiedPoorCall = 1
and StartTime > '2023-8-1' and StartTime <'2023-8-31'
and IsConfCall = 1
and CallInside = 1
Order by StartTime
视频
点对点视频
/****** Script for SelectTopNRows command from SSMS ******/
SELECT [ConferenceDateTime]
,[SessionTime]
,[SessionSeq]
,[ClassifiedPoorCall]
,[CallerPAI]
,[CalleePAI]
,[CallerUAType]
,[CalleeUAType]
,[CallerUserAgent]
,[CalleeUserAgent]
,[CallerEndpoint]
,[CalleeEndpoint]
,[ConferenceKey]
,[MediationServerBypassFlag]
,[CallerCaptureDev]
,[CalleeCaptureDev]
,[CallerRenderDev]
,[CalleeRenderDev]
,[IsConfCall]
,[IsUCCall]
,[CallInside]
,[CallVPN]
,[CallNetworkType]
FROM [QoEMetrics].[dbo].[QoEReportsVideoCallListView]
where ClassifiedPoorCall = 1
and StartTime > '2023-8-1' and StartTime <'2023-8-31'
and IsConfCall = 0
and CallInside = 1
Order by StartTime
会议视频
/****** Script for SelectTopNRows command from SSMS ******/
SELECT [ConferenceDateTime]
,[SessionTime]
,[SessionSeq]
,[ClassifiedPoorCall]
,[CallerPAI]
,[CalleePAI]
,[CallerUAType]
,[CalleeUAType]
,[CallerUserAgent]
,[CalleeUserAgent]
,[CallerEndpoint]
,[CalleeEndpoint]
,[ConferenceKey]
,[MediationServerBypassFlag]
,[CallerCaptureDev]
,[CalleeCaptureDev]
,[CallerRenderDev]
,[CalleeRenderDev]
,[IsConfCall]
,[IsUCCall]
,[CallInside]
,[CallVPN]
,[CallNetworkType]
FROM [QoEMetrics].[dbo].[QoEReportsVideoCallListView]
where ClassifiedPoorCall = 1
and StartTime > '2023-8-1' and StartTime <'2023-8-31'
and IsConfCall = 1
and CallInside = 1
Order by StartTime
共享
点对点共享
SELECT [ConferenceDateTime]
,[SessionTime]
,[SessionSeq]
,[ClassifiedPoorCall]
,[CallerPAI]
,[CalleePAI]
,[CallerUAType]
,[CalleeUAType]
,[CallerUserAgent]
,[CalleeUserAgent]
,[CallerEndpoint]
,[CalleeEndpoint]
,[ConferenceKey]
,[MediationServerBypassFlag]
,[CallerCaptureDev]
,[CalleeCaptureDev]
,[CallerRenderDev]
,[CalleeRenderDev]
,[CallInside]
,[CallVPN]
,[CallNetworkType]
FROM [QoEMetrics].[dbo].[QoEReportsASCallListView]
where StartTime > '2023-8-1' and StartTime <'2023-8-31'
and ClassifiedPoorCall = 1
and CalleeUserAgent not like '%applicationsharing%'
and CallInside = 1
and CalleeEndpoint not like '%sfbfe%'
and CallerEndpoint not like 'NULL'
Order by StartTime
会议共享
SELECT [ConferenceDateTime]
,[SessionTime]
,[SessionSeq]
,[ClassifiedPoorCall]
,[CallerPAI]
,[CalleePAI]
,[CallerUAType]
,[CalleeUAType]
,[CallerUserAgent]
,[CalleeUserAgent]
,[CallerEndpoint]
,[CalleeEndpoint]
,[ConferenceKey]
,[MediationServerBypassFlag]
,[CallerCaptureDev]
,[CalleeCaptureDev]
,[CallerRenderDev]
,[CalleeRenderDev]
,[CallInside]
,[CallVPN]
,[CallNetworkType]
FROM [QoEMetrics].[dbo].[QoEReportsASCallListView]
where StartTime > '2023-8-1' and StartTime <'2023-8-31'
and ClassifiedPoorCall = 1
and CalleeUserAgent like '%applicationsharing%'
and CallInside = 1
and CalleeEndpoint like '%sfbfe%'
and CallerEndpoint not like 'NULL'
Order by StartTime
