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