Scout Database Model (CR)
Table: Application
Each entry defines an application with its main attributes. All application specific data were derived to underlying tables.
| ColumnName | DataType | Key | Not Null | Default | Comment |
|---|---|---|---|---|---|
| ApplicationID | INTEGER | PK | NN | Unique application ID | |
| AppTypeID
|
INTEGER
|
|
NN
|
|
Application type |
| 0 - APPLTYPE_EMULATION , Emulation | |||||
| 3 - APPLTYPE_BROWSER , Browser | |||||
| 4 - APPLTYPE_ICA , ICA client | |||||
| 5 - APPLTYPE_LOCALSHELL, Local application | |||||
| 7 - APPLTYPE_SAPGUI, SAP GUI | |||||
| 10 - APPLTYPE_RDP, RDP client | |||||
| 13 - APPLTYPE_PNL , PN agent | |||||
| 15 - APPLTYPE_VD , Virtual Desktop | |||||
| Name | NVARCHAR(255) | NN | Application nameThe name must be unique for each combination of AppLevel and GroupID | ||
| AutoStart | SMALLINT(6) | NN | Start automatically0/1 | ||
| TM | SMALLINT(6) | NN | Application restart (terminal mode)0/1 | ||
| AppOnDesktop | SMALLINT(6) | Desktop icon0/1 | |||
| Roaming | SMALLINT(6) | NN | Roaming (supported by AppTypeID=4 and AppTypeID=10) 0/1 | ||
| AppLevel | SMALLINT(6) | NN | Hierarchical level of application / 6 TYPE_APPLICATION_ENTRY, OU/Group level | ||
| GroupID | INTEGER | (FK) | NN | (/en-us/unicon-elux-scout/white_papers/dbmodel/entity/table_groups.html). For applications on base level this value must be set to -1. | |
| IconName | NVARCHAR(255) | Name of the icon which to be displayed on the client. | |||
| PassThrough | SMALLINT(6) | NN | 0 | Defines whether an application can use pass-through login (supported by AppTypeID=4 and AppTypeID=13)0/1 | |
| Xinerama | INTEGER | NN | 0 | Specifies the xinerama mode to be activated-1/0/1/2/3/4 | |
| SortID | INTEGER | NN | |||
| LooseParameters | NVARCHAR(max) | Holds the free parameters of an application.Multiple parameters are separated by an ‘r’ character.Example: UseICAPreLogin=1 | |||
| DisplayName | NVARCHAR(255) | Display name on client | |||
| ReservedString1 | NVARCHAR(255) | ||||
| ReservedString2 | NVARCHAR(255) | ||||
| ReservedInt1 | INTEGER | Start delay in seconds (used only if AutoStart is activated) | |||
| ReservedInt2 | INTEGER |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | ApplicationID |
How to create
CREATE TABLE Application(
ApplicationID INTEGER NOT NULL;
AppTypeID INTEGER NOT NULL;
Name NVARCHAR(255) NOT NULL;
AutoStart SMALLINT NOT NULL;
TM SMALLINT NOT NULL;
AppOnDesktop SMALLINT;
Roaming SMALLINT NOT NULL;
AppLevel SMALLINT NOT NULL;
GroupID INTEGER NOT NULL;
IconName NVARCHAR(255);
PassThrough SMALLINT;` `Xinerama INTEGER;
SortID INTEGER NOT NULL CONSTRAINT DF_Application_SortID DEFAULT 1;
LooseParameters NVARCHAR(max);
DisplayName NVARCHAR(255);
ReservedString1 NVARCHAR(255);
ReservedString2 NVARCHAR(255);
ReservedInt1 INTEGER;
ReservedInt2 INTEGER;
PRIMARY KEY (ApplicationID));
Table: Application
In this article
Copied!
Failed!