Scout Database Model (CR)
Table: Groups
Each entry represents a organization unit (formerly known as group) of the Scout hierarchy. Every OU has exact one owner OU, which is also known as parent OU.
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| GroupID | INTEGER | PK | NN | Unique OU/group ID | |
| WolServerID | INTEGER | FK | WakeOnLAN server ID Foreign key referring to table Server.ServerID | ||
| LocationID | INTEGER | FK | NN | ID of the owning OU/group Foreign key refers to table Groups.GroupID-1: top level OU | |
| Name | NVARCHAR(255) | NN | Unique name of OU/group | ||
| UseParent | SMALLINT(6) | NN | 1 | Use setup of the owning OU/group0/1 | |
| Info1 | NVARCHAR(255) | Arbitrary user information | |||
| Info2 | NVARCHAR(255) | Arbitrary user information | |||
| Info3 | NVARCHAR(255) | Arbitrary user information | |||
| ClientAccessType
|
INTEGER
|
|
|
1
|
Group access control for clients |
| 0 / OU/group is invisible to clients (not browsable) | |||||
| 1 / OU/group is visible (browsable and joinable) | |||||
| ClientAccessPassword | NVARCHAR(255) | Crypted password required to join the OU/group | |||
| UseParentApps | SMALLINT(6) | 1 | Use applications of the owning group in addition0/1 | ||
| UseParentAppDefaults | SMALLINT(6) | 1 | Use application settings of the owning OU/group0/1 | ||
| DefaultPrinter | NVARCHAR (255) | Name of default printer (must exist in table Printer for the according SetupID) | |||
| DriverNames | NVARCHAR(max) | OU/group specific list of printer/driver mappingsprinter1==driver1::printer2==driver2::printerN==driverN
|
|||
| LastApplicationAction
|
NVARCHAR(255)
|
|
|
#NONE
|
Action takes place when the last application is closed |
| #NONE / Do nothing | |||||
| #RESTARTX / Logoff user | |||||
| #REBOOT / Reboot device | |||||
| #OFF / Shutdown the device | |||||
| #LOCK / Lock the device | |||||
| #VPNDISCON / Disconnect from VPN | |||||
| LastApplicationActionDelay | INTEGER | 0 | Delay (in seconds) before LastApplicationAction is processed | ||
| Resolution | NVARCHAR(255) | 1024x768 | Screen resolution640x480/800x600/1024x768/1152x864/1280x1024/1600x1200 | ||
| Frequency | INTEGER | 60 | Screen frequency60/70/75/80/85/90/100 | ||
| ColorDepth | INTEGER | 16 | Screen color depth8/16/24 | ||
| UseDDC | SMALLINT(6) | 1 | Use DDC setting of the owning OU/group0/1 | ||
| UseParentScreenSettings | SMALLINT(6) | 1 | Use screen settings of the owning OU/group0/1 | ||
| UpdateParallel | INTEGER | 10 | Amount of devices which are updated together | ||
| UpdateDelay | INTEGER | 30 | -obsolete- | ||
| UpdateConnect | INTEGER | 2 | Timeout (in seconds) when connecting a device | ||
| UseParentUpdateSettings | SMALLINT(6) | 1 | Use update settings of the owning OU/group0/1 | ||
| UseParentMouseKBSettings | SMALLINT(6) | 1 | Use mouse and keyboard settings of the owning OU/group0/1 | ||
| UsePeerIP | SMALLINT(6) | 0 | Use peer IP (such as access point with NAT) when connecting the client (instead of device IP)0/1 | ||
| UseParentArray | NVARCHAR(255) | FF | Bit field indicates which property should be used from the owning OU/group | ||
| FirstContactAction | INTEGER | -1 | |||
| SetupID | INTEGER | FK | 0 | Setup ID (/en-us/unicon-elux-scout/white_papers/dbmodel/setup/table_setup.html).SetupID | |
| DevNameTemplate | NVARCHAR(255) | Name of the device name templateExample: <DEV>_MAC
|
|||
| DeviceCount | INTEGER | Number of devices in this OU and subordinate OUs | |||
| ReservedString1 | NVARCHAR(255) | ||||
| ReservedString2 | NVARCHAR(255) | ||||
| ReservedInt1 | INTEGER | ||||
| ReservedInt2 | INTEGER | ||||
| Note | NVARCHAR(255) | ||||
| OUType | INTEGER | NN | 0 |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | GroupID |
How to create
CREATE TABLE Groups(
GroupID INTEGER NOT NULL,
WolServerID INTEGER,
LocationID INTEGER NOT NULL,
Name NVARCHAR(255) NOT NULL,
UseParent SMALLINT NOT NULL,
Info1 NVARCHAR(255),
Info2 NVARCHAR(255),
Info3 NVARCHAR(255),
ClientAccessType INTEGER,
ClientAccessPassword NVARCHAR(255),
UseParentApps SMALLINT,
UseParentAppDefaults SMALLINT,
DefaultPrinter NVARCHAR(255),
DriverNames` `NVARCHAR(max)``,
LastApplicationAction NVARCHAR(255),
LastApplicationActionDelay INTEGER,
Resolution NVARCHAR(255),
Frequency INTEGER,
ColorDepth INTEGER,
UseParentScreenSettings SMALLINT,
UpdateParallel INTEGER,
UpdateDelay INTEGER,
UpdateConnect INTEGER,
UseParentUpdateSettings SMALLINT,
UseParentMouseKBSettings SMALLINT,
UsePeerIP SMALLINT,
UseParentArray NVARCHAR(255),
FirstContactAction INTEGER,
SetupID INTEGER,
DevNameTemplate NVARCHAR(255),
DeviceCount INTEGER,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
Note NVARCHAR(255),
OUType INTEGER NOT NULL,
CONSTRAINT FK_Groups_WolServerID_Server_ServerID FOREIGN KEY (WolServerID)
REFERENCES Server (ServerID),
CONSTRAINT FK_Groups_SetupID_Setup_SetupID FOREIGN KEY (SetupID)
REFERENCES Setup (SetupID),
PRIMARY KEY (GroupID));
Table: Groups
In this article
Copied!
Failed!