Scout Database Model (LTSR)
Table: RptDefApp
This table contains all database fields of an application which should be visible to the Scout report tool.
| ColumnName | DataType | Key | Not Null | Default Value | Comment |
|---|---|---|---|---|---|
| Field | NVARCHAR(255) | PK | NN | ||
| Access | NVARCHAR(255) | ||||
| Text_DE | NVARCHAR(255) | ||||
| Text_EN | NVARCHAR(255) | ||||
| Type | NVARCHAR(255) |
| IndexName | IndexType | Columns |
|---|---|---|
| PRIMARY | PRIMARY | Field |
How to create
CREATE TABLE RptDefApp(
Field NVARCHAR(255) NOT NULL,
Access NVARCHAR(255) NULL,
Text_DE NVARCHAR(255) NULL,
Text_EN NVARCHAR(255) NULL,
Type NVARCHAR(255) NULL,
PRIMARY KEY (Field));
How to initialize
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('AppOnDesktop', null, 'Desktop Symbol', 'Desktop icon', 'b');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('AutoStart', null, 'Autostart', 'Autostart', 'b');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_AppType', 'CALC_AppTypes.AppTypeID=AppTypeID,AppType', 'Typ', 'Type', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_Browser_CallPage', 'Browser.ApplicationID=ApplicationID,CallPage', 'Browser Seite', 'Browser Page', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_FQName', 'CALC_FQName', 'Name mit Pfad', 'Name and path', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_Groupname', 'Groups.GroupID=GroupID,Name', 'Organisationseinheit', 'Organisation unit', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_ICA_Application', 'ICA.ApplicationID=ApplicationID,Application', 'ICA Anwendung', 'ICA Application', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_ICA_Server', 'ICA.ApplicationID=ApplicationID,Server', 'ICA Server', 'ICA Server', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_PNA_Server', 'PNA.ApplicationID=ApplicationID,ServerUrl', 'PNA Server', 'PNA Server', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_RDP_Application', 'RDP.ApplicationID=ApplicationID,Application', 'RDP Anwendung', 'RDP Application', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_RDP_Server', 'RDP.ApplicationID=ApplicationID,Server', 'RDP Server', 'RDP Server', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_VD_Server', 'VDA.ApplicationID=ApplicationID,Server', 'VD Server', 'VD Server', 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('Name', null, null, null, 's');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('ReservedInt1', null, 'Autostart nach', 'Autostart delay', 'i');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('Roaming', null, null, null, 'b');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('TM', null, 'Dauerbetrieb', 'Restart', 'b');
INSERT INTO RptDefApp (Field, Access, Text_DE, Text_EN, Type) VALUES ('DisplayName', null, 'Anzeigename', 'Display name', 's');
Table: RptDefApp
Copied!
Failed!