1
|
.alter table DiagnosticsTable policy update @'[{"IsEnabled": true,"Source": "TelemetryTable","Query": "let raw = materialize(TelemetryTable | where Type == \"DiagnosticsFrame\" | extend payload = todynamic(Telemetry) | extend m = payload[\"Monitors\"] | project SerialNumber, MachineType, Environment, Organization, Site, CreatedTime, UploadTime, Dancer1Angle = todouble(m[\"Dancer1Angle\"]), Dancer2Angle = todouble(m[\"Dancer2Angle\"]), Dancer3Angle = todouble(m[\"Dancer3Angle\"]), FeederMotorFrequency = todouble(m[\"FeederMotorFrequency\"]), DryerMotor = todouble(m[\"DryerMotor\"]), PollerMotor = todouble(m[\"PollerMotor\"]), WinderMotor = todouble(m[\"WinderMotor\"]), ScrewMotor = todouble(m[\"ScrewMotor\"]), ThreadSpeed = todouble(m[\"ThreadSpeed\"]), MixerTemperature = todouble(m[\"MixerTemperature\"]), HeadZone1Temperature = todouble(m[\"HeadZone1Temperature\"]), HeadZone2Temperature = todouble(m[\"HeadZone2Temperature\"]), HeadZone3Temperature = todouble(m[\"HeadZone3Temperature\"]), HeadAirFlow = todouble(m[\"HeadAirFlow\"]), FeederTension = todouble(m[\"FeederTension\"]), PullerTension = todouble(m[\"PullerTension\"]), DryerZone1Temperature = todouble(m[\"DryerZone1Temperature\"]), DryerZone2Temperature = todouble(m[\"DryerZone2Temperature\"]), DryerZone3Temperature = todouble(m[\"DryerZone3Temperature\"]), DryerAirFlow = todouble(m[\"DryerAirFlow\"]), WinderTension = todouble(m[\"WinderTension\"]), DispensersMotorsFrequency = todynamic(m[\"DispensersMotorsFrequency\"]), DispensersAngularEncoders = todynamic(m[\"DispensersAngularEncoders\"]), DispensersLinearPositions = todynamic(m[\"DispensersLinearPositions\"]), DispensersPressure = todynamic(m[\"DispensersPressure\"]), FilterDeltaPressure = todouble(m[\"FilterDeltaPressure\"]), ChillerTemperature = todouble(m[\"ChillerTemperature\"]), Dispenser1MotorFrequency = todouble(m[\"Dispenser1MotorFrequency\"]), Dispenser2MotorFrequency = todouble(m[\"Dispenser2MotorFrequency\"]), Dispenser3MotorFrequency = todouble(m[\"Dispenser3MotorFrequency\"]), Dispenser4MotorFrequency = todouble(m[\"Dispenser4MotorFrequency\"]), Dispenser5MotorFrequency = todouble(m[\"Dispenser5MotorFrequency\"]), Dispenser6MotorFrequency = todouble(m[\"Dispenser6MotorFrequency\"]), Dispenser7MotorFrequency = todouble(m[\"Dispenser7MotorFrequency\"]), Dispenser8MotorFrequency = todouble(m[\"Dispenser8MotorFrequency\"]), HeadZone4Temperature = todouble(m[\"HeadZone4Temperature\"]), HeadZone5Temperature = todouble(m[\"HeadZone5Temperature\"]), HeadZone6Temperature = todouble(m[\"HeadZone6Temperature\"]), BlowerVoltage = todouble(m[\"BlowerVoltage\"]), Dispenser1Pressure = todouble(m[\"Dispenser1Pressure\"]), Dispenser2Pressure = todouble(m[\"Dispenser2Pressure\"]), Dispenser3Pressure = todouble(m[\"Dispenser3Pressure\"]), Dispenser4Pressure = todouble(m[\"Dispenser4Pressure\"]), Dispenser5Pressure = todouble(m[\"Dispenser5Pressure\"]), Dispenser6Pressure = todouble(m[\"Dispenser6Pressure\"]), Dispenser7Pressure = todouble(m[\"Dispenser7Pressure\"]), Dispenser8Pressure = todouble(m[\"Dispenser8Pressure\"]), MidTank1Level = todouble(m[\"MidTank1Level\"]), MidTank2Level = todouble(m[\"MidTank2Level\"]), MidTank3Level = todouble(m[\"MidTank3Level\"]), MidTank4Level = todouble(m[\"MidTank4Level\"]), MidTank5Level = todouble(m[\"MidTank5Level\"]), MidTank6Level = todouble(m[\"MidTank6Level\"]), MidTank7Level = todouble(m[\"MidTank7Level\"]), MidTank8Level = todouble(m[\"MidTank8Level\"]), DrierZone1HeaterCurrent = todouble(m[\"DrierZone1HeaterCurrent\"]), DrierZone2HeaterCurrent = todouble(m[\"DrierZone2HeaterCurrent\"]), HeadZone1HeaterCurrent = todouble(m[\"HeadZone1HeaterCurrent\"]), HeadZone2HeaterCurrent = todouble(m[\"HeadZone2HeaterCurrent\"]), HeadZone3HeaterCurrent = todouble(m[\"HeadZone3HeaterCurrent\"]), HeadZone4HeaterCurrent = todouble(m[\"HeadZone4HeaterCurrent\"]), HeadZone56HeaterCurrent = todouble(m[\"HeadZone56HeaterCurrent\"]), Mixer1HeaterCurrent = todouble(m[\"Mixer1HeaterCurrent\"]), DispensersInkLevel = todynamic(m[\"DispensersInkLevel\"]), MidTanksInkLevel = todynamic(m[\"MidTanksInkLevel\"]), OverallTemperature = todouble(m[\"OverallTemperature\"]), HeadZone7HeaterCurrent = todouble(m[\"HeadZone7HeaterCurrent\"]), HeadZone7Temperature = todouble(m[\"HeadZone7Temperature\"]), HeadZone8HeaterCurrent = todouble(m[\"HeadZone8HeaterCurrent\"]), HeadZone8Temperature = todouble(m[\"HeadZone8Temperature\"]), HeadZone9HeaterCurrent = todouble(m[\"HeadZone9HeaterCurrent\"]), HeadZone9Temperature = todouble(m[\"HeadZone9Temperature\"]), HeadZone10HeaterCurrent = todouble(m[\"HeadZone10HeaterCurrent\"]), HeadZone10Temperature = todouble(m[\"HeadZone10Temperature\"]), HeadZone11HeaterCurrent = todouble(m[\"HeadZone11HeaterCurrent\"]), HeadZone11Temperature = todouble(m[\"HeadZone11Temperature\"]), HeadZone12HeaterCurrent = todouble(m[\"HeadZone12HeaterCurrent\"]), HeadZone12Temperature = todouble(m[\"HeadZone12Temperature\"]), HeadBlowerVoltage1 = todouble(m[\"HeadBlowerVoltage1\"]), HeadBlowerVoltage2 = todouble(m[\"HeadBlowerVoltage2\"]), HeadCoverHeater1Current = todouble(m[\"HeadCoverHeater1Current\"]), HeadCoverHeater1Temperature = todouble(m[\"HeadCoverHeater1Temperature\"]), HeadCoverHeater2Current = todouble(m[\"HeadCoverHeater2Current\"]), HeadCoverHeater2Temperature = todouble(m[\"HeadCoverHeater2Temperature\"]), WHSBlower2Voltage = todouble(m[\"WHSBlower2Voltage\"]), GasSensor = todouble(m[\"GasSensor\"]), IncomingVoltage = todouble(m[\"IncomingVoltage\"]), WasteLevel = todouble(m[\"WasteLevel\"]), HeadBlower1AirFlow = todouble(m[\"HeadBlower1AirFlow\"]), HeadBlower2AirFlow = todouble(m[\"HeadBlower2AirFlow\"]), ShinkoSetValue = todouble(m[\"ShinkoSetValue\"]), ShinkoCurrentValue = todouble(m[\"ShinkoCurrentValue\"]), TotalWHSFlow = todouble(m[\"TotalWHSFlow\"]), EuWinder1Dancer = todouble(m[\"EuWinder1Dancer\"]), EuWinder2Dancer = todouble(m[\"EuWinder2Dancer\"]), EuWinder3Dancer = todouble(m[\"EuWinder3Dancer\"]), EuWinder4Dancer = todouble(m[\"EuWinder4Dancer\"]), EuWinder1Motor = todouble(m[\"EuWinder1Motor\"]), EuWinder2Motor = todouble(m[\"EuWinder2Motor\"]), EuWinder3Motor = todouble(m[\"EuWinder3Motor\"]), EuWinder4Motor = todouble(m[\"EuWinder4Motor\"]), EuDryerMotorVelocity = todouble(m[\"EuDryerMotorVelocity\"]), EuDryerMotorTargetVelocity = todouble(m[\"EuDryerMotorTargetVelocity\"]), EuDryerMotorCurrent = todouble(m[\"EuDryerMotorCurrent\"]), EuPullerDancer = todouble(m[\"EuPullerDancer\"]), EuPullerMotor = todouble(m[\"EuPullerMotor\"]), EuDryerZone1Temperature = todouble(m[\"EuDryerZone1Temperature\"]), EuDryerZone2Temperature = todouble(m[\"EuDryerZone2Temperature\"]), EuDryerZone3Temperature = todouble(m[\"EuDryerZone3Temperature\"]), EuHeadZone1Temperature = todouble(m[\"EuHeadZone1Temperature\"]), EuHeadZone2Temperature = todouble(m[\"EuHeadZone2Temperature\"]), EuHeadZone3Temperature = todouble(m[\"EuHeadZone3Temperature\"]), EuMixerTemperature = todouble(m[\"EuMixerTemperature\"]), EuTunnelTemperature = todouble(m[\"EuTunnelTemperature\"]), EuLubricantTemperature = todouble(m[\"EuLubricantTemperature\"]), EuAmbientTemperature = todouble(m[\"EuAmbientTemperature\"]), EuElectricalCabinetTemperature = todouble(m[\"EuElectricalCabinetTemperature\"]), EuDryerZone1Current = todouble(m[\"EuDryerZone1Current\"]), EuDryerZone2Current = todouble(m[\"EuDryerZone2Current\"]), EuDryerZone3Current = todouble(m[\"EuDryerZone3Current\"]), EuHeadZone1Current = todouble(m[\"EuHeadZone1Current\"]), EuHeadZone2Current = todouble(m[\"EuHeadZone2Current\"]), EuHeadZone3Current = todouble(m[\"EuHeadZone3Current\"]), EuMixerCurrent = todouble(m[\"EuMixerCurrent\"]), EuTunnelCurrent = todouble(m[\"EuTunnelCurrent\"]), EuLubricantCurrent = todouble(m[\"EuLubricantCurrent\"]), EuBtsr1Speed = todouble(m[\"EuBtsr1Speed\"]), EuBtsr1SpeedAv = todouble(m[\"EuBtsr1SpeedAv\"]), EuBtsr1DispAv = todouble(m[\"EuBtsr1DispAv\"]), EuBtsr1PeakMin = todouble(m[\"EuBtsr1PeakMin\"]), EuBtsr1PeakMax = todouble(m[\"EuBtsr1PeakMax\"]), EuBtsr2Speed = todouble(m[\"EuBtsr2Speed\"]), EuBtsr2SpeedAv = todouble(m[\"EuBtsr2SpeedAv\"]), EuBtsr2DispAv = todouble(m[\"EuBtsr2DispAv\"]), EuBtsr2PeakMin = todouble(m[\"EuBtsr2PeakMin\"]), EuBtsr2PeakMax = todouble(m[\"EuBtsr2PeakMax\"]), EuBtsr3Speed = todouble(m[\"EuBtsr3Speed\"]), EuBtsr3SpeedAv = todouble(m[\"EuBtsr3SpeedAv\"]), EuBtsr3DispAv = todouble(m[\"EuBtsr3DispAv\"]), EuBtsr3PeakMin = todouble(m[\"EuBtsr3PeakMin\"]), EuBtsr3PeakMax = todouble(m[\"EuBtsr3PeakMax\"]), EuBtsr4Speed = todouble(m[\"EuBtsr4Speed\"]), EuBtsr4SpeedAv = todouble(m[\"EuBtsr4SpeedAv\"]), EuBtsr4PeakMin = todouble(m[\"EuBtsr4PeakMin\"]), EuBtsr4PeakMax = todouble(m[\"EuBtsr4PeakMax\"]), EuBtsr4DispAv = todouble(m[\"EuBtsr4DispAv\"]), EuTemperatureLoggers = todynamic(m[\"EuTemperatureLoggers\"]), EuPumpFlows = todynamic(m[\"EuPumpFlows\"]), EuInkLinesPressure = todynamic(m[\"EuInkLinesPressure\"]), EuSpareDataArray = todynamic(m[\"EuSpareDataArray\"]), EuDispenser1Voltage = todouble(m[\"EuDispenser1Voltage\"]), EuDispenser2Voltage = todouble(m[\"EuDispenser2Voltage\"]), EuDispenser3Voltage = todouble(m[\"EuDispenser3Voltage\"]), EuDispenser4Voltage = todouble(m[\"EuDispenser4Voltage\"]), EuDispenser5Voltage = todouble(m[\"EuDispenser5Voltage\"]), EuDispenser6Voltage = todouble(m[\"EuDispenser6Voltage\"]), EuDispenser7Voltage = todouble(m[\"EuDispenser7Voltage\"]), EuDispenser8Voltage = todouble(m[\"EuDispenser8Voltage\"]), EuDispenser9Voltage = todouble(m[\"EuDispenser9Voltage\"]), EuDispenser10Voltage = todouble(m[\"EuDispenser10Voltage\"]), EuDispenser11Voltage = todouble(m[\"EuDispenser11Voltage\"]), EuDispenser12Voltage = todouble(m[\"EuDispenser12Voltage\"]), EuDispenser13Voltage = todouble(m[\"EuDispenser13Voltage\"]), EuDispenser14Voltage = todouble(m[\"EuDispenser14Voltage\"]), EuDispenser15Voltage = todouble(m[\"EuDispenser15Voltage\"]), EuDispenser16Voltage = todouble(m[\"EuDispenser16Voltage\"]), EuLubricantPumpVoltage = todouble(m[\"EuLubricantPumpVoltage\"]), EuDispenser1Pressure = todouble(m[\"EuDispenser1Pressure\"]), EuDispenser2Pressure = todouble(m[\"EuDispenser2Pressure\"]), EuDispenser3Pressure = todouble(m[\"EuDispenser3Pressure\"]), EuDispenser4Pressure = todouble(m[\"EuDispenser4Pressure\"]), EuDispenser5Pressure = todouble(m[\"EuDispenser5Pressure\"]), EuDispenser6Pressure = todouble(m[\"EuDispenser6Pressure\"]), EuDispenser7Pressure = todouble(m[\"EuDispenser7Pressure\"]), EuDispenser8Pressure = todouble(m[\"EuDispenser8Pressure\"]), EuLubricantPressure = todouble(m[\"EuLubricantPressure\"]), EuMidTank1Level = todouble(m[\"EuMidTank1Level\"]), EuMidTank2Level = todouble(m[\"EuMidTank2Level\"]), EuMidTank3Level = todouble(m[\"EuMidTank3Level\"]), EuMidTank4Level = todouble(m[\"EuMidTank4Level\"]), EuMidTank5Level = todouble(m[\"EuMidTank5Level\"]), EuMidTank6Level = todouble(m[\"EuMidTank6Level\"]), EuMidTank7Level = todouble(m[\"EuMidTank7Level\"]), EuMidTank8Level = todouble(m[\"EuMidTank8Level\"]), EuChillerTemperature = todouble(m[\"EuChillerTemperature\"]), EuHeadRightAirFlow = todouble(m[\"EuHeadRightAirFlow\"]), EuHeadLeftAirFlow = todouble(m[\"EuHeadLeftAirFlow\"]), EuHeadRightVoltage = todouble(m[\"EuHeadRightVoltage\"]), EuHeadLeftVoltage = todouble(m[\"EuHeadLeftVoltage\"]), EuDryerAirFlow = todouble(m[\"EuDryerAirFlow\"]), EuBlowerVoltage = todouble(m[\"EuBlowerVoltage\"]), EuWasteLevel = todouble(m[\"EuWasteLevel\"]), EuSpare1 = todouble(m[\"EuSpare1\"]), EuSpare2 = todouble(m[\"EuSpare2\"]), EuSpare3 = todouble(m[\"EuSpare3\"]), EuSpare4 = todouble(m[\"EuSpare4\"]), EuBtsr5DispAv = todouble(m[\"EuBtsr5DispAv\"]), EuBtsr6DispAv = todouble(m[\"EuBtsr6DispAv\"]), EuBtsr7DispAv = todouble(m[\"EuBtsr7DispAv\"]), EuBtsr8DispAv = todouble(m[\"EuBtsr8DispAv\"]), EuBtsr5PeakMax = todouble(m[\"EuBtsr5PeakMax\"]), EuBtsr6PeakMax = todouble(m[\"EuBtsr6PeakMax\"]), EuBtsr7PeakMax = todouble(m[\"EuBtsr7PeakMax\"]), EuBtsr8PeakMax = todouble(m[\"EuBtsr8PeakMax\"]), EuBtsr5PeakMin = todouble(m[\"EuBtsr5PeakMin\"]), EuBtsr6PeakMin = todouble(m[\"EuBtsr6PeakMin\"]), EuBtsr7PeakMin = todouble(m[\"EuBtsr7PeakMin\"]), EuBtsr8PeakMin = todouble(m[\"EuBtsr8PeakMin\"]), EuBtsr5Speed = todouble(m[\"EuBtsr5Speed\"]), EuBtsr6Speed = todouble(m[\"EuBtsr6Speed\"]), EuBtsr7Speed = todouble(m[\"EuBtsr7Speed\"]), EuBtsr8Speed = todouble(m[\"EuBtsr8Speed\"]), EuBtsr5SpeedAv = todouble(m[\"EuBtsr5SpeedAv\"]), EuBtsr6SpeedAv = todouble(m[\"EuBtsr6SpeedAv\"]), EuBtsr7SpeedAv = todouble(m[\"EuBtsr7SpeedAv\"]), EuBtsr8SpeedAv = todouble(m[\"EuBtsr8SpeedAv\"]), EuDispenser17Voltage = todouble(m[\"EuDispenser17Voltage\"]), EuDispenser18Voltage = todouble(m[\"EuDispenser18Voltage\"]), EuDispenser19Voltage = todouble(m[\"EuDispenser19Voltage\"]), EuDispenser20Voltage = todouble(m[\"EuDispenser20Voltage\"]), EuDispenser21Voltage = todouble(m[\"EuDispenser21Voltage\"]), EuDispenser22Voltage = todouble(m[\"EuDispenser22Voltage\"]), EuDispenser9Pressure = todouble(m[\"EuDispenser9Pressure\"]), EuDispenser10Pressure = todouble(m[\"EuDispenser10Pressure\"]), EuDispenser11Pressure = todouble(m[\"EuDispenser11Pressure\"]), EuMidTank9Level = todouble(m[\"EuMidTank9Level\"]), EuMidTank1Level0 = todouble(m[\"EuMidTank1Level0\"]), EuMidTank1Level1 = todouble(m[\"EuMidTank1Level1\"]), EuPump1Current = todouble(m[\"EuPump1Current\"]), EuPump2Current = todouble(m[\"EuPump2Current\"]), EuPump3Current = todouble(m[\"EuPump3Current\"]), EuPump4Current = todouble(m[\"EuPump4Current\"]), EuPump5Current = todouble(m[\"EuPump5Current\"]), EuPump6Current = todouble(m[\"EuPump6Current\"]), EuPump7Current = todouble(m[\"EuPump7Current\"]), EuPump8Current = todouble(m[\"EuPump8Current\"]), EuPump9Current = todouble(m[\"EuPump9Current\"]), EuPump10Current = todouble(m[\"EuPump10Current\"]), EuPump11Current = todouble(m[\"EuPump11Current\"]), EuPump12Current = todouble(m[\"EuPump12Current\"]), EuPump13Current = todouble(m[\"EuPump13Current\"]), EuPump14Current = todouble(m[\"EuPump14Current\"]), EuPump15Current = todouble(m[\"EuPump15Current\"]), EuPump16Current = todouble(m[\"EuPump16Current\"]), EuPump17Current = todouble(m[\"EuPump17Current\"]), EuPump18Current = todouble(m[\"EuPump18Current\"]), EuPump19Current = todouble(m[\"EuPump19Current\"]), EuPump20Current = todouble(m[\"EuPump20Current\"]), EuPump21Current = todouble(m[\"EuPump21Current\"]), EuPump22Current = todouble(m[\"EuPump22Current\"]), EuWastePumpVoltage = todouble(m[\"EuWastePumpVoltage\"]), EuDryerOutgoingAirflow = todouble(m[\"EuDryerOutgoingAirflow\"]), EuDryerIncomingVoltage = todouble(m[\"EuDryerIncomingVoltage\"]), EuDryerOutgoingVoltage = todouble(m[\"EuDryerOutgoingVoltage\"]), EuDryerAirTemperature = todouble(m[\"EuDryerAirTemperature\"]), EuPump1CardTemperature = todouble(m[\"EuPump1CardTemperature\"]), EuPump2CardTemperature = todouble(m[\"EuPump2CardTemperature\"]), EuPump3CardTemperature = todouble(m[\"EuPump3CardTemperature\"]), EuPump4CardTemperature = todouble(m[\"EuPump4CardTemperature\"]), EuPump5CardTemperature = todouble(m[\"EuPump5CardTemperature\"]), EuWasteJerricanWeight = todouble(m[\"EuWasteJerricanWeight\"]), EuWasteFrontPumpCurrent = todouble(m[\"EuWasteFrontPumpCurrent\"]), EuWasteRearPumpCurrent = todouble(m[\"EuWasteRearPumpCurrent\"])); raw","IsTransactional": false,"PropagateIngestionProperties": true}]'
|
