Table: Relocation

If a device entry has an reference to an entry of this table, a relocation process will be initiated the next time the client boots.

ColumnName DataType Key  Not Null  Default Value Comment
RelocationID INTEGER PK NN   Unique ID
ServerID INTEGER   NN   Reference to the destination server
Options INTEGER   NN   Options for relocation
Modified DATETIME   NN   Last modification of this entry
DestinationOU NVARCHAR(255)       The destination OU to which the client should be added on the new Scout server
IndexName IndexType Columns
PRIMARY PRIMARY RelocationID

 

How to create

CREATE TABLE Relocation(
RelocationID INTEGER IDENTITY (1,1) NOT NULL,
ServerID INTEGER NOT NULL,
Options INTEGER NOT NULL,
Modified DATETIME NOT NULL,
DestinationOU NVARCHAR(255),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT PK_Relocation
PRIMARY KEY (RelocationID));