Scout Database Model (CR)

Table: ServerOptions

March 25, 2025

Contributed by:

Server options are stored as a combination of parameter name and value. Changes should only be done by using theScout Console.

ColumnName	DataType	Key	Not Null	Comment
ServerOptionsID	INTEGER	PK	NN	Unique ID of server option entry
ServerID	INTEGER		NN
ParamName	NVARCHAR(255)		NN	Pre-defined name of parameter
				Name / Values / Def / Description
				UseClassicLogin / 0,1 / 1 / Indicates whether classic Scout logon (administrator and guest only) or administrator policies are used
				OUFilter / 0,1,2 / 0 / Type of OU filter that is activated 0: No filter1: Subnet filter2: Custom filter
				OUFilterIgnoreDefault / 0,1 / 1 / If value is 1 all devices that have not matched filter criteria are not moved to the default OU
ParamVal	NVARCHAR(255)			Parameter depending value (see ParamName)
ParamIntVal	INTEGER

IndexName	IndexType	Columns
PRIMARY	PRIMARY	ServerOptionsID

How to create

    CREATE TABLE ServerOptions(
    ServerOptionsID INTEGER NOT NULL,
    ServerID INTEGER NOT NULL,
    ParamName NVARCHAR(255) NOT NULL,
    ParamVal NVARCHAR(255),
    ParamIntVal INTEGER,
    PRIMARY KEY (ServerOptionsID));
  

How to initialize

    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (1,1,'DebugLevel','',1);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (2,1,'Password','_]pZWIeXe',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (3,1,'AllowDynamicHostnames','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (4,1,'WOLWithIpAddress','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (5,1,'WOLWithUDP','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (6,1,'AllowDynamicGroupID','',1);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (7,1,'CheckNetCrossing','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (8,1,'ManageOnlyLockedFields','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (9,1,'RenameExistingDevice','',1);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (10,1,'DeactivateNewDevices','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (11,1,'DoSmartSrv','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (12,1,'SmartSrvTimeout','',30);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (13,1,'ScoutSrvGroup','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (14,1,'DiscoverPingTime','',20);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (15,1,'DiscoverCollectTime','',30);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (16,1,'WolServer','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (17,1,'PrinterImportTime','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (18,1,'UpdateDelay','',30);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (19,1,'UpdateCheck','',10);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (20,1,'UpdateTimeout','',360);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (21,1,'UpdateMaxAtOnce','',10);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (22,1,'UpdateMaxStartDuration','',300);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (23,1,'UpdateConnectTimeout','',2);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (24,1,'DiscoverOnStart','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (25,1,'RecoverURL','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (26,1,'RecoverProxy','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (27,1,'RecoverPort','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (28,1,'CmdHalt','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (29,1,'CmdUpdate','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (30,1,'CmdReboot','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (31,1,'CmdRestartX','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (32,1,'CmdMsg','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (33,1,'UseClassicLogin','',1);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (34,1,'MonitoringActive','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (35,1,'LastApplicationAction','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (36,1,'LastApplicationActionDelay','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (37,1,'UsePeerIP','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (38,1,'FirstContactAction','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (39,1,'MinRootPartitionSize','',128);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (40,1,'MaxRootPartitionSize','',3072);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (41,1,'SwapPartitionSize','',2);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (42,1,'RootPartitionSize','',128);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (43,1,'HomePartitionSize','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (44,1,'MinHomePartitionSize','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (45,1,'MaxHomePartitionSize','',4096);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (46,1,'RecoverAskUser','',1);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (47,1,'RecoverUsePartitionData','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (48,1,'MaxDBDataSize','',500);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (49,1,'RecoverRL','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (50,1,'RecoverRLMenu','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES
    (51,1,'SubscriptionWarning','',3);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName,
    ParamVal, ParamIntVal) VALUES (52,1,'ServerDataDir','',0);
    INSERT
    INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal,
    ParamIntVal) VALUES (53,1,'MirrorInvitationTimeout','',20);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (54,1,'DevNameTemplate','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (55,1,'OUFilter','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (56,1,'OUFilterIgnoreDefault','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (57,1,'AcceptDevices','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (58,1,'UseConfigSnapshot','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (59,1,'UseReportAdmins','',0);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (60,1,'CheckDCGPermissions','',1);
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (61,1,'SDIValidity','',300); /*Validity period of simple device identifiers*/
    INSERT INTO ServerOptions (ServerOptionsID, ServerID , ParamName, ParamVal, ParamIntVal) VALUES (62,1,'SDIInfo','',0) /*Text which can be displayed on the client when a simple device identifier is requested */
 

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

March 25, 2025

Contributed by:

Table: ServerOptions

How to create

How to initialize

In this article