Table: LicenseMonitor

Table for new license log in Scout Enterprise Console 15

ColumnName DataType Key Not Null Default Value Comment
LicenseMonitorID INTEGER IDENTITY (1,1) PK NN   Unique ID
MonitorUser NVARCHAR(255)        
MonitorTime DATETIME   NN GETUTCDATE()  
Category INTEGER   NN 0 0: no category
1: asset - license monitor entry for an action changing the license asset (e.g adding a license)
2: assignment - license monitor entry for an action changing the assignment of licenses
4: message - license monitor entry is an information message
Reason INTEGER   NN 0 Examples: ADD_DEVICE_MANUAL, ADD_DEVICE_AUTO, RELOCATE_LEAVE, RELOCATE_ENTER...
Product INTEGER   NN 0 Product ID the license monitor entry is related to
Comment NVARCHAR(255)        
CompleteCount INTEGER   NN 0 Total of licenses of this type
DiffCount INTEGER   NN 0 Difference in number
UsedCount INTEGER   NN 0 Number of used licenses
ValidDays INTEGER   NN 0 Validity period in days for temporary licenses
HostID NVARCHAR(255)   NN ' ' Host ID of added licenses
ActivationKey NVARCHAR(255)     ' ' Activation key of added licenses
LicenseKey NVARCHAR(255)   NN ' ' License key of added licenses
IndexName IndexType Columns
PRIMARY PRIMARY ScoutLicenseID

 

how to create

CREATE TABLE LicenseMonitor (
LicenseMonitorID INTEGER IDENTITY (1,1) NOT NULL,
MonitorUser NVARCHAR(255)
MonitorTime DATETIME NOT NULL DEFAULT(GETUTCDATE()),
Category INTEGER NOT NULL DEFAULT 0,
Reason INTEGER NOT NULL DEFAULT 0,
Product INTEGER NOT NULL DEFAULT 0,
Comment NVARCHAR(255),
CompleteCount INTEGER NOT NULL DEFAULT 0,
DiffCount INTEGER NOT NULL DEFAULT 0,
UsedCount INTEGER NOT NULL DEFAULT 0,
ValidDays INTEGER NOT NULL DEFAULT 0,
HostID VARCHAR(255) NOT NULL DEFAULT '',
ActivationKey VARCHAR(255) NULL DEFAULT '',
LicenseKey VARCHAR(255) NOT NULL DEFAULT '',
CONSTRAINT PK_LicenseMonitor,
PRIMARY KEY (LicenseMonitorID));