diff options
Diffstat (limited to 'Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/MachinesUpdatesTable Policy Update.kql')
| -rw-r--r-- | Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/MachinesUpdatesTable Policy Update.kql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/MachinesUpdatesTable Policy Update.kql b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/MachinesUpdatesTable Policy Update.kql new file mode 100644 index 000000000..9b6114a69 --- /dev/null +++ b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/MachinesUpdatesTable Policy Update.kql @@ -0,0 +1 @@ +.alter table MachinesUpdatesTable policy update @'[{"IsEnabled": true,"Source": "TelemetryTable","Query": "let raw = materialize(TelemetryTable | where Type == \"MachineUpdate\" | extend payload = Telemetry | project SerialNumber, MachineType, Environment, Organization, Site, CreatedTime, UploadTime, StartTime = todatetime(payload.StartTime), EndTime = todatetime(payload.EndTime), ApplicationVersion = tostring(payload.ApplicationVersion), FirmwareVersion = tostring(payload.FirmwareVersion), VersionTag = tostring(payload.VersionTag), FailedReason = tostring(payload.FailedReason), FailedLog = tostring(payload.FailedLog), Status = tostring(payload.Status)); raw","IsTransactional": false,"PropagateIngestionProperties": true}]'
\ No newline at end of file |