Scout Database Model (CR)

Table: PNATemplate

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)
ServerUrl	NVARCHAR(255)				Server name or complete server URL (f.e. `http://<server>/Citrix/PNAgent/config.xml)`
Port	INTEGER			80	Server port
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
LogoffDelay	INTEGER				Logoff delay (in seconds), ignored if attribute UseLogoffDelay is not set
UseLogoffDelay	SMALLINT(6)			0	Logoff after delay of LogoffDelay seconds0	1
AutostartFolder	NVARCHAR(255)				Folder name Applications located in this folder are started after logon
ShowLastUser	SMALLINT(6)			1	Last user is displayed in logon dialog0	1
AllowCancel	SMALLINT(6)			1	User can cancel logon dialog0	1
Resolution	INTEGER			0	Index to the following resolution list
					0 - default
					1 - 640x480
					2 - 800x600
					3 - 1024x768
					4 - 1280x1024
					5 - 1600x1200
					6 - seamless window
					7 - full screen
Colors	INTEGER			0	Index to the following list
					0 - default
					1 - 4 bit (16 colors)
					2 - 8 bit (256 colors)
					3 - 16 bit (32 thousand colors)
					4 - 24 bit (16 million colors)
Audio	INTEGER			0 0 - default	Sound quality

					1 - high quality
					2 - medium quality
					3 - low quality
					4 - sound disabled
ForcedLogoff	SMALLINT(6)			0	Logoff after last PN agent session was closed0/1
LogoffSessions	SMALLINT(6)			0	Logoff PNA sessions if user logs off from client0/1
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ApplicationTemplateID

How to create

    CREATE TABLE PNATemplate(
    ApplicationTemplateID INTEGER NOT NULL,
    ServerUrl NVARCHAR(255),
    Port INTEGER,
    Username NVARCHAR(255),
    Pass NVARCHAR(255),
    Domain NVARCHAR(255),
    LogoffDelay INTEGER,
    UseLogoffDelay SMALLINT,
    AutostartFolder NVARCHAR(255),
    ShowLastUser SMALLINT,
    AllowCancel SMALLINT,
    Resolution INTEGER,
    Colors INTEGER,
    Audio INTEGER,
    ForcedLogoff SMALLINT,
    LogoffSessions SMALLINT,
    ReservedString1 NVARCHAR(255),
    ReservedString2 NVARCHAR(255),
    ReservedInt1 INTEGER,
    ReservedInt2 INTEGER,
    CONSTRAINT FK_PNA_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: PNATemplate

March 25, 2025

Contributed by:

Table: PNATemplate

How to create

In this article