Scout Database Model (CR)

Table: RDP

March 25, 2025

Contributed by:

Each entry describes an application of type APPLTYPE_RDP.

ColumnName	DataType	Key	Not Null	Default Value	Comment
ApplicationID	INTEGER	PK, FK	NN		Unique application IDForeign key refers to table Application
Server	NVARCHAR(255)				Server name (or IP)
Application	NVARCHAR(255)				Application to start
WorkDir	NVARCHAR(255)				Working directory of application
Username	NVARCHAR(255)				Username
Pass	NVARCHAR(255)				User password for logon (encrypted) (use 000f4367616e78637f6c6e7e6e7a766760 for $ELUXPASSWORD single sign on)
Domain	NVARCHAR(255)				Domain
RDPType	NVARCHAR(255)				native
Autologin	NVARCHAR(255)				Process automatic logon using Username, Pass, Domaintrue/false
Resolution	SMALLINT(6)				Index to the following resolution list
					0 full screen
					1 640x480
					2 800x600
					3 1024x768
					4 1152x864
					5 1280x1024
Colors	SMALLINT(6)				Colors:8 / 16 / 24
Keyboard	NVARCHAR(255)				Keyboard layout
					“auto” auto
					“da” Dansk
					“de” German
					“de-ch” German(Switzerland)
					“en-gb” English(UK)
					“en-us” English(UK)
					“en-us_intl” English(US,international)
					“es” Spanish
					“fi” Finnish
					“fr” French
					“fr-be” French(Belgium)
					“fr-ch” French(Switzerland)
					“hu” Hungarian
					“is” Icelandic
					“it” Italian
					“nl” Dutch
					“nl-be” Dutch(Belgium)
					“no” Norwegian
					“pl” Polish
					“pt” Portuguese
					“ru” Russian
					“sk” Slovak
					“sl” Slovenian
					“sv” Swedish
					“tr” Turkish(Q)
					“trf” Turkish(F)
Sound	SMALLINT(6)				Play sound
					0 sound off
					3 play local
					5 play remote
Printer	SMALLINT(6)				Local printer available in server session0/1
Serial	SMALLINT(6)				Local serial ports available in server session0/1
Parallel	SMALLINT(6)				Local parallel ports available in server session0/1
Smartcard	SMALLINT(6)				Local smart card available in server session0/1
Options	INTEGER			15	RDP options as a combination of the following values
					1 RDP_OPT_WMDECORATIONS, Window manager decorations enabled
					2 ~_ENCRYPTION, Encryption enabled
					4 ~_MOUSEMOTIONEVENTS, Mouse motion events enabled
					8 ~_NUMLOCKSYNC, Numlock syncronisation enabled
					16 ~_COMPRESSION, Compression enabled
Protocol	SMALLINT(6)			0	Protocol version
					0 auto
					4 RDP V4
					5 RDP V5
Bandwidth	INTEGER			0	Bandwidth to use
					0 Standard
					1 Modem
					2 Broadband
					3 LAN
DriveName1	NVARCHAR(255)				Drive letter A - Z
DriveLocalDir1	NVARCHAR(255)				Local directory to be mapped
DriveOption1	INTEGER				1 RDP_DRIVEOPT_ON, Drive enabled
DriveName2	NVARCHAR(255)				see DriveName1
DriveLocalDir2	NVARCHAR(255)				see DriveLocalDir1
DriveOption2	INTEGER				see DriveOption1
DriveName3	NVARCHAR(255)				see DriveName1
DriveLocalDir3	NVARCHAR(255)				see DriveLocalDir1
DriveOption3	INTEGER				see DriveOption1
DriveName4	NVARCHAR(255)				see DriveName1
DriveLocalDir4	NVARCHAR(255)				see DriveLocalDir1
DriveOption4	INTEGER				see DriveOption1
DriveName5	NVARCHAR(255)				see DriveName1
DriveLocalDir5	NVARCHAR(255)				see DriveLocalDir1
DriveOption5	INTEGER				see DriveOption1
DriveName6	NVARCHAR(255)				see DriveName1
DriveLocalDir6	NVARCHAR(255)				see DriveLocalDir1
DriveOption6	INTEGER				see DriveOption1
DriveName7	NVARCHAR(255)				see DriveName1
DriveLocalDir7	NVARCHAR(255)				see DriveLocalDir1
DriveOption7	INTEGER				see DriveOption1
DriveName8	NVARCHAR(255)				see DriveName1
DriveLocalDir8	NVARCHAR(255)				see DriveLocalDir1
DriveOption8	INTEGER				see DriveOption1
DriveName9	NVARCHAR(255)				see DriveName1
DriveLocalDir9	NVARCHAR(255)				see DriveLocalDir1
DriveOption9	INTEGER				see DriveOption1
DriveName10	NVARCHAR(255)				see DriveName1
DriveLocalDir10	NVARCHAR(255)				see DriveLocalDir1
DriveOption10	INTEGER
ComName1	NVARCHAR(255)
ComDev1	NVARCHAR(255)
ComName2	NVARCHAR(255)				see ComName1
ComDev2	NVARCHAR(255)				see ComDev1
ComName3	NVARCHAR(255)				see ComName1
ComDev3	NVARCHAR(255)				see ComDev1
ComName4	NVARCHAR(255)				see ComName1
ComDev4	NVARCHAR(255)				see ComDev1
ComName5	NVARCHAR(255)				see ComName1
ComDev5	NVARCHAR(255)				see ComDev1
ComName6	NVARCHAR(255)				see ComName1
ComDev6	NVARCHAR(255)				see

