Product documentation

Unicon documentation migration is in progress. You might find some broken links or experience minor issues in the documentation. We are working on resolving these issues.

X

Scout Database Model (CR)

Table: RptDefGroup

March 25, 2025
Contributed by: 
C

This table contains all database fields of an ou 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 RptDefGroup(
    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 RptDefGroup (Field,
    Access, Text_DE, Text_EN, Type) VALUES ('EX_FQName', 'CALC_FQName',
    'Name mit Pfad', 'Name and path', 's');
    INSERT INTO RptDefGroup
    (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_Location',
    'Groups.GroupID=LocationID,Name', 'Organisationseinheit', 'Organisation
    unit', 's');
    INSERT INTO RptDefGroup (Field, Access, Text_DE, Text_EN, Type) VALUES ('Info1', null, null, null, 's');
    INSERT INTO RptDefGroup (Field, Access, Text_DE, Text_EN, Type) VALUES ('Info2', null, null, null, 's');
    INSERT INTO RptDefGroup (Field, Access, Text_DE, Text_EN, Type) VALUES ('Info3', null, null, null, 's');
    INSERT INTO RptDefGroup (Field, Access, Text_DE, Text_EN, Type) VALUES ('Name', null, null, null, 's');
    INSERT
    INTO RptDefGroup (Field, Access, Text_DE, Text_EN, Type) VALUES
    ('DeviceCount', null, 'Geräteanzahl', 'Device count', 'i');
    INSERT
    INTO RptDefGroup (Field, Access, Text_DE, Text_EN, Type) VALUES
    ('EX_DeviceCountSingle', 'CALC_DeviceCountSingle', 'Geräteanzahl(nur
    OU)', 'Device count(only OU)', 'i');
    INSERT INTO RptDefGroup (Field, Access, Text_DE, Text_EN, Type) VALUES ('GroupID', null, 'OU-ID', 'OU-ID', 'i');
    INSERT INTO RptDefGroup (Field, Access, Text_DE, Text_EN, Type) VALUES ('Note', null, 'Hinweis', 'Note', 's');
Table: RptDefGroup
March 25, 2025
Contributed by: 
C

In this article

Site feedback | Your privacy choices footer linkYour Privacy Choices | Privacy and legal terms | Cookie preferences | Consent settings | docs.cloud.com
© 1999-2025 Cloud Software Group, Inc. All rights reserved.