Scout Database Model (CR)

Table: Device

March 25, 2025

Contributed by:

Each entry represents a device which is member of a group. Many attributes are marked to be set by the client or by the Scout server. These values should not be changed since they will be overwritten.

Column name	Data type	Key	Not Null	Default Value	Comment
DeviceID	INTEGER	PK	NN		Unique device ID
WolServerID	INTEGER	FK			WakeOnLAN server ID (foreign key refers to table ServerID)
GroupID	INTEGER	FK	NN		ID of the owning group (foreign key refers to table GroupID)
Name	NVARCHAR(255)		NN		Unique name of device
UseParent	SMALLINT(6)		NN	1	Use setup of the owning group0/1
Info1	NVARCHAR(255)				Arbitrary user information
Info2	NVARCHAR(255)				Arbitrary user information
Info3	NVARCHAR(255)				Arbitrary user information
IP_Address	NVARCHAR(15)		NN		IP address (dotted notation)
Mac_Address	NVARCHAR(15)		NN		MAC address
Activated	SMALLINT(6)		NN		Management enabled0/1
HostID	NVARCHAR(30)				Client host ID
ImageFile	NVARCHAR(255)				Currently installed IDF file (set by client)
VersionString	NVARCHAR(15)				Version (set by client)
LocalPassword	NVARCHAR(255)				Encrypted device password
EluxManager	NVARCHAR(255)				Manager IP address
Environment	NVARCHAR(255)				obsolete
Serial Number	NVARCHAR(255)				Serial number (set by client)
UpdateInfo	NVARCHAR(255)			-1,0,0,0,0	Update state (set by Scout server)
CommandInfo	NVARCHAR(255)
SetupID	INTEGER	FK		0	Setup ID (/en-us/unicon-elux-scout/white_papers/dbmodel/setup/table_setup.html.SetupID)
SetupChanged	SMALLINT(6)				obsolete
SetupUserChanged	SMALLINT(6)				set by Scout server
Status	SMALLINT(6)			99	Device state (set by Scout server)
					0 - Device is off or unreached
					1 - Device discovery in progress
					2 - Device logon in progress
					3 - Device up and running
					4 - Device updating
					99 - Device state unknown
Discovered	SMALLINT(6)			0	set by Scout server
Action	INTEGER			11	Action to take place if device contacts manager
					0 - ACTION_NOTHING - Do nothing
					or a combination of the following values
					1 - ACTION_SETUPCHANGED - Device must refetch setup data
					2 - ACTION_USERSETUPCHANGED -Device must refetch user setup data
					4- ACTION_XRESTART - Device must re-logon
					8 - ACTION_REBOOT - Device must restart
					16 -ACTION_REFRESH -Device must refresh setup data
Motherboard	NVARCHAR(255)				Motherboard description (set by client)
FlashType	NVARCHAR(255)				Flash type (set by client)
Memorysize	INTEGER				Memory size (set by client)
CpuType	NVARCHAR(255)				CPU type (set by client)
Biosversion	NVARCHAR(255)				BIOS version (set by client)
Supplier	NVARCHAR(255)				Device supplier (set by client)
DeviceType	NVARCHAR(255)				Device type (set by client)
DefaultPrinter	NVARCHAR(255)				Name of default printer (must exist in tablePrinter for the according SetupID)
DriverNames	NVARCHAR(max)
CreationDate	INTEGER				Entry creation time stamp
VPNCiscoConfig	NVARCHAR(255)				VPN configuration (Cisco, VPNC, L2TP)
VPNClientType	INTEGER			0	VPN client to be used
					0 - No VPN client
					1 - F-Secure
					2 - FreeS/WAN
					3 - Cisco
					4 - PPTP
					5 - VPNC
					6 - L2TP
FlashSize	INTEGER			0	Flash size (set by client)
OS	NVARCHAR(255)				Operating system (set by client)
OSVersion	NVARCHAR(255)				Version of operating system (set by client)
Container	NVARCHAR(255)				Container identification (set by client)
License BuiltIn ScoutLic	SMALLINT(6)				Management license (set by Scout server)
Netmask	NVARCHAR(255)				Network mask (set by Scout server)
Domain	NVARCHAR(255)				Domain name (set by client)
NetAddr	NVARCHAR(255)				Network address (set by client)
NetAddrHome	NVARCHAR(255)				Home network address (set by server)
GroupIDHome	INTEGER			-1	Home group ID (set by server)
LastContact	INTEGER			0	Last contact time stamp
ActiveUser	NVARCHAR(255)				Last user (set by client)
LastApplicationAction	NVARCHAR(255)			#NONE	Action takes place when the last application was closed
					#NONE - Do nothing
					#RESTARTX - Logoff user
					#REBOOT - Reboot device
					#OFF - Shutdown the device
					#LOCK - Lock the device
					#VPNDISCON - Disconnect from VPN
