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
0APPLTYPE_EMULATIONEmulation
3APPLTYPE_BROWSERBrowser
4APPLTYPE_ICAICA client
5APPLTYPE_LOCALSHELLLocal application
7APPLTYPE_SAPGUISAP GUI
10APPLTYPE_RDPRDP client
13APPLTYPE_PNLPN agent
15APPLTYPE_VDVirtual Desktop
Name NVARCHAR(255)   NN   Application name
The name must be unique for each combination of AppLevel and GroupID
AutoStart SMALLINT(6)   NN   Start automatically
0|1
TM SMALLINT(6)   NN   Application restart (terminal mode)
0|1
AppOnDesktop SMALLINT(6)       Desktop icon
0|1
Roaming SMALLINT(6)   NN   Roaming (supported by AppTypeID=4 and AppTypeID=10)
0|1
AppLevel SMALLINT(6)   NN   Hierarchical level of application
6TYPE_APPLICATION_ENTRYOU/Group level
 
GroupID INTEGER (FK) NN   ID of the OU/group which is owner of this application (see table Groups).
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));