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 (LTSR)

Table: RptDefAsset

March 25, 2025
Contributed by: 
C

This table contains all database fields of an asset 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

    
HOW TO CREATE TABLE RptDefAsset(
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 RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('AssetName', null, 'Name', 'Name', 's');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_AssetValue', 'CALC_AssetValue', 'Typ', 'Type', 'i');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('DeviceID', null, 'Geräte ID', 'Device ID', 's');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_ProductID', 'CALC_ProductID', 'Produkt ID', 'Product ID', 's');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_VendorID', 'CALC_VendorID', 'Hersteller ID', 'Vendor ID', 's');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_ProductText', 'CALC_ProductText', 'Beschreibung', 'Description', 's');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_VendorText', 'CALC_VendorText', 'Hersteller', 'Vendor', 's');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_Serial', 'CALC_Serial', 'Seriennummer', 'Serial number', 's');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_DeviceName', 'Device.DeviceID=DeviceID,Name', 'Gerätename', 'Device name', 's');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_DeviceMAC', 'Device.DeviceID=DeviceID,Mac_Address', 'MAC Adresse', 'MAC address', 's');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_FQName', 'CALC_FQName', 'Gerätename mit Pfad', 'Device name with path', 's');
Table: RptDefAsset
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.