LastApplicationActionDelay	INTEGER			0	Delay (in seconds) before LastApplicationAction is processed
Resolution	NVARCHAR(255)			1024x768	Screen resolution 640x480/800x600/1024x768/1152x864/1280x1024/1600x1200
Frequency	INTEGER			60	Screen frequency60/70/75/80/85/90/100
ColorDepth	INTEGER			16	Screen color depth8/16/24
UseDDC	SMALLINT(6)			1	Use DDC settings of this device0/1
UseParentScreenSettings	SMALLINT(6)			1	Use screen settings of the owning group0/1
UseParentMouseKBSettings	SMALLINT(6)			1	Use mouse and keyboard settings of the owning group0/1
PeerIPAddress	NVARCHAR(255)				Peer IP address (set by Scout )
UsePeerIP	SMALLINT(6)			0	Use peer IP (e.g access point with NAT) when connecting the client (instead of device IP)0/1
UseParentArray	NVARCHAR(255)			FF	Bit field indicates which property should be used from the owning group
MonitorInfo	NVARCHAR(255)				Semicolon-separated info about connected monitor info (set by client):`<Model>;<Vendor>;<Serial#>`
ApplicationsChanged	SMALLINT(6)			1	Indicates whether applications have changed and must be sent to the client 0/1
PartitionInfo	NVARCHAR(255)				Partition info (set by client)
ScreenInfo	NVARCHAR(255)				Semicolon-separated info about current screen resolution (set by client): `<Width>;<Height>;<Depth>;<HFreq[kHz]>;<VFreq[Hz]>`
VPNOptions	INTEGER			1	1 VPNOPT_AUTOCONNECT
OSLicense	NVARCHAR(255)				The license of the OS for Windows XPe or Windows CE devices
NetworkSpeed	NVARCHAR(255)				The actual network speed (set by client)
ManagementOptions	INTEGER
ContainerCompatibility	NVARCHAR(255)				Holds the comma-separated container compatibility listExample: UC_RP, UC_RL. That means the clients hardware is able to run either eluxRP or eluxRL.
CurrentMac	NVARCHAR(255)				If a client is switching to another MAC address (e.g. enabling wireless lan) this is the actual MAC address
OUCustomFilter	NVARCHAR(max)				The client is able to send a custom filter by which the scout server may decide to which OU the device should belong to.
DistributionImageFile	INTEGER				Reference to the DistributionImageFile table
TimezoneID	INTEGER				When the Scout management initiates a client relocation, this is the ID to the Relocation table
RelocationID	INTEGER				The last config snapshot ID the client has confirmed
ConfigDataID	UNIQUEIDENTIFIER				Reference to the ClientConfig table
ConfigDataIDToHave	UNIQUEIDENTIFIER				Reference to the ClientConfig table
DeliveryInfo	NVARCHAR				Stores the result values of the last delivery command
DeliveryImage	NVARCHAR(255)				Shows the last delivery image
UpdateNotificationID	INTEGER				New field to handle the ‘Image update notification’ feature (14.9)
DeliveryNotificationID	INTEGER
BiosUpdateNotificationID	INTEGER				ID of an UEFI update notification
BiosUpdateInfo	NVARCHAR(255)				UEFI update result
BiosUpdateImage	NVARCHAR(255)				UEFI file name the client sent back to the server
Note	NVARCHAR(255)
StatusModified	INTEGER		NN	0
SetupPartitionEncrypted	BIT
PortableVersion	INTEGER
ClientIdentifier	UNIQUEIDENTIFIER		NN		Unique identifier for client devices and eLux portable sticks
ClientFeatures	INTEGER		NN		0 - CLIENT_FEATURE_NONE
					1 - LIENT_FEATURE_CLIENT_IDENTIFIER
					2 - CLIENT_FEATURE_BIOS_UPDATE
TenantID	UNIQUEIDENTIFIER				Unique identifier for tenants in SPM mode (assign tenants to devices)
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
ReservedInt1	INTEGER
ReservedInt2	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	DeviceID
Mac_address	Index	MAC_address

