Kusto Scripts.

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
+)