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
autoauto-detect (Buttons=5) 
PS/22 button mouse (Buttons=2) or 3 button mouse (Buttons=3) 
IMPS/2wheel mouse (Buttons=5) 
noneno mouse (Buttons=none)
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
0No 
3AD
5AD+Smartcard
10Evidian
 
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:
1QuickConfig keyboard
2QuickConfig volume
4QuickConfig peripherals
16QuickConfig network
32QuickConfig display
64Show 'Show desktop' icon
256(0x100) Show device information
512(0x200) Show date and time
1024(0x400) Show live information icons
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:

0 Do not show any icons on the desktop
1 Show only application icons (enabled by default)
2 Show volumes (enabled by default)
4 Show 'Home' folder
8 Show 'Computer' folder
16 Show 'Trash' folder
32 Show 'Network' folder
256 (0x100) Show Config panel icon (enabled by default)
512 (0x200) Sort configuration panel (enabled by default)
DesktopWriteable SMALLINT(6)     0 Determines whether desktop objects can be modified
0|1
KeyboardModel NVARCHAR(255)       Type of keyboard model
AutoKeyboard model is detected automatically: configured by default
CherryCherry G81-8000 keyboard
DeskoDesko MCx 4717 keyboard
K293MFII keyboard
TYPE6Sun Type6 keyboard
K235Trimo 3270 keyboard
K257Trimo 97801 keyboard
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
0 No keys
127 All keys
KeepAlive INTEGER
60 Minimum
600 Default
NetworkOptions INTEGER
0 No options
1 Keep Alive is active
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
0 Client does not request application licenses
1 Client requests application license if corresponding software package is installed
2 Client requests application license when corresponding software is started on the device
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
0auto
112 h time format
224 h time format
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));