How to create

    CREATE
    TABLE Device
    DeviceID INTEGER NOT NULL;
    WolServerID INTEGER;
    GroupID INTEGER NOT NULL;
    Name NVARCHAR(255) NOT NULL;
    UseParent SMALLINT NOT NULL;
    Info1 NVARCHAR(255);
    Info2 NVARCHAR(255);
    Info3 NVARCHAR(255);
    IP_Address NVARCHAR(15) NOT NULL;
    Mac_Address NVARCHAR(15) NOT NULL;
    Activated SMALLINT NOT NULL;
    HostID NVARCHAR(30);
    ImageFile NVARCHAR(255);
    VersionString NVARCHAR(15);
    LocalPassword NVARCHAR(255);
    EluxManager NVARCHAR(255);
    Environment NVARCHAR(255);
    SerialNumber NVARCHAR(255);
    UpdateInfo NVARCHAR(255);
    CommandInfo NVARCHAR(255);
    SetupID INTEGER;
    SetupChanged SMALLINT;
    SetupUserChanged SMALLINT;
    Status SMALLINT;
    Discovered SMALLINT;
    Action INTEGER;
    MotherBoard NVARCHAR(255);
    FlashType NVARCHAR(255);
    MemorySize INTEGER;
    CpuType NVARCHAR(255);
    BiosVersion NVARCHAR(255);
    Supplier NVARCHAR(255);
    DeviceType NVARCHAR(255);
    DefaultPrinter NVARCHAR(255);
    DriverNames NVARCHAR(max);
    CreationDate INTEGER;
    VPNCiscoConfig NVARCHAR(255);
    VPNClientType INTEGER;
    FlashSize INTEGER;
    OS NVARCHAR(255);
    OSVersion NVARCHAR(255);
    Container NVARCHAR(255);
    ScoutLic SMALLINT;
    Netmask NVARCHAR(255);
    Domain NVARCHAR(255);
    NetAddr NVARCHAR(255);
    NetAddrHome NVARCHAR(255);
    GroupIDHome INTEGER;
    LastContact INTEGER;
    ActiveUser NVARCHAR(255);
    LastApplicationAction NVARCHAR(255);
    LastApplicationActionDelay INTEGER;
    Resolution NVARCHAR(255);
    Frequency INTEGER;
    ColorDepth INTEGER;
    UseParentScreenSettings SMALLINT;
    PPTPPassword NVARCHAR(255);
    UseParentMouseKBSettings SMALLINT;
    PeerIPAddress NVARCHAR(255);
    UsePeerIP SMALLINT;
    UseParentArray NVARCHAR(255);
    MonitorInfo NVARCHAR(255);
    ApplicationsChanged SMALLINT;
    PartitionInfo NVARCHAR(255);
    ScreenInfo NVARCHAR(255);
    NetworkSpeed NVARCHAR(255);
    ManagementOptions INTEGER;
    ContainerCompatibility NVARCHAR(255);
    CurrentMac NVARCHAR(255);
    OUCustomFilter NVARCHAR(max);
    DistributionImageFileID INTEGER;
    TimeZoneID INTEGER;
    RelocationID INTEGER;
    ConfigDataID UNIQUEIDENTIFIER;
    ConfigDataIDToHave UNIQUEIDENTIFIER;
    DeliveryInfo NVARCHAR(255);
    DeliveryImage NVARCHAR(255);
    UpdateNotificationID INTEGER;
    BiosUpdateInfo __UNICON_VARCHAR__(255);
    DeliveryNotificationID INTEGER;
    BiosUpdateNotificationID INTEGER;
    BiosUpdateImage NVARCHAR(255);
    Note NVARCHAR(255);
    StatusModified INTEGER NOT NULL;
    SetupPartitionEncrypted BIT;
    PortableVersion INTEGER;
    ClientIdentifier UNIQUEIDENTIFIER NOT NULL CONSTRAINT DF_Device_ClientIdentifier DEFAULT NEWID();
    ClientFeatures INTEGER NOT NULL CONSTRAINT DF_Device_ClientFeatures DEFAULT 0;
    TenantID UNIQUEIDENTIFIER CONSTRAINT DF_Device_TenantID DEFAULT '00000000-0000-0000-0000-000000000000'
    ReservedString1 NVARCHAR(255);
    ReservedString2 NVARCHAR(255);
    ReservedInt1 INTEGER;
    ReservedInt2 INTEGER;
    CONSTRAINT FK_Device_GroupID_Groups_GroupID FOREIGN KEY (GroupID)
    REFERENCES Groups (GroupID);
    CONSTRAINT FK_Device_WolServerID_Server_ServerID FOREIGN KEY
    (WolServerID) REFERENCES Server (ServerID);
    CONSTRAINT FK_Device_RelocationID FOREIGN KEY (RelocationID) REFERENCES Relocation (RelocationID);
    CONSTRAINT FK_Device_SetupID_Setup_SetupID FOREIGN KEY (SetupID)
    REFERENCES Setup (SetupID);
    CONSTRAINT FK_Device_DistributionImageFileID FOREIGN KEY (DistributionImageFileID) REFERENCES DistributionImageFile (DistributionImageFileID);
    CONSTRAINT FK_Device_TimeZoneID FOREIGN KEY (TimeZoneID) REFERENCES TimeZone (TimeZoneID);
    CONSTRAINT FK_Device_UpdateNotificationID FOREIGN KEY (UpdateNotificationID) REFERENCES UpdateNotification (UpdateNotificationID);
    CONSTRAINT FK_Device_DeliveryNotificationID FOREIGN KEY (DeliveryNotificationID) REFERENCES UpdateNotification (UpdateNotificationID)
    CONSTRAINT UQ_Device_ClientIdentifier UNIQUE (ClientIdentifier);
    CONSTRAINT FK_Device_BiosUpdateNotificationID FOREIGN KEY (BiosUpdateNotificationID) REFERENCES UpdateNotification (UpdateNotificationID);
    PRIMARY KEY DeviceID
 

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

March 25, 2025

Contributed by:

Table: Device

How to create

In this article