Table: Entity

The 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 DefaultValue Comment
EntityID INTEGER PK NN   Unique ID of entity entry
Type INTEGER       Entity type
0Scout Enterprise Server 
1Scout Enterprise Console 
 
Version NVARCHAR(255)       Entity version
IPAddress NVARCHAR(255)        
StartTime INTEGER        
HostID NVARCHAR(64)        
Username NVARCHAR(255)        
Features INTEGER        
Mode INTEGER        
HeartBeat INTEGER        
Status INTEGER        
Threshold1 INTEGER        
Threshold2 INTEGER     90  
Threshold3 INTEGER        
Threshold4 INTEGER        
DatabaseConnections INTEGER        
IPName NVARCHAR(255)        
ReservedString1 NVARCHAR(255)        
ReservedString2 NVARCHAR(255)        
ReservedInt1 INTEGER        
ReservedInt2 INTEGER        
IccInstanceID INTEGER        
LogFileName NVARCHAR(255)       Name of log file used by an entity
IndexName IndexType Columns
PRIMARY PRIMARY EntityID

 

how to create

CREATE TABLE Entity(
EntityID INTEGER NOT NULL,
Type INTEGER NOT NULL,
Version NVARCHAR(255),
IPAddress NVARCHAR(255),
StartTime INTEGER,
HostID NVARCHAR(64),
Username NVARCHAR(255),
Features INTEGER,
Mode INTEGER,
HeartBeat INTEGER,
Status INTEGER,
Threshold1 INTEGER,
Threshold2 INTEGER,
Threshold3 INTEGER,
Threshold4 INTEGER,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
IccInstanceID INTEGER,
IPName NVARCHAR(255),
DatabaseConnections INTEGER,
LogFileName NVARCHAR(255),
PRIMARY KEY (EntityID));