Skype for Business外呼呼叫记录查询SQL语句

Skype for Business外呼呼叫记录查询调用存档数据库LcsCDR视图表VoipDetailsView，此表数据时间基于格林尼治时间，需要在此基础上加8小时东八区(UTC/GMT+08:00)。删除一些不常使用的字段，外呼呼叫记录查询SQL语句如下。

SELECT DATEADD(hour,8, [SessionIdTime]) as [SessionIdTime] ,DATEADD(hour,8, [InviteTime]) as [InviteTime] ,[FromUri] ,[ToUri] ,[FromUriType] ,[ToUriType] ,DATEADD(hour,8, [EndTime]) as [EndTime] ,[FromClientVersion] ,[FromClientType] ,[FromClientCategory] ,[ToClientVersion] ,[ToClientType] ,[ToClientCategory] ,[TargetUri] ,[TargetUriType] ,DATEADD(hour,8, [ResponseTime]) as [ResponseTime] ,[ResponseCode] ,[DiagnosticId] ,[FrontEnd] ,[Pool] ,[FromEdgeServer] ,[ToEdgeServer] ,[IsFromInternal] ,[IsToInternal] ,DATEADD(hour,8, [LastModifiedTime]) as [LastModifiedTime] ,[FromPhone] ,[ToPhone] ,[DisconnectedByUri] ,[DisconnectedByUriType] ,[DisconnectedByPhone] ,[FromMediationServer] ,[ToMediationServer] ,[FromGateway] ,[ToGateway] FROM [LcsCDR].[dbo].[VoipDetailsView] where FromUri = ‘qiangshengyang@yangqs.com’ and ResponseCode = 200 order by SessionIdTime desc