Table: LicenseMonitor

Table for new license log in Scout 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));