Table: ViewLicenseUsage

This is a view data table which is used by Scout Enterprise Dashboard. The table is filled automatically. It is highly recommended not to change any entry.

ColumnName	DataType	Key	Not Null	Default Value	Comment
ViewLicenseUsageID	INTEGER IDENTITY (1,1)	PK	NN
Name	NVARCHAR(255)		NN
Type	INTEGER		NN
Used	INTEGER		NN
Available	INTEGER		NN
Without	INTEGER		NN
Modified	DATETIME		NN

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ViewLicenseUsageID

 

How to create

CREATE TABLE ViewLicenseUsage(
ViewLicenseUsageId INTEGER IDENTITY (1,1) NOT NULL,
Name NVARCHAR(255) NOT NULL,
Type INTEGER NOT NULL, Used INTEGER NOT NULL,
Available INTEGER NOT NULL,
Without INTEGER NOT NULL,
Modified DATETIME NOT NULL,
CONSTRAINT PK_ViewLicenseUsage
PRIMARY KEY (ViewLicenseUsageId));