Unicon documentation migration is in progress. You might find some broken links or experience minor issues in the documentation. We are working on resolving these issues.

X

Scout Database Model (CR)

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 filter2: 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));
Table: OUByNet