Scout Database Model (CR)

Table: ICATemplate

March 25, 2025

Contributed by:

To allow working with application templates, application template tables are provided. They contain the same fields as the application tables.

ColumnName	DataType	Key	Not Null	Default Value	Comment
ApplicationTemplateID	INTEGER	PK, FK	NN		Unique application template ID (foreign key refers to table ApplicationTemplate)
Server	NVARCHAR(255)				Citrix server or Published Application name
					`<IP or name>` - Citrix server
					`<published application name>` - If a published application is specified with Application attribute
Application	NVARCHAR(255)				Application name `<program path> #<published application name>`
WorkDir	NVARCHAR(255)				Working directory
Username	NVARCHAR(255)				Username for logon
Pass	NVARCHAR(255)				User password for logon (encrypted) (use 000f4367616e78637f6c6e7e6e7a766760 for $ELUXPASSWORD single sign on)
Domain	NVARCHAR(255)				Domain name for logon
Autologin	SMALLINT(6)			0	Automatic logon0/1
Resolution	INTEGER			7	Index to the following resolution list (ignored if ResolutionDefault is set)
AllowSmartCardLogon	SMALLINT(6)				Allow smart card login (attributes Username, Pass, Domain are ignored)0/1
Width	NVARCHAR(255)			640	Screen width (depends on attribute Resolution)
					640 - if Resolution=0
					800 - if Resolution=1
					1024 - if Resolution=2
					1280 - if Resolution=3
					1600 - if Resolution=4
					`<width>` - if Resolution=5
Height	NVARCHAR(255)			480	Screen height (depends on attribute Resolution)
PercentOfScreen	NVARCHAR(255)			75	Percentage of screen size (ignored for Resolution<>6)
ColorDepth	INTEGER			2	Index to the following list (ignored if ColorDepthDefault is set)
					0 - 4 bit (16 colors)
					1 - 8 bit (256 colors)
					2 - 16 bit (32 thousand colors)
					3 - 24 bit (16 million colors)
ColorMap	INTEGER				256 color mapping (ignored if ColorMapDefault is set)
					1 - private - exact colors
					2 - shared - approximate colors
Sound	INTEGER				Sound quality
					0 - sound disabled
					1 - low quality
					2 - medium quality
					3 - high quality
Crypt	INTEGER				Encryption level
					0 - Basic
					1 - 128 bit login only
					2 - 40 bit
					3 - 56 bit
					4 - 128 bit
Compress	INTEGER				Use Data compression0/1
BitmapCache	INTEGER				Use cache for bitmaps0/1
ZLMouseMode	INTEGER				Mouse click feedback
					0 - Auto
					1 - On
					2 - Off
ZLKeyboardMode	INTEGER				Local text echo
					0 - Auto
					1 - On
					2 - Off
BrowserProtocol	INTEGER				Browser protocol
					0 - TCP/IP + HTTP
					1 - TCP/IP
					2 - SSL + HTTPS
ColorMapDefault	SMALLINT(6)				Use default color map0/1
ColorDepthDefault	SMALLINT(6)				Use default color depth0/1
ResolutionDefault	SMALLINT(6)				Use default resolution0/1
ServerLocationDefault	SMALLINT(6)				Use default server location0/1
ICAHost1	NVARCHAR(max)				IP of server location 1
ICAHost2	NVARCHAR(255)				IP of server location 2
ICAHost3	NVARCHAR(255)				IP of server location 3
ICAHost4	NVARCHAR(255)				IP of server location 4
ICAHost5	NVARCHAR(255)				IP of server location 5
EnableAudioInput	NVARCHAR(16)			No	Audio input enabledYes/No
TransportReconnectDefault	NVARCHAR(16)
TransportReconnectEnabled	NVARCHAR(16)			True	Enable reconnectTrue/False
TransportReconnectRetries	INTEGER			3	Reconnect retries
TransportReconnectDelay	INTEGER			30	Reconnect delay (in seconds)
ProxyUseDefault	NVARCHAR(16)
ProxyType	NVARCHAR(255)			None	Type of proxy serverNone/Auto/Socks/Secure
ProxyHost	NVARCHAR(255)				Connect via proxy server (ProxyType must be set) `<proxy>:<port>`
TcpGroupName1	NVARCHAR(255)
TcpGroupName2	NVARCHAR(255)
TcpGroupName3	NVARCHAR(255)
MouseSendsCtrlV	NVARCHAR(16)			Off
FileType	NVARCHAR(255)
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ApplicationTemplateID

How to create

    CREATE TABLE ICATemplate(
    ApplicationTemplateID INTEGER NOT NULL,
    Server NVARCHAR(255),
    Application NVARCHAR(255),
    WorkDir NVARCHAR(255),
    Username NVARCHAR(255),
    Pass NVARCHAR(255),
    Domain NVARCHAR(255),
    Autologin SMALLINT,
    Resolution INTEGER,
    AllowSmartCardLogon SMALLINT,
    Width NVARCHAR(255),
    Height NVARCHAR(255),
    PercentOfScreen NVARCHAR(255),
    ColorDepth INTEGER,
    ColorMap INTEGER,
    Sound INTEGER,
    Crypt INTEGER,
    Compress INTEGER,
    BitmapCache INTEGER,
    ZLMouseMode INTEGER,
    ZLKeyboardMode INTEGER,
    BrowserProtocol INTEGER,
    ColorMapDefault SMALLINT,
    ColorDepthDefault SMALLINT,
    ResolutionDefault SMALLINT,
    ServerLocationDefault SMALLINT,
    ICAHost1 NVARCHAR(max),
    ICAHost2 NVARCHAR(255),
    ICAHost3 NVARCHAR(255),
    ICAHost4 NVARCHAR(255),
    ICAHost5 NVARCHAR(255),
    EnableAudioInput NVARCHAR(16),
    TransportReconnectDefault NVARCHAR(16),
    TransportReconnectEnabled NVARCHAR(16),
    TransportReconnectRetries INTEGER,
    TransportReconnectDelay INTEGER,
    ProxyUseDefault NVARCHAR(16),
    ProxyType NVARCHAR(255),
    ProxyHost NVARCHAR(255),
    TcpGroupName1 NVARCHAR(255),
    TcpGroupName2 NVARCHAR(255),
    TcpGroupName3 NVARCHAR(255),
    MouseSendsCtrlV NVARCHAR(16),
    FileType NVARCHAR(255),
    ReservedString1 NVARCHAR(255),
    ReservedString2 NVARCHAR(255),
    ReservedInt1 INTEGER,
    ReservedInt2 INTEGER,
    CONSTRAINT FK_ICA_ApplicationTemplateID_ApplicationTemplate_ApplicationTemplateID FOREIGN KEY (ApplicationTemplateID) REFERENCES ApplicationTemplate (ApplicationTemplateID),
    PRIMARY KEY (ApplicationTemplateID));
  

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Table: ICATemplate

March 25, 2025

Contributed by:

Table: ICATemplate

How to create

In this article