Scout Database Model (CR)

Table: MaintenanceWindow

March 25, 2025

Contributed by:

Holds the data for command preferences (for standard commands).

ColumnName	DataType	Key	Not Null	Comment
MaintenanceWindowID	INTEGER IDENTITY(1,1)	PK	NN	Unique maintenance window ID
From	DATETIME		NN	Start time of maintenance window
To	DATETIME		NN	End time of maintenance window
Repeat	BIT		NN	Is maintenance window repeating?
RepeatType	INTEGER		NN	Repeating period
				0 REPEAT_DAILY
				1 REPEAT_WEEKLY
				2 REPEAT_MONTHLY
				3 REPEAT_MONTHLY_FIRST_WEEKDAY
				4 REPEAT_MONTHLY_SECOND_WEEKDAY
				5 REPEAT_MONTHLY_THIRD_WEEKDAY
				6 REPEAT_MONTHLY_FOURTH_WEEKDAY
				7 REPEAT_MONTHLY_LAST_WEEKDAY
Name	NVARCHAR(255)			Name of maintenance window
Administrator	NVARCHAR(255)			Name of administrator who has defined the maintenance window
Modified	DATETIME		NN	Last modification of maintenance window

IndexName	IndexType	Columns
PRIMARY	PRIMARY	MaintenanceWindowID

How to create

    CREATE TABLE MaintenanceWindow(
    MaintenanceWindowID __UNICON_AUTOINCREMENT__ NOT NULL,
    [From] DATETIME not null,
    [To] DATETIME not null,
    [Repeat] BIT not null,
    RepeatType INTEGER not null,
    [Name] NVARCHAR(255),
    Administrator NVARCHAR(255),
    Modified DATETIME not null,
    CONSTRAINT PK_MaintenanceWindow
    PRIMARY KEY (MaintenanceWindowID));
 

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: MaintenanceWindow

March 25, 2025

Contributed by:

Table: MaintenanceWindow

How to create

In this article