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}]'
|
