aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Logs Table Update Policy.kql
diff options
context:
space:
mode:
Diffstat (limited to 'Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Logs Table Update Policy.kql')
-rw-r--r--Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Logs Table Update Policy.kql1
1 files changed, 1 insertions, 0 deletions
diff --git a/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Logs Table Update Policy.kql b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Logs Table Update Policy.kql
new file mode 100644
index 000000000..bec79d4a1
--- /dev/null
+++ b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Logs Table Update Policy.kql
@@ -0,0 +1 @@
+.alter table LogsTable policy update @'[{"IsEnabled": true,"Source": "TelemetryTable","Query": "let raw = materialize(TelemetryTable | where Type == \"Log\" | extend payload = Telemetry | project SerialNumber, MachineType, Environment, Organization, Site, CreatedTime, UploadTime, Source = tostring(payload.Source), Category = tostring(payload.Category), Class = tostring(payload.Class), Method = tostring(payload.Method), Line = toint(payload.Line), Message = tostring(payload.Message)); raw","IsTransactional": false,"PropagateIngestionProperties": true}]'