Table: OUByNet

Entries in this table correspond to running Scout Enterprise components like Scout Enterprise server and console. Since the entries are created and removed dynamically, it is not recommended to change them.

ColumnName	DataType	Key	Not Null	Default Value	Comment
OUByNetID	INTEGER	PK	NN		Unique ID
FilterType	INTEGER				Type of filter. 1: Subnet filter 2: Custom filter
SubnetAddr	NVARCHAR(255)				Subnet address if FilterType = 1
CustomFilter	NVARCHAR(max)				Custom filter string if FilterType i= 2
OUID	INTEGER				ID of the OU to which devices within the subnet address should be assigned
OrderNumber	INTEGER				Order number for processing the rules
ReservedString1	NVARCHAR(255)
ReservedString2	NVARCHAR(255)
INTEGER	INTEGER
ReservedInt2	INTEGER
Active	BIT		NN	1

IndexName	IndexType	Columns
PRIMARY	PRIMARY	OUByNetID

 

How to create

CREATE TABLE OUByNet(
OUByNetID INTEGER NOT NULL,
FilterType INTEGER,
SubnetAddr NVARCHAR(255),
CustomFilter NVARCHAR(max),
OUID INTEGER,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
Active BIT NOT NULL,
PRIMARY KEY (OUByNetID));