Table: OUByNet
Entries in this table correspond to running Scout components like Scout Server and Scout 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 |
|||
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));