diff options
Diffstat (limited to 'Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Diagnostics Table.kql')
| -rw-r--r-- | Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Diagnostics Table.kql | 272 |
1 files changed, 272 insertions, 0 deletions
diff --git a/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Diagnostics Table.kql b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Diagnostics Table.kql new file mode 100644 index 000000000..d7423cc25 --- /dev/null +++ b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Diagnostics Table.kql @@ -0,0 +1,272 @@ +.create table DiagnosticsTable ( + SerialNumber: string, + MachineType: string, + Environment: string, + Organization: string, + Site: string, + CreatedTime: datetime, + UploadTime: datetime, + Dancer1Angle:real, + Dancer2Angle:real, + Dancer3Angle:real, + FeederMotorFrequency:real, + DryerMotor:real, + PollerMotor:real, + WinderMotor:real, + ScrewMotor:real, + ThreadSpeed:real, + MixerTemperature:real, + HeadZone1Temperature:real, + HeadZone2Temperature:real, + HeadZone3Temperature:real, + HeadAirFlow:real, + FeederTension:real, + PullerTension:real, + DryerZone1Temperature:real, + DryerZone2Temperature:real, + DryerZone3Temperature:real, + DryerAirFlow:real, + WinderTension:real, + DispensersMotorsFrequency:dynamic, + DispensersAngularEncoders:dynamic, + DispensersLinearPositions:dynamic, + DispensersPressure:dynamic, + FilterDeltaPressure:real, + ChillerTemperature:real, + Dispenser1MotorFrequency:real, + Dispenser2MotorFrequency:real, + Dispenser3MotorFrequency:real, + Dispenser4MotorFrequency:real, + Dispenser5MotorFrequency:real, + Dispenser6MotorFrequency:real, + Dispenser7MotorFrequency:real, + Dispenser8MotorFrequency:real, + HeadZone4Temperature:real, + HeadZone5Temperature:real, + HeadZone6Temperature:real, + BlowerVoltage:real, + Dispenser1Pressure:real, + Dispenser2Pressure:real, + Dispenser3Pressure:real, + Dispenser4Pressure:real, + Dispenser5Pressure:real, + Dispenser6Pressure:real, + Dispenser7Pressure:real, + Dispenser8Pressure:real, + MidTank1Level:real, + MidTank2Level:real, + MidTank3Level:real, + MidTank4Level:real, + MidTank5Level:real, + MidTank6Level:real, + MidTank7Level:real, + MidTank8Level:real, + DrierZone1HeaterCurrent:real, + DrierZone2HeaterCurrent:real, + HeadZone1HeaterCurrent:real, + HeadZone2HeaterCurrent:real, + HeadZone3HeaterCurrent:real, + HeadZone4HeaterCurrent:real, + HeadZone56HeaterCurrent:real, + Mixer1HeaterCurrent:real, + DispensersInkLevel:dynamic, + MidTanksInkLevel:dynamic, + OverallTemperature:real, + HeadZone7HeaterCurrent:real, + HeadZone7Temperature:real, + HeadZone8HeaterCurrent:real, + HeadZone8Temperature:real, + HeadZone9HeaterCurrent:real, + HeadZone9Temperature:real, + HeadZone10HeaterCurrent:real, + HeadZone10Temperature:real, + HeadZone11HeaterCurrent:real, + HeadZone11Temperature:real, + HeadZone12HeaterCurrent:real, + HeadZone12Temperature:real, + HeadBlowerVoltage1:real, + HeadBlowerVoltage2:real, + HeadCoverHeater1Current:real, + HeadCoverHeater1Temperature:real, + HeadCoverHeater2Current:real, + HeadCoverHeater2Temperature:real, + WHSBlower2Voltage:real, + GasSensor:real, + IncomingVoltage:real, + WasteLevel:real, + HeadBlower1AirFlow:real, + HeadBlower2AirFlow:real, + ShinkoSetValue:real, + ShinkoCurrentValue:real, + TotalWHSFlow:real, + EuWinder1Dancer:real, + EuWinder2Dancer:real, + EuWinder3Dancer:real, + EuWinder4Dancer:real, + EuWinder1Motor:real, + EuWinder2Motor:real, + EuWinder3Motor:real, + EuWinder4Motor:real, + EuDryerMotorVelocity:real, + EuDryerMotorTargetVelocity:real, + EuDryerMotorCurrent:real, + EuPullerDancer:real, + EuPullerMotor:real, + EuDryerZone1Temperature:real, + EuDryerZone2Temperature:real, + EuDryerZone3Temperature:real, + EuHeadZone1Temperature:real, + EuHeadZone2Temperature:real, + EuHeadZone3Temperature:real, + EuMixerTemperature:real, + EuTunnelTemperature:real, + EuLubricantTemperature:real, + EuAmbientTemperature:real, + EuElectricalCabinetTemperature:real, + EuDryerZone1Current:real, + EuDryerZone2Current:real, + EuDryerZone3Current:real, + EuHeadZone1Current:real, + EuHeadZone2Current:real, + EuHeadZone3Current:real, + EuMixerCurrent:real, + EuTunnelCurrent:real, + EuLubricantCurrent:real, + EuBtsr1Speed:real, + EuBtsr1SpeedAv:real, + EuBtsr1DispAv:real, + EuBtsr1PeakMin:real, + EuBtsr1PeakMax:real, + EuBtsr2Speed:real, + EuBtsr2SpeedAv:real, + EuBtsr2DispAv:real, + EuBtsr2PeakMin:real, + EuBtsr2PeakMax:real, + EuBtsr3Speed:real, + EuBtsr3SpeedAv:real, + EuBtsr3DispAv:real, + EuBtsr3PeakMin:real, + EuBtsr3PeakMax:real, + EuBtsr4Speed:real, + EuBtsr4SpeedAv:real, + EuBtsr4PeakMin:real, + EuBtsr4PeakMax:real, + EuBtsr4DispAv:real, + EuTemperatureLoggers:dynamic, + EuPumpFlows:dynamic, + EuInkLinesPressure:dynamic, + EuSpareDataArray:dynamic, + EuDispenser1Voltage:real, + EuDispenser2Voltage:real, + EuDispenser3Voltage:real, + EuDispenser4Voltage:real, + EuDispenser5Voltage:real, + EuDispenser6Voltage:real, + EuDispenser7Voltage:real, + EuDispenser8Voltage:real, + EuDispenser9Voltage:real, + EuDispenser10Voltage:real, + EuDispenser11Voltage:real, + EuDispenser12Voltage:real, + EuDispenser13Voltage:real, + EuDispenser14Voltage:real, + EuDispenser15Voltage:real, + EuDispenser16Voltage:real, + EuLubricantPumpVoltage:real, + EuDispenser1Pressure:real, + EuDispenser2Pressure:real, + EuDispenser3Pressure:real, + EuDispenser4Pressure:real, + EuDispenser5Pressure:real, + EuDispenser6Pressure:real, + EuDispenser7Pressure:real, + EuDispenser8Pressure:real, + EuLubricantPressure:real, + EuMidTank1Level:real, + EuMidTank2Level:real, + EuMidTank3Level:real, + EuMidTank4Level:real, + EuMidTank5Level:real, + EuMidTank6Level:real, + EuMidTank7Level:real, + EuMidTank8Level:real, + EuChillerTemperature:real, + EuHeadRightAirFlow:real, + EuHeadLeftAirFlow:real, + EuHeadRightVoltage:real, + EuHeadLeftVoltage:real, + EuDryerAirFlow:real, + EuBlowerVoltage:real, + EuWasteLevel:real, + EuSpare1:real, + EuSpare2:real, + EuSpare3:real, + EuSpare4:real, + EuBtsr5DispAv:real, + EuBtsr6DispAv:real, + EuBtsr7DispAv:real, + EuBtsr8DispAv:real, + EuBtsr5PeakMax:real, + EuBtsr6PeakMax:real, + EuBtsr7PeakMax:real, + EuBtsr8PeakMax:real, + EuBtsr5PeakMin:real, + EuBtsr6PeakMin:real, + EuBtsr7PeakMin:real, + EuBtsr8PeakMin:real, + EuBtsr5Speed:real, + EuBtsr6Speed:real, + EuBtsr7Speed:real, + EuBtsr8Speed:real, + EuBtsr5SpeedAv:real, + EuBtsr6SpeedAv:real, + EuBtsr7SpeedAv:real, + EuBtsr8SpeedAv:real, + EuDispenser17Voltage:real, + EuDispenser18Voltage:real, + EuDispenser19Voltage:real, + EuDispenser20Voltage:real, + EuDispenser21Voltage:real, + EuDispenser22Voltage:real, + EuDispenser9Pressure:real, + EuDispenser10Pressure:real, + EuDispenser11Pressure:real, + EuMidTank9Level:real, + EuMidTank1Level0:real, + EuMidTank1Level1:real, + EuPump1Current:real, + EuPump2Current:real, + EuPump3Current:real, + EuPump4Current:real, + EuPump5Current:real, + EuPump6Current:real, + EuPump7Current:real, + EuPump8Current:real, + EuPump9Current:real, + EuPump10Current:real, + EuPump11Current:real, + EuPump12Current:real, + EuPump13Current:real, + EuPump14Current:real, + EuPump15Current:real, + EuPump16Current:real, + EuPump17Current:real, + EuPump18Current:real, + EuPump19Current:real, + EuPump20Current:real, + EuPump21Current:real, + EuPump22Current:real, + EuWastePumpVoltage:real, + EuDryerOutgoingAirflow:real, + EuDryerIncomingVoltage:real, + EuDryerOutgoingVoltage:real, + EuDryerAirTemperature:real, + EuPump1CardTemperature:real, + EuPump2CardTemperature:real, + EuPump3CardTemperature:real, + EuPump4CardTemperature:real, + EuPump5CardTemperature:real, + EuWasteJerricanWeight:real, + EuWasteFrontPumpCurrent:real, + EuWasteRearPumpCurrent:real +) |