blob: 6b737d08c59462807167b1d0aa5b8710566c74d5 (
plain)
1
|
.alter table MachineStatusesTable policy update @'[{"IsEnabled": true,"Source": "TelemetryTable","Query": "let raw = materialize(TelemetryTable | where Type == \"MachineStatus\" | extend payload = todynamic(Telemetry) | extend s = payload[\"Status\"] | project SerialNumber, MachineType, Environment, Organization, Site, CreatedTime, UploadTime, State = tostring(s[\"State\"]), OverallTemperature = todouble(s[\"OverallTemperature\"]), Status = s); raw","IsTransactional": false,"PropagateIngestionProperties": true}]'
|