How to create

    CREATE TABLE RDP(
    ApplicationID INTEGER NOT NULL,
    Server NVARCHAR(255),
    Application NVARCHAR(255),
    WorkDir NVARCHAR(255),
    Username NVARCHAR(255),
    Pass NVARCHAR(255),
    Domain NVARCHAR(255),
    RDPType NVARCHAR(255),
    Autologin NVARCHAR(255),
    Resolution SMALLINT,
    Colors SMALLINT,
    Keyboard NVARCHAR(255),
    Sound SMALLINT,
    Printer SMALLINT,
    Serial SMALLINT,
    Parallel SMALLINT,
    Smartcard SMALLINT,
    Options INTEGER,
    Protocol SMALLINT,
    DriveName1 NVARCHAR(255),
    DriveLocalDir1 NVARCHAR(255),
    DriveOption1 INTEGER,
    DriveName2 NVARCHAR(255),
    DriveLocalDir2 NVARCHAR(255),
    DriveOption2 INTEGER,
    DriveName3 NVARCHAR(255),
    DriveLocalDir3 NVARCHAR(255),
    DriveOption3 INTEGER,
    DriveName4 NVARCHAR(255),
    DriveLocalDir4 NVARCHAR(255),
    DriveOption4 INTEGER,
    DriveName5 NVARCHAR(255),
    DriveLocalDir5 NVARCHAR(255),
    DriveOption5 INTEGER,
    DriveName6 NVARCHAR(255),
    DriveLocalDir6 NVARCHAR(255),
    DriveOption6 INTEGER,
    DriveName7 NVARCHAR(255),
    DriveLocalDir7 NVARCHAR(255),
    DriveOption7 INTEGER,
    DriveName8 NVARCHAR(255),
    DriveLocalDir8 NVARCHAR(255),
    DriveOption8 INTEGER,
    DriveName9 NVARCHAR(255),
    DriveLocalDir9 NVARCHAR(255),
    DriveOption9 INTEGER,
    DriveName10 NVARCHAR(255),
    DriveLocalDir10 NVARCHAR(255),
    DriveOption10 INTEGER,
    ComName1 NVARCHAR(255),
    ComDev1 NVARCHAR(255),
    ComName2 NVARCHAR(255),
    ComDev2 NVARCHAR(255),
    ComName3 NVARCHAR(255),
    ComDev3 NVARCHAR(255),
    ComName4 NVARCHAR(255),
    ComDev4 NVARCHAR(255),
    ComName5 NVARCHAR(255),
    ComDev5 NVARCHAR(255),
    ComName6 NVARCHAR(255),
    ComDev6 NVARCHAR(255),
    ReservedString1 NVARCHAR(255),
    ReservedString2 NVARCHAR(255),
    ReservedInt1 INTEGER,
    ReservedInt2 INTEGER,
    CONSTRAINT FK_RDP_ApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
    PRIMARY KEY (ApplicationID));
 

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: RDP

March 25, 2025

Contributed by:

Table: RDP

How to create

In this article