1 files changed, 42 insertions, 0 deletions
diff --git a/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Machines Table.kql b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Machines Table.kql
new file mode 100644
index 000000000..b14ce6e75
--- /dev/null
+++ b/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Machines Table.kql
@@ -0,0 +1,42 @@
+.create table MachinesTable (
+    ENVIRONMENT: string,
+    GUID: string,
+    LAST_UPDATED: datetime,
+    SERIAL_NUMBER: string,
+    NAME: string,
+    PRODUCTION_DATE: datetime,
+    ORGANIZATION_GUID: string,
+    SITE_GUID: string,
+    MACHINE_VERSION_GUID: string,
+    CONFIGURATION_GUID: string,
+    DEFAULT_RML_GUID: string,
+    LOADED_RML_GUID: string,
+    TARGET_JOB_TYPES: string,
+    TARGET_COLOR_SPACE_CODES: string,
+    DEFAULT_COLOR_SPACE_GUID: string,
+    DEFAULT_SEGMENT_LENGTH: real,
+    DEFAULT_SPOOL_TYPE_GUID: string,
+    OS_KEY: string,
+    AUTO_LOGIN: bool,
+    AUTO_CHECK_FOR_UPDATES: bool,
+    SETUP_ACTIVATION: bool,
+    SETUP_REMOTE_ASSISTANCE: bool,
+    SETUP_UWF: bool,
+    SETUP_FIRMWARE: bool,
+    SETUP_FPGA: bool,
+    IS_DEMO: bool,
+    SUSPEND_VERSION_UPDATE: bool,
+    FORCE_VERSION_UPDATE: bool,
+    PERFORM_SCHEMA_UPDATE_ON_DATA_UPDATE: bool,
+    DEVICE_COM_PORT: string,
+    IS_DEVICE_REGISTERED: bool,
+    DEVICE_ID: string,
+    DEVICE_NAME: string,
+    HEAD_TYPE: int,
+    ACTIVATION_KEY: string,
+    LIGHT_INKS_INSTALLED: bool,
+    BTSR_INSTALLED: bool,
+    VERSION_TAG: string,
+    MACHINE_TYPE: int,
+    ALLOW_SMS_NOTIFICATIONS: bool
+)
+\ No newline at end of file