diff options
Diffstat (limited to 'Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/JobRunsTable Policy Update.kql')
| -rw-r--r-- | Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/JobRunsTable Policy Update.kql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/JobRunsTable Policy Update.kql b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/JobRunsTable Policy Update.kql new file mode 100644 index 000000000..bc061d9d3 --- /dev/null +++ b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/JobRunsTable Policy Update.kql @@ -0,0 +1 @@ +.alter table JobRunsTable policy update @'[{"IsEnabled": true,"Source": "TelemetryTable","Query": "let raw = materialize(TelemetryTable | where Type == \"JobRun\" | extend payload = Telemetry | project ID = tostring(payload.ID), SerialNumber, MachineType, Environment, Organization, Site, CreatedTime, UploadTime, JobName = tostring(payload.JobName), Kind = tostring(payload.Kind), Thread = tostring(payload.Thread), NumberOfUnits = toint(payload.NumberOfUnits), InterSegmentLength = toint(payload.InterSegmentLength), LubricationEnabled = tobool(payload.LubricationEnabled), SpoolTypeDistribution = toint(payload.SpoolTypeDistribution), NumberOfSpools = toint(payload.NumberOfSpools), LogicalLength = todouble(payload.LogicalLength), ActualLength = todouble(payload.ActualLength), TotalLength = todouble(payload.TotalLength), StartPosition = todouble(payload.StartPosition), EndPosition = todouble(payload.EndPosition), Distance = todouble(payload.Distance), StartTime = todatetime(payload.StartTime), EndTime = todatetime(payload.EndTime), Duration = totimespan(payload.Duration), HeatingDuration = totimespan(payload.HeatingDuration), Status = tostring(payload.Status), OutputCyan = tolong(payload.OutputCyan), OutputMagenta = tolong(payload.OutputMagenta), OutputYellow = tolong(payload.OutputYellow), OutputBlack = tolong(payload.OutputBlack), OutputLightCyan = tolong(payload.OutputLightCyan), OutputLightMagenta = tolong(payload.OutputLightMagenta), OutputLightYellow = tolong(payload.OutputLightYellow), OutputBlue = tolong(payload.OutputBlue), OutputLightBlue = tolong(payload.OutputLightBlue), OutputOrange = tolong(payload.OutputOrange), OutputLightOrange = tolong(payload.OutputLightOrange), OutputRubine = tolong(payload.OutputRubine), OutputLightRubine = tolong(payload.OutputLightRubine), OutputNavy = tolong(payload.OutputNavy), OutputViolet = tolong(payload.OutputViolet), OutputTransparent = tolong(payload.OutputTransparent), OutputLubricant = tolong(payload.OutputLubricant), FailureReason = tostring(payload.FailureReason), ApplicationVersion = tostring(payload.ApplicationVersion), FirmwareVersion = tostring(payload.FirmwareVersion), Segments = payload.Segments, FineTuning = payload.FineTuning, ProcessParameters = payload.ProcessParameters); raw","IsTransactional": false,"PropagateIngestionProperties": true}]'
\ No newline at end of file |