Scout Database Model (CR)

Table: LicenseMonitor

March 25, 2025

Contributed by:

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));
  

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Table: LicenseMonitor

March 25, 2025

Contributed by:

Table: LicenseMonitor

How to create

In this article