aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Diagnostics Table.kql
blob: d7423cc25efc0a017388a118e395cdcf324bc4ac (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
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
)