aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/Tango.Telemetry/Kusto Scripts/Create Machines Table.kql
blob: b14ce6e75e76495d5da2fc8af375da1ebe532259 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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
)