Table: VDA

Each entry describes an Virtual Desktop Application (VDA), type APPLTYPE_VD.

ColumnName	DataType	Key	Not Null	Default Value	Comment
ApplicationID	INTEGER	PK, FK	NN		Unique application ID (foreign key refers to table Application)
VDType	INTEGER			1	Virtual desktop connection broker 1 LeoStream 2 VDM client 3 XenDesktop The advanced settings of a XenDesktop definition are stored as an entry with the same ApplicationID in the ICA table 4 VMware View The advanced settings of a VMware View definition are stored as an entry with the same ApplicationID in the RDP table
Server	NVARCHAR(255)				Server name or IP address
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
UseSSL	SMALLINT(6)			0	Use secure connection via SSL 0|1
ShowLastUser	SMALLINT(6)			0	Last user is displayed in logon dialog 0|1
Options	INTEGER			0	Options (currently not used)
USBRules	NVARCHAR(255)				Defines the USB rules when connecting with VMware View
Protocol	NVARCHAR(255)			RDP	Defines the protocol which is used to present the virtual desktop RDP | PCIOP | RGS | localvm
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER
AllowH264	BIT		NN	0	for VMware Blast protocol
USBConnectOptions	INTEGER		NN	0	for VMware Blast protocol

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ApplicationID

 

how to create

CREATE TABLE VDA(
ApplicationID INTEGER NOT NULL,
VDType INTEGER,
Server NVARCHAR(255),
Username NVARCHAR(255),
Pass NVARCHAR(255),
Domain NVARCHAR(255),
UseSSL SMALLINT,
ShowLastUser SMALLINT,
Options INTEGER,
USBRules NVARCHAR(255),
Protocol NVARCHAR(255),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
AllowH264 BIT NOT NULL,
USBConnectOptions INTEGER NOT NULL,
CONSTRAINT FK_VDA_ApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
PRIMARY KEY (ApplicationID));