Table: Setup
This is one of the major tables. It stores device configuration data for OUs/groups or devices.
ColumnName | DataType | Key | Not Null | Default Value | Comment | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SetupID | INTEGER | PK | NN | Unique setup ID | |||||||||||||||||||
ShowTaskbar | SMALLINT(6) | NN | Show
taskbar 0|1 |
||||||||||||||||||||
BackgroundImage | NVARCHAR(255) | File name of background image | |||||||||||||||||||||
TaskbarAlwaysOnTop | SMALLINT(6) | NN | Taskbar
always visible on top 0|1 |
||||||||||||||||||||
TaskbarAutoHide | SMALLINT(6) | NN | Hide
taskbar automatically 0|1 |
||||||||||||||||||||
TaskbarShowClock | SMALLINT(6) | NN | Show
clock in taskbar 0|1 |
||||||||||||||||||||
NextFocusKey | NVARCHAR(255) | NN | Up | Key
component of keyboard shortcut to switch to next task Up|Tab |
|||||||||||||||||||
NextFocusMod | NVARCHAR(255) | NN | C1 | Modifier
component of keyboard shortcut to switch to next task C1|1 |
|||||||||||||||||||
PrevFocusKey | NVARCHAR(255) | NN | Down | Key
component of keyboard shortcut to switch to previous task Down|Tab |
|||||||||||||||||||
PrevFocusMod | NVARCHAR(255) | NN | C1 | Modifier
component of hotkey to switch to previous task C1|S1 |
|||||||||||||||||||
DesktopBackColor | NVARCHAR(255) | NN | #668ab9 | Desktop
background color (RGB) #<RRGGBB> |
|||||||||||||||||||
LanguageID | INTEGER | FK | NN | Language ID (foreign key refers to table Language.LanguageID) | |||||||||||||||||||
TimeZoneID | INTEGER | FK | NN | Time zone ID (foreign key refers to table TimeZone.TimeZoneID) | |||||||||||||||||||
Home | NVARCHAR(255) | Browser home directory | |||||||||||||||||||||
AllowX11Clients | SMALLINT(6) | NN | X11
clients allowed 0|1 |
||||||||||||||||||||
PointerProtocol | NVARCHAR(10) | NN | auto | Mouse
pointer protocol
|
|||||||||||||||||||
LeftHandMouse | SMALLINT(6) | NN | 0 | Left
hand mouse 0|1 |
|||||||||||||||||||
MultiClickTime | INTEGER | NN | 500 | Double click time 100(fast) - 900(slow) | |||||||||||||||||||
DeadKeys | SMALLINT(6) | NN | 1 | Dead
keys active 0|1 |
|||||||||||||||||||
Numlock | SMALLINT(6) | NN | 1 | Numlock
at start 0|1 |
|||||||||||||||||||
PointerSpeed | NVARCHAR(15) | 2/1 | Mouse acceleration 3/10(slow) - 13/2(fast) | ||||||||||||||||||||
KeyboardDelay | INTEGER | 500 | Keyboard delay (100-1510) | ||||||||||||||||||||
KeyboardSpeed | INTEGER | NN | 30 | Keyboard speed (10-250) | |||||||||||||||||||
ConsoleSwitch | INTEGER | 1 | Enable
switch to debug console 0|1 |
||||||||||||||||||||
XkbLayoutID | INTEGER | FK | NN | 24 | Keyboard Layout (foreign key refers to Xkblayout.XkbLayoutID) | ||||||||||||||||||
BootMode | NVARCHAR(15) | NN | |||||||||||||||||||||
Hostname | NVARCHAR(255) | ||||||||||||||||||||||
FirmwareID | INTEGER | FK | NN | Firmware ID
Foreign key refers to Firmware.FirmwareID |
|||||||||||||||||||
SmartCardDevice | NVARCHAR(15) | NN | |||||||||||||||||||||
SmartCardCheck | NVARCHAR(15) | NN | |||||||||||||||||||||
SmartCardDomain | NVARCHAR(255) | ||||||||||||||||||||||
RamDiskPercent | INTEGER | NN | |||||||||||||||||||||
UseUSB | SMALLINT(6) | ||||||||||||||||||||||
AuthServer | NVARCHAR(255) | ||||||||||||||||||||||
AuthBase | NVARCHAR(255) | ||||||||||||||||||||||
AuthVersion | NVARCHAR(255) | ||||||||||||||||||||||
AuthType | SMALLINT(6) | 0 | Type
of user authentication
|
||||||||||||||||||||
Mirror | SMALLINT(6) | 1 | Mirror
enabled 0|1 |
||||||||||||||||||||
MirrorPassword | NVARCHAR(255) | ||||||||||||||||||||||
MirrorAcceptTimeout | INTEGER | NN | 10 | ||||||||||||||||||||
port_lp | INTEGER | 0 | |||||||||||||||||||||
port_usb | INTEGER | 9101 | |||||||||||||||||||||
port_lpsave | INTEGER | 9100 | |||||||||||||||||||||
ImageFile | NVARCHAR(255) | ||||||||||||||||||||||
LocalPassword | NVARCHAR(255) | ||||||||||||||||||||||
LockedFields | NVARCHAR(255) | NN | |||||||||||||||||||||
ConnectTimeout | INTEGER | ||||||||||||||||||||||
DomainFieldStatus | INTEGER | ||||||||||||||||||||||
ShowLastUser | SMALLINT(6) | 1 | Last
logged-on username displayed in user logon dialog 0|1 |
||||||||||||||||||||
LPDService | SMALLINT(6) | 1 | Enable
LPD print service 0|1 |
||||||||||||||||||||
LogLevel | INTEGER | 0 | Verbosity level for diagnostic info: 1 | 6 | ||||||||||||||||||||
DiagURL | NVARCHAR(255) | URL to send diagnostic data to | |||||||||||||||||||||
ScreenRotate | INTEGER | 0 | Screen
rotation 90|180|270 |
||||||||||||||||||||
TpChannel | INTEGER | 0 | 0
TCP/IP 1 RDP/ICA |
||||||||||||||||||||
UseServerProfile | SMALLINT(6) | 0 | Use
server stored user profiles 0|1 |
||||||||||||||||||||
ServerProfilePath | NVARCHAR(255) | Server UNC used to store user profiles | |||||||||||||||||||||
TaskbarOption | INTEGER | 1843 | Taskbar
options as a combination of the following values:
|
||||||||||||||||||||
USBUserInfo | SMALLINT(6) | 1 | Show
info message box if USB mass storage device is connected/disconnected 0|1 |
||||||||||||||||||||
IdleTimeout | INTEGER | 10 | After the client has established a connection to the server, the client will disconnect the TCP connection after the specified period of idle time | ||||||||||||||||||||
DesktopOption | INTEGER | 259 771 |
from Scout Enterprise 15.4 to 15.8 from Scout Enterprise 15.9 The following options and their combinations are provided:
|
||||||||||||||||||||
DesktopWriteable | SMALLINT(6) | 0 | Determines whether desktop objects can be modified 0|1 |
||||||||||||||||||||
KeyboardModel | NVARCHAR(255) | Type of keyboard model
|
|||||||||||||||||||||
XPWriteFilter | INTEGER | 1 | Enables the write filter on XPe clients 0|1 |
||||||||||||||||||||
WMOption | INTEGER | 1 | Defines the window manager option 0 (no option)|1 (Animated windows) |2 (xinerama) |
||||||||||||||||||||
AuthOptions | INTEGER | 0 (no option) | 1 (AllowSCUserAuth) | |||||||||||||||||||||
ExtendedKeys | INTEGER |
|
|||||||||||||||||||||
KeepAlive | INTEGER |
|
|||||||||||||||||||||
NetworkOptions | INTEGER |
|
|||||||||||||||||||||
ExtendedKeys | INTEGER | ||||||||||||||||||||||
MirrorAcceptTimeout | INTEGER | NN | 10 | Timeout in seconds for mirror request | |||||||||||||||||||
LockControlPanel | BIT | NN | 0 | Protect control panel by password | |||||||||||||||||||
PowerManagementProfileType | INTEGER | NN | 0 | Profile for power management | |||||||||||||||||||
LogoffBeforeSuspend | BIT | NN | 0 | ||||||||||||||||||||
WorkingHourFrom | INTEGER | NN | 25200 | ||||||||||||||||||||
WorkingHourTo | INTEGER | NN | 64800 | ||||||||||||||||||||
WorkingDays | INTEGER | NN | 0 | ||||||||||||||||||||
Hotkeys | NVARCHAR(255) | NN | '1=<Ctrl><Alt>End' | Keyboard shortcut for screen saver | |||||||||||||||||||
LowBatteryLevel | INTEGER | NN | 10 | Power management option | |||||||||||||||||||
AutoRequestLicenses | INTEGER | NN | 0 |
|
|||||||||||||||||||
FollowMeDesktop | BIT | NN | 1 | ||||||||||||||||||||
ADAutologin | BIT | Auto-logon option for AD authentication | |||||||||||||||||||||
ADAutologinUser | NVARCHAR(255) | ||||||||||||||||||||||
ADAutologinPassword | NVARCHAR(255) | ||||||||||||||||||||||
ADAutologinDomain | NVARCHAR(255) | ||||||||||||||||||||||
TouchpadState | TINYINT | 1 | |||||||||||||||||||||
PowerLineFrequency | TINYINT | Powerline frequency can be configured on the Hardware tab | |||||||||||||||||||||
SortOrder | TINYINT | 1 | Sort order of desktop icons (default is ascending) | ||||||||||||||||||||
UseSmartcard | BIT | Option allowing use of smart card for Evidian authentication | |||||||||||||||||||||
[Secret] | NVARCHAR(255) | Secret which must be configured (same as is used to set up the Evidian backend) | |||||||||||||||||||||
TimeFormat | TINYINT | Time format on devices
|
|||||||||||||||||||||
ShutdownConfirmationTimerEnabled | BIT | NN | 0 | 0|1 | |||||||||||||||||||
ShutdownConfirmationTimer | TINYINT | NN | 10 | Time span in seconds (10 to 60) | |||||||||||||||||||
KioskFile | NVARCHAR(max) | Kiosk mode settings defined via Console (Device config > Security) | |||||||||||||||||||||
ReservedString1 | NVARCHAR(255) | ||||||||||||||||||||||
ReservedString2 | NVARCHAR(255) | ||||||||||||||||||||||
ReservedInt1 | INTEGER | ||||||||||||||||||||||
ReservedInt2 | INTEGER |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | SetupID |
how to create
CREATE TABLE Setup(
SetupID INTEGER NOT NULL,
ShowTaskbar SMALLINT NOT NULL,
BackgroundImage NVARCHAR (255),
TaskbarAlwaysOnTop SMALLINT NOT NULL,
TaskbarAutoHide SMALLINT NOT NULL,
TaskbarShowClock SMALLINT NOT NULL,
NextFocusKey NVARCHAR(255) NOT NULL,
NextFocusMod NVARCHAR(255) NOT NULL,
PrevFocusKey NVARCHAR(255) NOT NULL,
PrevFocusMod NVARCHAR(255) NOT NULL,
DesktopBackColor NVARCHAR(255) NOT NULL,
LanguageID INTEGER NOT NULL,
TimeZoneID INTEGER NOT NULL,
Home NVARCHAR(255),
AllowX11Clients SMALLINT NOT NULL,
PointerProtocol NVARCHAR(10) NOT NULL,
LeftHandMouse SMALLINT NOT NULL,
MultiClickTime INTEGER NOT NULL,
DeadKeys SMALLINT NOT NULL,
Numlock SMALLINT NOT NULL,
PointerSpeed NVARCHAR(15),
KeyboardDelay INTEGER,
KeyboardSpeed INTEGER NOT NULL,
ConsoleSwitch INTEGER,
XkbLayoutID INTEGER NOT NULL,
Hostname NVARCHAR(255),
FirmwareID INTEGER NOT NULL,
SmartCardDevice NVARCHAR(15) NOT NULL,
SmartCardCheck NVARCHAR(15) NOT NULL,
SmartCardDomain NVARCHAR(255),
RamDiskPercent INTEGER NOT NULL,
UseUSB SMALLINT,
AuthServer NVARCHAR(255),
AuthBase NVARCHAR(255),
AuthVersion NVARCHAR(255),
AuthType SMALLINT,
Mirror SMALLINT,
MirrorPassword NVARCHAR(255),
MirrorAcceptTimeout INTEGER NOT NULL DEFAULT 10,
port_lp INTEGER,
port_usb INTEGER,
port_lpsave INTEGER,
ImageFile NVARCHAR(255),
LocalPassword NVARCHAR(255),
LockedFields NVARCHAR(255) NOT NULL,
ConnectTimeout INTEGER,
DomainFieldStatus INTEGER,
ShowLastUser SMALLINT,
LPDService SMALLINT,
LogLevel INTEGER,
DiagURL NVARCHAR(255),
ScreenRotate INTEGER,
TpChannel INTEGER,
UseServerProfile SMALLINT,
ServerProfilePath NVARCHAR(255),
TaskbarOption INTEGER,
USBUserInfo SMALLINT,
IdleTimeout INTEGER,
KeyboardModel NVARCHAR(255),
DesktopOption INTEGER,
DesktopWriteable SMALLINT,
XPWriteFilter INTEGER,
WMOption INTEGER,
AuthOptions INTEGER,
ExtendedKeys INTEGER,
KeepAlive INTEGER,
NetworkOptions INTEGER,
ExtendedKeys INTEGER,
MirrorAcceptTimeout INTEGER NOT NULL,
LockControlPanel BIT NOT NULL,
PowerManagementProfileType INTEGER NOT NULL,
LogoffBeforeSuspend BIT NOT NULL,
WorkingHourFrom INTEGER NOT NULL,
WorkingHourTo INTEGER NOT NULL,
WorkingDays INTEGER NOT NULL,
Hotkeys NVARCHAR(255) NOT NULL,
LowBatteryLevel INTEGER NOT NULL,
AutoRequestLicenses INTEGER NOT NULL DEFAULT 0,
FollowMeDesktop BIT NOT NULL DEFAULT 1,
ADAutologin BIT,
ADAutologinUser NVARCHAR(255),
ADAutologinPassword NVARCHAR(255),
ADAutologinDomain NVARCHAR(255),
TouchpadState TINYINT,
PowerLineFrequency TINYINT,
SortOrder TINYINT CONSTRAINT DF_Setup_SortOrder DEFAULT 1,
UseSmartcard BIT,
[Secret] __UNICON_VARCHAR__(255),
TimeFormat TINYINT,
ShutdownConfirmationTimerEnabled BIT NOT NULL DEFAULT 0;
ShutdownConfirmationTimer TINYINT NOT NULL DEFAULT 10;
KioskFile NVARCHAR(max)
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER, CONSTRAINT FK_Setup_FirmwareID_Firmware_FirmwareID FOREIGN KEY (FirmwareID) REFERENCES Firmware (FirmwareID),
CONSTRAINT FK_Setup_LanguageID_Language_LanguageID FOREIGN KEY (LanguageID) REFERENCES Language (LanguageID),
CONSTRAINT FK_Setup_TimeZoneID_TimeZone_TimeZoneID FOREIGN KEY (TimeZoneID) REFERENCES TimeZone (TimeZoneID),
CONSTRAINT FK_Setup_XkbLayoutID_XkbLayout_XkbLayoutID FOREIGN KEY (XkbLayoutID) REFERENCES XkbLayout (XkbLayoutID),
PRIMARY KEY (SetupID));