Scout Database Model (LTSR)

Table: RptDefDevice

March 25, 2025

Contributed by:

This table contains all database fields of a device which should be visible to the Scout report tool.

ColumnName	DataType	Key	Not Null	Default Value	Comment
ColumnName	DataType	Key	NN	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 RptDefDevice(
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 RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Activated', 'CALC_TransferLockActivated', 'Konfigurationstransfer', 'Configuration transfer', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('ActiveUser', null, 'Benutzer', 'User', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('BiosVersion', null, 'Bios', 'Bios', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Container', null, null, null, 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_CpuMHz', 'CALC_CpuMHz', 'CPU (MHz)', 'CPU (MHz)', 'i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('CreationDate', null, 'Erstellungsdatum', 'Creation date', 'u');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('DeviceType', null, 'Gerätetyp', 'Device type', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Domain', null, null, null, 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_FQName', 'CALC_FQName', 'Name mit Pfad', 'Name and path', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_Groupname', 'Groups.GroupID=GroupID,Name', 'Organisationseinheit', 'Organisation unit', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_Keyboard', 'XkbLayout.XkbLayoutID=CALC_XkbLayoutID,Name', 'Tastatur', 'Keyboard', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_NumLocalPrinters', 'CALC_NumLocalPrinters', 'Anzahl lokale Drucker', 'Number of local printers', 'i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_NumNetPrinters', 'CALC_NumNetPrinters', 'Anzahl Netzwerkdrucker', 'Number of network printers', 'i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_NumPrinters', 'CALC_NumPrinters', 'Anzahl Drucker', 'Number of printers', 'i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_Printer', 'CALC_DefaultPrinter', 'Standarddrucker', 'Default printer', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_USBEnabled', 'CALC_UseUSB', 'USB zugelassen', 'USB enabled', 'b');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EluxManager', null, 'Manager', 'Manager', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('FlashSize', null, 'Flashgröße', 'Flashsize', 'i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('FlashType', null, 'Flashspeicher', 'Flash memory', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('IP_Address', null, 'IP-Adresse', 'IP address', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('ImageFile', 'DistributionImageFile.DistributionImageFileID=DistributionImageFileID,ImageFile', 'Image', 'Image', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Info1', null, null, null, 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Info2', null, null, null, 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Info3', null, null, null, 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('LastContact', null, 'Letzter Kontakt', 'Last contact', 'u');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Mac_Address', null, 'MAC-Adresse', 'MAC address', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('MemorySize', null, 'Hauptspeicher', 'Main memory', 'i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('MonitorInfo', null, 'Monitorinfo', 'Monitor Info', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('MotherBoard', null, 'Typ', 'Type', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Name', null, null, null, 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Netmask', null, 'Netzmaske', null, 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('OS', null, null, null, 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('OSVersion', null, 'OS-Version', 'OS version', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('ScreenInfo', null, 'Monitorstatus', 'Screen info', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('SerialNumber', null, 'Seriennummer', 'Serial number', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Supplier', null, 'Hersteller', 'Supplier', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('VersionString', null, 'Version', 'Version', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('NetworkSpeed', null, 'Netzwerkgeschwindigkeit', 'Network speed', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('OUByNet', 'CALC_OUByNet', 'OU-Filter aktiv', 'OU filter active', 'b');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('OUAssignment','CALC_OUAssignment','OU-Zuweisung', 'OU-Assignment', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_X97License' ,'CALC_License_18' , 'Anwendungslizenz : X97-Emulation' ,'Application license : X97 Emulation' ,'b');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_X3252License' ,'CALC_License_20' , 'Anwendungslizenz : 3270/X5250-Emulation','Application license : X3270/X5250 Emulation','b');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_LastCommandName' ,'CALC_LastCommandName' , 'Kommandoname','Command name','s');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_LastCommandResult' ,'CALC_LastCommandResult' , 'Kommandergebnis','Command result','s');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_LastCommandTime' ,'CALC_LastCommandTime' , 'Kommandzeit','Command time','u');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_ActiveMac' ,'CALC_ActiveMac' ,'Aktive MAC-Adresse', 'Active MAC address' , 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_Media' ,'CALC_Media' ,'Medium' ,'Media' ,'s');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_LastUpdateSize', 'CALC_LastUpdateSize', 'Updategröße (kB)', 'Update size (kB)', 'i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('OUCustomFilter', null, 'OU Filtertext', 'OU filter text', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_Relocation', 'CALC_Relocation', 'Umzugsvormerkung', 'Relocation notification', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_UpdatePartitionSize', 'CALC_UpdatePartitionSize', 'Updatepartition (MB)', 'Update partition (MB)', 'i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_SystemPartitionSize', 'CALC_SystemPartitionSize', 'Systempartition (MB)', 'System partition (MB)', 'i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_ConfigDataUpToDate','CALC_ConfigDataUpToDate','Konfiguration aktuell','Configuration up to date', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_LastDeliveryTime' ,'CALC_LastDeliveryTime' , 'Auslieferzeitpunkt','Delivery time','u');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_LastDeliveryResult' ,'CALC_LastDeliveryResult' , 'Auslieferergebnis','Delivery result','s');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_LastDeliverySize' ,'CALC_LastDeliverySize' , 'Ausliefergröße (kB)','Delivery size (kB)','i');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('ConfigDataID' ,NULL, 'Konfigurations-ID','Configuration id','s');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('ConfigDataIDToHave' ,NULL, 'Erwartete Konfigurations-ID','Expected configuration id','s');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_LastUpdateProvider', 'CALC_LastUpdateProvider', 'Updateprovider', 'Update provider', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_LastDeliveryProvider', 'CALC_LastDeliveryProvider', 'Auslieferprovider', 'Delivery provider', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('DeliveryImage', null, 'Auslieferimage', 'Delivery image', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_UpdateNotification', 'CALC_UpdateNotification', 'Firmwareaktualisierungsvormerkung', 'Image update notification', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('NetAddr', null, 'Netzadresse', 'Net address', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_FluendoLicenseBasic','CALC_License_91', 'Anwendungslizenz : Fluendo','Application license : Fluendo', 'b');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_FluendoLicenseSystem','CALC_License_92', 'Anwendungslizenz : Fluendo systemweit','Application license : Fluendo System-wide', 'b');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('Note', null, 'Hinweis', 'Note', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('StatusModified', null, 'Statuszeitpunkt', 'Status time', 'u');
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 ('DisplayName', null, 'Anzeigename', 'Display name', '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 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', 's');
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')
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('ClientIdentifier' ,NULL, 'Client Identifier','Client Identifier','s');
INSERT INTO RptDefAsset(Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_DeviceClientIdentifier', 'Device.DeviceID=DeviceID,ClientIdentifier', 'Client-Identifier', 'Client-Identifier', 's');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('DeliveryNotificationID', null, 'Image-Auslieferungsvormerkung', 'Image delivery notification', 'i1');
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('EX_TenantName', 'CALC_TenantName', 'Tenantname', 'Tenant name', 's'); /*New field in report definition to display the tenant name of a device */
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('DeliveryNotificationID', 'CALC_DeliveryNotification', 'Image-Auslieferungsvormerkung', 'Image delivery notification', 's'); /*New field in report definition to display the deliverynotification state*/
INSERT INTO RptDefDevice (Field, Access, Text_DE, Text_EN, Type) VALUES ('PeerIPAddress', null, 'Öffentliche Adresse', 'Public address', 's'); /*Definition in report table to filter for the public address*/
 

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

March 25, 2025

Contributed by:

Table: RptDefDevice

How to create

How to initialize

In this article