Scout Database Model (CR)
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 taskbar0/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 allowed0/1 | ||
| PointerProtocol
|
NVARCHAR(10)
|
|
NN
|
auto
|
Mouse pointer protocol |
| auto - auto-detect (Buttons=5) | |||||
| PS/2 - 2 button mouse (Buttons=2) or 3 button mouse (Buttons=3) | |||||
| IMPS/2 - wheel mouse (Buttons=5) | |||||
| none - no 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 |
| 0 - No | |||||
| 3 - AD | |||||
| 5 - AD+Smartcard | |||||
| 10 - Evidian | |||||
| 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 rotation90/180/270 | ||
| TpChannel | INTEGER | 0 | 0 TCP/IP1 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 |
| 1 - QuickConfig keyboard | |||||
| 2 - QuickConfig volume | |||||
| 4 - QuickConfig peripherals | |||||
| 16 - QuickConfig network | |||||
| 32 - QuickConfig display | |||||
| 64 - Show ‘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 | from Scout Enterprise 15.4 to 15.8 | ||
|
|
|
771
|
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 |
| Auto - Keyboard model is detected automatically: configured by default | |||||
| Cherry - Cherry G81-8000 keyboard | |||||
| Desko - Desko MCx 4717 keyboard | |||||
| K293 - MFII keyboard | |||||
| TYPE6 - Sun Type6 keyboard | |||||
| K235 - Trimo 3270 keyboard | |||||
| K257 - Trimo 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 |
| 0 -auto | |||||
| 1 - 12 h time format | |||||
| 2 - 24 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));
Table: Setup
In this article
Copied!
Failed!