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));