-
Notifications
You must be signed in to change notification settings - Fork 21
Upgrade Kusto Schema
Justin Walker edited this page Dec 12, 2024
·
1 revision
These steps are required if you previously deployed Call Record Insights on a version below 1.2 and have upgraded to version 1.2 or above to add the new columns and schema.
Warning
These steps must be completed in order to ensure no data loss and full functionality
This step is optional but recommended to ensure no data loss if a step is done incorrectly.
.set BackupCallRecords
<| CallRecords
.alter-merge table CallRecords (Organizer_DisplayName:string,Organizer_TenantId:guid,Organizer_IdType:string,Callee_Id:string,Callee_UserPrincipalName:string,Callee_DisplayName:string,Callee_TenantId:guid,Callee_IdType:string,Caller_Id:string,Caller_UserPrincipalName:string,Caller_DisplayName:string,Caller_TenantId:guid,Caller_IdType:string)
Warning
ANY EXISTING COLUMNS MISSING FROM THIS STATEMENT WILL HAVE NON-RECOVERABLE DATALOSS!
.alter table CallRecords (CallRecordTenantIdContext:string, CallId:guid, SessionId:guid, StreamId:string, StreamDirection:string, MediaLabel:string, CallStartTime:datetime, CallEndTime:datetime, SessionStartTime:datetime, SessionEndTime:datetime, LastModifiedDateTimeOffset:datetime, CallType:string, JoinWebUrl:string, VideoCodec:string, AudioCodec:string, WasMediaBypassed:bool, FailureStage:string, FailureReason:string, PacketUtilization:long, AverageBandwidthEstimate:long, AverageJitter:timespan, MaxJitter:timespan, AverageRoundTripTime:timespan, MaxRoundTripTime:timespan, AverageAudioNetworkJitter:timespan, MaxAudioNetworkJitter:timespan, AverageAudioDegradation:real, AveragePacketLossRate:real, MaxPacketLossRate:real, PostForwardErrorCorrectionPacketLossRate:real, AverageRatioOfConcealedSamples:real, MaxRatioOfConcealedSamples:real, LowVideoProcessingCapabilityRatio:real, AverageVideoFrameRate:real, AverageReceivedFrameRate:real, LowFrameRateRatio:real, AverageVideoPacketLossRate:real, AverageVideoFrameLossPercentage:real, Organizer_UserDisplayName:string, Organizer_UserId:guid, Organizer_UserTenantId:guid, Organizer_ApplicationInstanceDisplayName:string, Organizer_ApplicationInstanceId:guid, Organizer_ApplicationInstanceTenantId:guid, Organizer_GuestDisplayName:string, Organizer_GuestId:guid, Organizer_GuestTenantId:guid, Organizer_PhoneDisplayName:string, Organizer_PhoneId:string, Organizer_PhoneTenantId:guid, Organizer_OnPremisesDisplayName:string, Organizer_OnPremisesId:guid, Organizer_OnPremisesTenantId:guid, Organizer_EncryptedDisplayName:string, Organizer_EncryptedId:guid, Organizer_EncryptedTenantId:guid, Organizer_AcsUserDisplayName:string, Organizer_AcsUserId:guid, Organizer_AcsUserTenantId:guid, Organizer_SpoolUserDisplayName:string, Organizer_SpoolUserId:guid, Organizer_SpoolUserTenantId:guid, Organizer_AcsApplicationInstanceDisplayName:string, Organizer_AcsApplicationInstanceId:guid, Organizer_AcsApplicationInstanceTenantId:guid, Organizer_SpoolApplicationInstanceDisplayName:string, Organizer_SpoolApplicationInstanceId:guid, Organizer_SpoolApplicationInstanceTenantId:guid, Organizer_Id:string, Organizer_UserPrincipalName:string, Organizer_DisplayName:string, Organizer_TenantId:guid, Organizer_IdType:string, Callee_UserDisplayName:string, Callee_UserId:guid, Callee_UserTenantId:guid, Callee_ApplicationInstanceDisplayName:string, Callee_ApplicationInstanceId:guid, Callee_ApplicationInstanceTenantId:guid, Callee_GuestDisplayName:string, Callee_GuestId:guid, Callee_GuestTenantId:guid, Callee_PhoneDisplayName:string, Callee_PhoneId:string, Callee_PhoneTenantId:guid, Callee_OnPremisesDisplayName:string, Callee_OnPremisesId:guid, Callee_OnPremisesTenantId:guid, Callee_EncryptedDisplayName:string, Callee_EncryptedId:guid, Callee_EncryptedTenantId:guid, Callee_AcsUserDisplayName:string, Callee_AcsUserId:guid, Callee_AcsUserTenantId:guid, Callee_SpoolUserDisplayName:string, Callee_SpoolUserId:guid, Callee_SpoolUserTenantId:guid, Callee_AcsApplicationInstanceDisplayName:string, Callee_AcsApplicationInstanceId:guid, Callee_AcsApplicationInstanceTenantId:guid, Callee_SpoolApplicationInstanceDisplayName:string, Callee_SpoolApplicationInstanceId:guid, Callee_SpoolApplicationInstanceTenantId:guid, Callee_Id:string, Callee_UserPrincipalName:string, Callee_DisplayName:string, Callee_TenantId:guid, Callee_IdType:string, Callee_EndpointType:string, Callee_ProductFamily:string, Callee_Platform:string, Callee_UserAgentHeaderValue:string, Callee_ServiceRole:string, Callee_ApplicationVersion:string, Callee_AzureAdAppId:guid, Callee_CommunicationServiceId:guid, Callee_ConnectionType:string, Callee_ReflexiveIPAddress:string, Callee_Subnet:string, Callee_IpAddress:string, Callee_MacAddress:string, Callee_LinkSpeed:long, Callee_NetworkTransportProtocol:string, Callee_Port:int, Callee_RelayIPAddress:string, Callee_RelayPort:int, Callee_DnsSuffix:string, Callee_TraceRouteHops:string, Callee_BSSID:string, Callee_WifiRadioType:string, Callee_WifiBand:string, Callee_WifiChannel:int, Callee_WifiSignalStrength:int, Callee_WifiBatteryCharge:int, Callee_WifiMicrosoftDriver:string, Callee_WifiMicrosoftDriverVersion:string, Callee_WifiVendorDriver:string, Callee_WifiVendorDriverVersion:string, Callee_CaptureDeviceName:string, Callee_CaptureDeviceDriver:string, Callee_RenderDeviceName:string, Callee_RenderDeviceDriver:string, Callee_SentSignalLevel:real, Callee_SentNoiseLevel:real, Callee_MicGlitchRate:real, Callee_ReceivedSignalLevel:real, Callee_ReceivedNoiseLevel:real, Callee_SpeakerGlitchRate:real, Callee_HowlingEventCount:int, Callee_InitialSignalLevelRootMeanSquare:real, Callee_DeviceGlitchEventRatio:real, Callee_DeviceClippingEventRatio:real, Callee_LowSpeechToNoiseEventRatio:real, Callee_CaptureNotFunctioningEventRatio:real, Callee_SentQualityEventRatio:real, Callee_LowSpeechLevelEventRatio:real, Callee_RenderNotFunctioningEventRatio:real, Callee_ReceivedQualityEventRatio:real, Callee_RenderZeroVolumeEventRatio:real, Callee_RenderMuteEventRatio:real, Callee_CpuInsufficentEventRatio:real, Callee_DelayEventRatio:real, Callee_BandwidthLowEventRatio:real, Callee_FeedbackRating:string, Callee_FeedbackText:string, Callee_FeedbackTokens:string, Caller_UserDisplayName:string, Caller_UserId:guid, Caller_UserTenantId:guid, Caller_ApplicationInstanceDisplayName:string, Caller_ApplicationInstanceId:guid, Caller_ApplicationInstanceTenantId:guid, Caller_GuestDisplayName:string, Caller_GuestId:guid, Caller_GuestTenantId:guid, Caller_PhoneDisplayName:string, Caller_PhoneId:string, Caller_PhoneTenantId:guid, Caller_OnPremisesDisplayName:string, Caller_OnPremisesId:guid, Caller_OnPremisesTenantId:guid, Caller_EncryptedDisplayName:string, Caller_EncryptedId:guid, Caller_EncryptedTenantId:guid, Caller_AcsUserDisplayName:string, Caller_AcsUserId:guid, Caller_AcsUserTenantId:guid, Caller_SpoolUserDisplayName:string, Caller_SpoolUserId:guid, Caller_SpoolUserTenantId:guid, Caller_AcsApplicationInstanceDisplayName:string, Caller_AcsApplicationInstanceId:guid, Caller_AcsApplicationInstanceTenantId:guid, Caller_SpoolApplicationInstanceDisplayName:string, Caller_SpoolApplicationInstanceId:guid, Caller_SpoolApplicationInstanceTenantId:guid, Caller_Id:string, Caller_UserPrincipalName:string, Caller_DisplayName:string, Caller_TenantId:guid, Caller_IdType:string, Caller_EndpointType:string, Caller_ProductFamily:string, Caller_Platform:string, Caller_UserAgentHeaderValue:string, Caller_ServiceRole:string, Caller_ApplicationVersion:string, Caller_AzureAdAppId:guid, Caller_CommunicationServiceId:guid, Caller_ConnectionType:string, Caller_ReflexiveIPAddress:string, Caller_Subnet:string, Caller_IpAddress:string, Caller_MacAddress:string, Caller_LinkSpeed:long, Caller_NetworkTransportProtocol:string, Caller_Port:int, Caller_RelayIPAddress:string, Caller_RelayPort:int, Caller_DnsSuffix:string, Caller_TraceRouteHops:string, Caller_BSSID:string, Caller_WifiRadioType:string, Caller_WifiBand:string, Caller_WifiChannel:int, Caller_WifiSignalStrength:int, Caller_WifiBatteryCharge:int, Caller_WifiMicrosoftDriver:string, Caller_WifiMicrosoftDriverVersion:string, Caller_WifiVendorDriver:string, Caller_WifiVendorDriverVersion:string, Caller_CaptureDeviceName:string, Caller_CaptureDeviceDriver:string, Caller_RenderDeviceName:string, Caller_RenderDeviceDriver:string, Caller_SentSignalLevel:real, Caller_SentNoiseLevel:real, Caller_MicGlitchRate:real, Caller_ReceivedSignalLevel:real, Caller_ReceivedNoiseLevel:real, Caller_SpeakerGlitchRate:real, Caller_HowlingEventCount:int, Caller_InitialSignalLevelRootMeanSquare:real, Caller_DeviceGlitchEventRatio:real, Caller_DeviceClippingEventRatio:real, Caller_LowSpeechToNoiseEventRatio:real, Caller_CaptureNotFunctioningEventRatio:real, Caller_SentQualityEventRatio:real, Caller_LowSpeechLevelEventRatio:real, Caller_RenderNotFunctioningEventRatio:real, Caller_ReceivedQualityEventRatio:real, Caller_RenderZeroVolumeEventRatio:real, Caller_RenderMuteEventRatio:real, Caller_CpuInsufficentEventRatio:real, Caller_DelayEventRatio:real, Caller_BandwidthLowEventRatio:real, Caller_FeedbackRating:string, Caller_FeedbackText:string, Caller_FeedbackTokens:string)
This command updates the ingestion mapping from Cosmos to the new schema for Version 1.2.
Note
The Backticks (```) are required.
.alter table CallRecords ingestion json mapping "CallRecordMappingJsonMapping"
```
[{"column":"CallRecordTenantIdContext","path":"$.CallRecordTenantIdContext","datatype":"string"},{"column":"CallId","path":"$.CallId","datatype":"guid"},{"column":"SessionId","path":"$.SessionId","datatype":"guid"},{"column":"StreamId","path":"$.StreamId","datatype":"string"},{"column":"StreamDirection","path":"$.StreamDirection","datatype":"string"},{"column":"MediaLabel","path":"$.MediaLabel","datatype":"string"},{"column":"CallStartTime","path":"$.CallStartTime","datatype":"datetime"},{"column":"CallEndTime","path":"$.CallEndTime","datatype":"datetime"},{"column":"SessionStartTime","path":"$.SessionStartTime","datatype":"datetime"},{"column":"SessionEndTime","path":"$.SessionEndTime","datatype":"datetime"},{"column":"LastModifiedDateTimeOffset","path":"$.LastModifiedDateTimeOffset","datatype":"datetime"},{"column":"CallType","path":"$.CallType","datatype":"string"},{"column":"JoinWebUrl","path":"$.JoinWebUrl","datatype":"string"},{"column":"VideoCodec","path":"$.VideoCodec","datatype":"string"},{"column":"AudioCodec","path":"$.AudioCodec","datatype":"string"},{"column":"WasMediaBypassed","path":"$.WasMediaBypassed","datatype":"bool"},{"column":"FailureStage","path":"$.FailureStage","datatype":"string"},{"column":"FailureReason","path":"$.FailureReason","datatype":"string"},{"column":"PacketUtilization","path":"$.PacketUtilization","datatype":"long"},{"column":"AverageBandwidthEstimate","path":"$.AverageBandwidthEstimate","datatype":"long"},{"column":"AverageJitter","path":"$.AverageJitter","datatype":"timespan"},{"column":"MaxJitter","path":"$.MaxJitter","datatype":"timespan"},{"column":"AverageRoundTripTime","path":"$.AverageRoundTripTime","datatype":"timespan"},{"column":"MaxRoundTripTime","path":"$.MaxRoundTripTime","datatype":"timespan"},{"column":"AverageAudioNetworkJitter","path":"$.AverageAudioNetworkJitter","datatype":"timespan"},{"column":"MaxAudioNetworkJitter","path":"$.MaxAudioNetworkJitter","datatype":"timespan"},{"column":"AverageAudioDegradation","path":"$.AverageAudioDegradation","datatype":"real"},{"column":"AveragePacketLossRate","path":"$.AveragePacketLossRate","datatype":"real"},{"column":"MaxPacketLossRate","path":"$.MaxPacketLossRate","datatype":"real"},{"column":"PostForwardErrorCorrectionPacketLossRate","path":"$.PostForwardErrorCorrectionPacketLossRate","datatype":"real"},{"column":"AverageRatioOfConcealedSamples","path":"$.AverageRatioOfConcealedSamples","datatype":"real"},{"column":"MaxRatioOfConcealedSamples","path":"$.MaxRatioOfConcealedSamples","datatype":"real"},{"column":"LowVideoProcessingCapabilityRatio","path":"$.LowVideoProcessingCapabilityRatio","datatype":"real"},{"column":"AverageVideoFrameRate","path":"$.AverageVideoFrameRate","datatype":"real"},{"column":"AverageReceivedFrameRate","path":"$.AverageReceivedFrameRate","datatype":"real"},{"column":"LowFrameRateRatio","path":"$.LowFrameRateRatio","datatype":"real"},{"column":"AverageVideoPacketLossRate","path":"$.AverageVideoPacketLossRate","datatype":"real"},{"column":"AverageVideoFrameLossPercentage","path":"$.AverageVideoFrameLossPercentage","datatype":"real"},{"column":"Organizer_UserDisplayName","path":"$.Organizer_UserDisplayName","datatype":"string"},{"column":"Organizer_UserId","path":"$.Organizer_UserId","datatype":"guid"},{"column":"Organizer_UserTenantId","path":"$.Organizer_UserTenantId","datatype":"guid"},{"column":"Organizer_ApplicationInstanceDisplayName","path":"$.Organizer_ApplicationInstanceDisplayName","datatype":"string"},{"column":"Organizer_ApplicationInstanceId","path":"$.Organizer_ApplicationInstanceId","datatype":"guid"},{"column":"Organizer_ApplicationInstanceTenantId","path":"$.Organizer_ApplicationInstanceTenantId","datatype":"guid"},{"column":"Organizer_GuestDisplayName","path":"$.Organizer_GuestDisplayName","datatype":"string"},{"column":"Organizer_GuestId","path":"$.Organizer_GuestId","datatype":"guid"},{"column":"Organizer_GuestTenantId","path":"$.Organizer_GuestTenantId","datatype":"guid"},{"column":"Organizer_PhoneDisplayName","path":"$.Organizer_PhoneDisplayName","datatype":"string"},{"column":"Organizer_PhoneId","path":"$.Organizer_PhoneId","datatype":"string"},{"column":"Organizer_PhoneTenantId","path":"$.Organizer_PhoneTenantId","datatype":"guid"},{"column":"Organizer_OnPremisesDisplayName","path":"$.Organizer_OnPremisesDisplayName","datatype":"string"},{"column":"Organizer_OnPremisesId","path":"$.Organizer_OnPremisesId","datatype":"guid"},{"column":"Organizer_OnPremisesTenantId","path":"$.Organizer_OnPremisesTenantId","datatype":"guid"},{"column":"Organizer_EncryptedDisplayName","path":"$.Organizer_EncryptedDisplayName","datatype":"string"},{"column":"Organizer_EncryptedId","path":"$.Organizer_EncryptedId","datatype":"guid"},{"column":"Organizer_EncryptedTenantId","path":"$.Organizer_EncryptedTenantId","datatype":"guid"},{"column":"Organizer_AcsUserDisplayName","path":"$.Organizer_AcsUserDisplayName","datatype":"string"},{"column":"Organizer_AcsUserId","path":"$.Organizer_AcsUserId","datatype":"guid"},{"column":"Organizer_AcsUserTenantId","path":"$.Organizer_AcsUserTenantId","datatype":"guid"},{"column":"Organizer_SpoolUserDisplayName","path":"$.Organizer_SpoolUserDisplayName","datatype":"string"},{"column":"Organizer_SpoolUserId","path":"$.Organizer_SpoolUserId","datatype":"guid"},{"column":"Organizer_SpoolUserTenantId","path":"$.Organizer_SpoolUserTenantId","datatype":"guid"},{"column":"Organizer_AcsApplicationInstanceDisplayName","path":"$.Organizer_AcsApplicationInstanceDisplayName","datatype":"string"},{"column":"Organizer_AcsApplicationInstanceId","path":"$.Organizer_AcsApplicationInstanceId","datatype":"guid"},{"column":"Organizer_AcsApplicationInstanceTenantId","path":"$.Organizer_AcsApplicationInstanceTenantId","datatype":"guid"},{"column":"Organizer_SpoolApplicationInstanceDisplayName","path":"$.Organizer_SpoolApplicationInstanceDisplayName","datatype":"string"},{"column":"Organizer_SpoolApplicationInstanceId","path":"$.Organizer_SpoolApplicationInstanceId","datatype":"guid"},{"column":"Organizer_SpoolApplicationInstanceTenantId","path":"$.Organizer_SpoolApplicationInstanceTenantId","datatype":"guid"},{"column":"Organizer_Id","path":"$.Organizer_Id","datatype":"string"},{"column":"Organizer_UserPrincipalName","path":"$.Organizer_UserPrincipalName","datatype":"string"},{"column":"Organizer_DisplayName","path":"$.Organizer_DisplayName","datatype":"string"},{"column":"Organizer_TenantId","path":"$.Organizer_TenantId","datatype":"guid"},{"column":"Organizer_IdType","path":"$.Organizer_IdType","datatype":"string"},{"column":"Callee_UserDisplayName","path":"$.Callee_UserDisplayName","datatype":"string"},{"column":"Callee_UserId","path":"$.Callee_UserId","datatype":"guid"},{"column":"Callee_UserTenantId","path":"$.Callee_UserTenantId","datatype":"guid"},{"column":"Callee_ApplicationInstanceDisplayName","path":"$.Callee_ApplicationInstanceDisplayName","datatype":"string"},{"column":"Callee_ApplicationInstanceId","path":"$.Callee_ApplicationInstanceId","datatype":"guid"},{"column":"Callee_ApplicationInstanceTenantId","path":"$.Callee_ApplicationInstanceTenantId","datatype":"guid"},{"column":"Callee_GuestDisplayName","path":"$.Callee_GuestDisplayName","datatype":"string"},{"column":"Callee_GuestId","path":"$.Callee_GuestId","datatype":"guid"},{"column":"Callee_GuestTenantId","path":"$.Callee_GuestTenantId","datatype":"guid"},{"column":"Callee_PhoneDisplayName","path":"$.Callee_PhoneDisplayName","datatype":"string"},{"column":"Callee_PhoneId","path":"$.Callee_PhoneId","datatype":"string"},{"column":"Callee_PhoneTenantId","path":"$.Callee_PhoneTenantId","datatype":"guid"},{"column":"Callee_OnPremisesDisplayName","path":"$.Callee_OnPremisesDisplayName","datatype":"string"},{"column":"Callee_OnPremisesId","path":"$.Callee_OnPremisesId","datatype":"guid"},{"column":"Callee_OnPremisesTenantId","path":"$.Callee_OnPremisesTenantId","datatype":"guid"},{"column":"Callee_EncryptedDisplayName","path":"$.Callee_EncryptedDisplayName","datatype":"string"},{"column":"Callee_EncryptedId","path":"$.Callee_EncryptedId","datatype":"guid"},{"column":"Callee_EncryptedTenantId","path":"$.Callee_EncryptedTenantId","datatype":"guid"},{"column":"Callee_AcsUserDisplayName","path":"$.Callee_AcsUserDisplayName","datatype":"string"},{"column":"Callee_AcsUserId","path":"$.Callee_AcsUserId","datatype":"guid"},{"column":"Callee_AcsUserTenantId","path":"$.Callee_AcsUserTenantId","datatype":"guid"},{"column":"Callee_SpoolUserDisplayName","path":"$.Callee_SpoolUserDisplayName","datatype":"string"},{"column":"Callee_SpoolUserId","path":"$.Callee_SpoolUserId","datatype":"guid"},{"column":"Callee_SpoolUserTenantId","path":"$.Callee_SpoolUserTenantId","datatype":"guid"},{"column":"Callee_AcsApplicationInstanceDisplayName","path":"$.Callee_AcsApplicationInstanceDisplayName","datatype":"string"},{"column":"Callee_AcsApplicationInstanceId","path":"$.Callee_AcsApplicationInstanceId","datatype":"guid"},{"column":"Callee_AcsApplicationInstanceTenantId","path":"$.Callee_AcsApplicationInstanceTenantId","datatype":"guid"},{"column":"Callee_SpoolApplicationInstanceDisplayName","path":"$.Callee_SpoolApplicationInstanceDisplayName","datatype":"string"},{"column":"Callee_SpoolApplicationInstanceId","path":"$.Callee_SpoolApplicationInstanceId","datatype":"guid"},{"column":"Callee_SpoolApplicationInstanceTenantId","path":"$.Callee_SpoolApplicationInstanceTenantId","datatype":"guid"},{"column":"Callee_Id","path":"$.Callee_Id","datatype":"string"},{"column":"Callee_UserPrincipalName","path":"$.Callee_UserPrincipalName","datatype":"string"},{"column":"Callee_DisplayName","path":"$.Callee_DisplayName","datatype":"string"},{"column":"Callee_TenantId","path":"$.Callee_TenantId","datatype":"guid"},{"column":"Callee_IdType","path":"$.Callee_IdType","datatype":"string"},{"column":"Callee_EndpointType","path":"$.Callee_EndpointType","datatype":"string"},{"column":"Callee_ProductFamily","path":"$.Callee_ProductFamily","datatype":"string"},{"column":"Callee_Platform","path":"$.Callee_Platform","datatype":"string"},{"column":"Callee_UserAgentHeaderValue","path":"$.Callee_UserAgentHeaderValue","datatype":"string"},{"column":"Callee_ServiceRole","path":"$.Callee_ServiceRole","datatype":"string"},{"column":"Callee_ApplicationVersion","path":"$.Callee_ApplicationVersion","datatype":"string"},{"column":"Callee_AzureAdAppId","path":"$.Callee_AzureAdAppId","datatype":"guid"},{"column":"Callee_CommunicationServiceId","path":"$.Callee_CommunicationServiceId","datatype":"guid"},{"column":"Callee_ConnectionType","path":"$.Callee_ConnectionType","datatype":"string"},{"column":"Callee_ReflexiveIPAddress","path":"$.Callee_ReflexiveIPAddress","datatype":"string"},{"column":"Callee_Subnet","path":"$.Callee_Subnet","datatype":"string"},{"column":"Callee_IpAddress","path":"$.Callee_IpAddress","datatype":"string"},{"column":"Callee_MacAddress","path":"$.Callee_MacAddress","datatype":"string"},{"column":"Callee_LinkSpeed","path":"$.Callee_LinkSpeed","datatype":"long"},{"column":"Callee_NetworkTransportProtocol","path":"$.Callee_NetworkTransportProtocol","datatype":"string"},{"column":"Callee_Port","path":"$.Callee_Port","datatype":"int"},{"column":"Callee_RelayIPAddress","path":"$.Callee_RelayIPAddress","datatype":"string"},{"column":"Callee_RelayPort","path":"$.Callee_RelayPort","datatype":"int"},{"column":"Callee_DnsSuffix","path":"$.Callee_DnsSuffix","datatype":"string"},{"column":"Callee_TraceRouteHops","path":"$.Callee_TraceRouteHops","datatype":"string"},{"column":"Callee_BSSID","path":"$.Callee_BSSID","datatype":"string"},{"column":"Callee_WifiRadioType","path":"$.Callee_WifiRadioType","datatype":"string"},{"column":"Callee_WifiBand","path":"$.Callee_WifiBand","datatype":"string"},{"column":"Callee_WifiChannel","path":"$.Callee_WifiChannel","datatype":"int"},{"column":"Callee_WifiSignalStrength","path":"$.Callee_WifiSignalStrength","datatype":"int"},{"column":"Callee_WifiBatteryCharge","path":"$.Callee_WifiBatteryCharge","datatype":"int"},{"column":"Callee_WifiMicrosoftDriver","path":"$.Callee_WifiMicrosoftDriver","datatype":"string"},{"column":"Callee_WifiMicrosoftDriverVersion","path":"$.Callee_WifiMicrosoftDriverVersion","datatype":"string"},{"column":"Callee_WifiVendorDriver","path":"$.Callee_WifiVendorDriver","datatype":"string"},{"column":"Callee_WifiVendorDriverVersion","path":"$.Callee_WifiVendorDriverVersion","datatype":"string"},{"column":"Callee_CaptureDeviceName","path":"$.Callee_CaptureDeviceName","datatype":"string"},{"column":"Callee_CaptureDeviceDriver","path":"$.Callee_CaptureDeviceDriver","datatype":"string"},{"column":"Callee_RenderDeviceName","path":"$.Callee_RenderDeviceName","datatype":"string"},{"column":"Callee_RenderDeviceDriver","path":"$.Callee_RenderDeviceDriver","datatype":"string"},{"column":"Callee_SentSignalLevel","path":"$.Callee_SentSignalLevel","datatype":"real"},{"column":"Callee_SentNoiseLevel","path":"$.Callee_SentNoiseLevel","datatype":"real"},{"column":"Callee_MicGlitchRate","path":"$.Callee_MicGlitchRate","datatype":"real"},{"column":"Callee_ReceivedSignalLevel","path":"$.Callee_ReceivedSignalLevel","datatype":"real"},{"column":"Callee_ReceivedNoiseLevel","path":"$.Callee_ReceivedNoiseLevel","datatype":"real"},{"column":"Callee_SpeakerGlitchRate","path":"$.Callee_SpeakerGlitchRate","datatype":"real"},{"column":"Callee_HowlingEventCount","path":"$.Callee_HowlingEventCount","datatype":"int"},{"column":"Callee_InitialSignalLevelRootMeanSquare","path":"$.Callee_InitialSignalLevelRootMeanSquare","datatype":"real"},{"column":"Callee_DeviceGlitchEventRatio","path":"$.Callee_DeviceGlitchEventRatio","datatype":"real"},{"column":"Callee_DeviceClippingEventRatio","path":"$.Callee_DeviceClippingEventRatio","datatype":"real"},{"column":"Callee_LowSpeechToNoiseEventRatio","path":"$.Callee_LowSpeechToNoiseEventRatio","datatype":"real"},{"column":"Callee_CaptureNotFunctioningEventRatio","path":"$.Callee_CaptureNotFunctioningEventRatio","datatype":"real"},{"column":"Callee_SentQualityEventRatio","path":"$.Callee_SentQualityEventRatio","datatype":"real"},{"column":"Callee_LowSpeechLevelEventRatio","path":"$.Callee_LowSpeechLevelEventRatio","datatype":"real"},{"column":"Callee_RenderNotFunctioningEventRatio","path":"$.Callee_RenderNotFunctioningEventRatio","datatype":"real"},{"column":"Callee_ReceivedQualityEventRatio","path":"$.Callee_ReceivedQualityEventRatio","datatype":"real"},{"column":"Callee_RenderZeroVolumeEventRatio","path":"$.Callee_RenderZeroVolumeEventRatio","datatype":"real"},{"column":"Callee_RenderMuteEventRatio","path":"$.Callee_RenderMuteEventRatio","datatype":"real"},{"column":"Callee_CpuInsufficentEventRatio","path":"$.Callee_CpuInsufficentEventRatio","datatype":"real"},{"column":"Callee_DelayEventRatio","path":"$.Callee_DelayEventRatio","datatype":"real"},{"column":"Callee_BandwidthLowEventRatio","path":"$.Callee_BandwidthLowEventRatio","datatype":"real"},{"column":"Callee_FeedbackRating","path":"$.Callee_FeedbackRating","datatype":"string"},{"column":"Callee_FeedbackText","path":"$.Callee_FeedbackText","datatype":"string"},{"column":"Callee_FeedbackTokens","path":"$.Callee_FeedbackTokens","datatype":"string"},{"column":"Caller_UserDisplayName","path":"$.Caller_UserDisplayName","datatype":"string"},{"column":"Caller_UserId","path":"$.Caller_UserId","datatype":"guid"},{"column":"Caller_UserTenantId","path":"$.Caller_UserTenantId","datatype":"guid"},{"column":"Caller_ApplicationInstanceDisplayName","path":"$.Caller_ApplicationInstanceDisplayName","datatype":"string"},{"column":"Caller_ApplicationInstanceId","path":"$.Caller_ApplicationInstanceId","datatype":"guid"},{"column":"Caller_ApplicationInstanceTenantId","path":"$.Caller_ApplicationInstanceTenantId","datatype":"guid"},{"column":"Caller_GuestDisplayName","path":"$.Caller_GuestDisplayName","datatype":"string"},{"column":"Caller_GuestId","path":"$.Caller_GuestId","datatype":"guid"},{"column":"Caller_GuestTenantId","path":"$.Caller_GuestTenantId","datatype":"guid"},{"column":"Caller_PhoneDisplayName","path":"$.Caller_PhoneDisplayName","datatype":"string"},{"column":"Caller_PhoneId","path":"$.Caller_PhoneId","datatype":"string"},{"column":"Caller_PhoneTenantId","path":"$.Caller_PhoneTenantId","datatype":"guid"},{"column":"Caller_OnPremisesDisplayName","path":"$.Caller_OnPremisesDisplayName","datatype":"string"},{"column":"Caller_OnPremisesId","path":"$.Caller_OnPremisesId","datatype":"guid"},{"column":"Caller_OnPremisesTenantId","path":"$.Caller_OnPremisesTenantId","datatype":"guid"},{"column":"Caller_EncryptedDisplayName","path":"$.Caller_EncryptedDisplayName","datatype":"string"},{"column":"Caller_EncryptedId","path":"$.Caller_EncryptedId","datatype":"guid"},{"column":"Caller_EncryptedTenantId","path":"$.Caller_EncryptedTenantId","datatype":"guid"},{"column":"Caller_AcsUserDisplayName","path":"$.Caller_AcsUserDisplayName","datatype":"string"},{"column":"Caller_AcsUserId","path":"$.Caller_AcsUserId","datatype":"guid"},{"column":"Caller_AcsUserTenantId","path":"$.Caller_AcsUserTenantId","datatype":"guid"},{"column":"Caller_SpoolUserDisplayName","path":"$.Caller_SpoolUserDisplayName","datatype":"string"},{"column":"Caller_SpoolUserId","path":"$.Caller_SpoolUserId","datatype":"guid"},{"column":"Caller_SpoolUserTenantId","path":"$.Caller_SpoolUserTenantId","datatype":"guid"},{"column":"Caller_AcsApplicationInstanceDisplayName","path":"$.Caller_AcsApplicationInstanceDisplayName","datatype":"string"},{"column":"Caller_AcsApplicationInstanceId","path":"$.Caller_AcsApplicationInstanceId","datatype":"guid"},{"column":"Caller_AcsApplicationInstanceTenantId","path":"$.Caller_AcsApplicationInstanceTenantId","datatype":"guid"},{"column":"Caller_SpoolApplicationInstanceDisplayName","path":"$.Caller_SpoolApplicationInstanceDisplayName","datatype":"string"},{"column":"Caller_SpoolApplicationInstanceId","path":"$.Caller_SpoolApplicationInstanceId","datatype":"guid"},{"column":"Caller_SpoolApplicationInstanceTenantId","path":"$.Caller_SpoolApplicationInstanceTenantId","datatype":"guid"},{"column":"Caller_Id","path":"$.Caller_Id","datatype":"string"},{"column":"Caller_UserPrincipalName","path":"$.Caller_UserPrincipalName","datatype":"string"},{"column":"Caller_DisplayName","path":"$.Caller_DisplayName","datatype":"string"},{"column":"Caller_TenantId","path":"$.Caller_TenantId","datatype":"guid"},{"column":"Caller_IdType","path":"$.Caller_IdType","datatype":"string"},{"column":"Caller_EndpointType","path":"$.Caller_EndpointType","datatype":"string"},{"column":"Caller_ProductFamily","path":"$.Caller_ProductFamily","datatype":"string"},{"column":"Caller_Platform","path":"$.Caller_Platform","datatype":"string"},{"column":"Caller_UserAgentHeaderValue","path":"$.Caller_UserAgentHeaderValue","datatype":"string"},{"column":"Caller_ServiceRole","path":"$.Caller_ServiceRole","datatype":"string"},{"column":"Caller_ApplicationVersion","path":"$.Caller_ApplicationVersion","datatype":"string"},{"column":"Caller_AzureAdAppId","path":"$.Caller_AzureAdAppId","datatype":"guid"},{"column":"Caller_CommunicationServiceId","path":"$.Caller_CommunicationServiceId","datatype":"guid"},{"column":"Caller_ConnectionType","path":"$.Caller_ConnectionType","datatype":"string"},{"column":"Caller_ReflexiveIPAddress","path":"$.Caller_ReflexiveIPAddress","datatype":"string"},{"column":"Caller_Subnet","path":"$.Caller_Subnet","datatype":"string"},{"column":"Caller_IpAddress","path":"$.Caller_IpAddress","datatype":"string"},{"column":"Caller_MacAddress","path":"$.Caller_MacAddress","datatype":"string"},{"column":"Caller_LinkSpeed","path":"$.Caller_LinkSpeed","datatype":"long"},{"column":"Caller_NetworkTransportProtocol","path":"$.Caller_NetworkTransportProtocol","datatype":"string"},{"column":"Caller_Port","path":"$.Caller_Port","datatype":"int"},{"column":"Caller_RelayIPAddress","path":"$.Caller_RelayIPAddress","datatype":"string"},{"column":"Caller_RelayPort","path":"$.Caller_RelayPort","datatype":"int"},{"column":"Caller_DnsSuffix","path":"$.Caller_DnsSuffix","datatype":"string"},{"column":"Caller_TraceRouteHops","path":"$.Caller_TraceRouteHops","datatype":"string"},{"column":"Caller_BSSID","path":"$.Caller_BSSID","datatype":"string"},{"column":"Caller_WifiRadioType","path":"$.Caller_WifiRadioType","datatype":"string"},{"column":"Caller_WifiBand","path":"$.Caller_WifiBand","datatype":"string"},{"column":"Caller_WifiChannel","path":"$.Caller_WifiChannel","datatype":"int"},{"column":"Caller_WifiSignalStrength","path":"$.Caller_WifiSignalStrength","datatype":"int"},{"column":"Caller_WifiBatteryCharge","path":"$.Caller_WifiBatteryCharge","datatype":"int"},{"column":"Caller_WifiMicrosoftDriver","path":"$.Caller_WifiMicrosoftDriver","datatype":"string"},{"column":"Caller_WifiMicrosoftDriverVersion","path":"$.Caller_WifiMicrosoftDriverVersion","datatype":"string"},{"column":"Caller_WifiVendorDriver","path":"$.Caller_WifiVendorDriver","datatype":"string"},{"column":"Caller_WifiVendorDriverVersion","path":"$.Caller_WifiVendorDriverVersion","datatype":"string"},{"column":"Caller_CaptureDeviceName","path":"$.Caller_CaptureDeviceName","datatype":"string"},{"column":"Caller_CaptureDeviceDriver","path":"$.Caller_CaptureDeviceDriver","datatype":"string"},{"column":"Caller_RenderDeviceName","path":"$.Caller_RenderDeviceName","datatype":"string"},{"column":"Caller_RenderDeviceDriver","path":"$.Caller_RenderDeviceDriver","datatype":"string"},{"column":"Caller_SentSignalLevel","path":"$.Caller_SentSignalLevel","datatype":"real"},{"column":"Caller_SentNoiseLevel","path":"$.Caller_SentNoiseLevel","datatype":"real"},{"column":"Caller_MicGlitchRate","path":"$.Caller_MicGlitchRate","datatype":"real"},{"column":"Caller_ReceivedSignalLevel","path":"$.Caller_ReceivedSignalLevel","datatype":"real"},{"column":"Caller_ReceivedNoiseLevel","path":"$.Caller_ReceivedNoiseLevel","datatype":"real"},{"column":"Caller_SpeakerGlitchRate","path":"$.Caller_SpeakerGlitchRate","datatype":"real"},{"column":"Caller_HowlingEventCount","path":"$.Caller_HowlingEventCount","datatype":"int"},{"column":"Caller_InitialSignalLevelRootMeanSquare","path":"$.Caller_InitialSignalLevelRootMeanSquare","datatype":"real"},{"column":"Caller_DeviceGlitchEventRatio","path":"$.Caller_DeviceGlitchEventRatio","datatype":"real"},{"column":"Caller_DeviceClippingEventRatio","path":"$.Caller_DeviceClippingEventRatio","datatype":"real"},{"column":"Caller_LowSpeechToNoiseEventRatio","path":"$.Caller_LowSpeechToNoiseEventRatio","datatype":"real"},{"column":"Caller_CaptureNotFunctioningEventRatio","path":"$.Caller_CaptureNotFunctioningEventRatio","datatype":"real"},{"column":"Caller_SentQualityEventRatio","path":"$.Caller_SentQualityEventRatio","datatype":"real"},{"column":"Caller_LowSpeechLevelEventRatio","path":"$.Caller_LowSpeechLevelEventRatio","datatype":"real"},{"column":"Caller_RenderNotFunctioningEventRatio","path":"$.Caller_RenderNotFunctioningEventRatio","datatype":"real"},{"column":"Caller_ReceivedQualityEventRatio","path":"$.Caller_ReceivedQualityEventRatio","datatype":"real"},{"column":"Caller_RenderZeroVolumeEventRatio","path":"$.Caller_RenderZeroVolumeEventRatio","datatype":"real"},{"column":"Caller_RenderMuteEventRatio","path":"$.Caller_RenderMuteEventRatio","datatype":"real"},{"column":"Caller_CpuInsufficentEventRatio","path":"$.Caller_CpuInsufficentEventRatio","datatype":"real"},{"column":"Caller_DelayEventRatio","path":"$.Caller_DelayEventRatio","datatype":"real"},{"column":"Caller_BandwidthLowEventRatio","path":"$.Caller_BandwidthLowEventRatio","datatype":"real"},{"column":"Caller_FeedbackRating","path":"$.Caller_FeedbackRating","datatype":"string"},{"column":"Caller_FeedbackText","path":"$.Caller_FeedbackText","datatype":"string"},{"column":"Caller_FeedbackTokens","path":"$.Caller_FeedbackTokens","datatype":"string"}]
```
Confirm new records are flowing correctly with the new columns populated. Note not all columns will be populated for all records.
CallRecords
| summarize arg_max(CallEndTime,*)
| summarize by Organizer_DisplayName,Organizer_TenantId,Organizer_IdType,Callee_Id,Callee_UserPrincipalName,Callee_DisplayName,Callee_TenantId,Callee_IdType,Caller_Id,Caller_UserPrincipalName,Caller_DisplayName,Caller_TenantId,Caller_IdType
This is optional, but you can now delete the backup table if you have confirmed there are no issues and no data loss.
.drop table BackupCallRecords ifexists