Skip to content

Show System

Shows system infos of the server.

Permissions

Command KindNeeded User Kind
ReadAdmin, Sys, SysTech

Parameters

None

Result

NameTypeDescription
ServerVersionstringVersion of the server.
StartedstringDatetime of the server start.
DatabasesintegerNumber of loaded databases.
DatabaseVersionintegerDatabase version which the server supports.
DataServicebooleanIf 'True' the data service is active.
DataServicePortintegerPort of the data service.
DataServiceMaxThreadsPerQueryintegerQueries can be processed in parallel. This parameter shows the maximum number of threads used by a query.
WebServicebooleanIf 'True' the web service is active.
WebServicePortintegerPort of the web service.
ServerTypestringType of the http server: HttpSys or BuiltIn.
AutoDisconnectMinutesintegerMinutes after which an inactive connection is closed.
TLSbooleanIf 'True' TLS is active.
CsrfServerHeaderstringCSRF header name, which is sent by the server. It is used when the uid is returned in a cookie. For this, the 'SetCookie' parameter in the 'Connect' command must be 'True'.
CsrfClientHeaderstringCSRF header name, which must be returned by the client. It is used when the uid is returned in a cookie. For this, the 'SetCookie' parameter in the 'Connect' command must be 'True'.
LogstringActive log kinds: Connect, Error, File, Read, Request, System or Write.
LicensestringName for which the server license was issued.
MaxActiveUsersstringMaximum number of active users per database.
MinYearintegerFirst year of fixed date dimensions of the database.
MaxYearintegerLast year of fixed date dimensions of the database.
DefaultMaxRecordsintegerDefault maximum number of records to be returned. It is used when 'MaxRecords' is not set in the query.
SystemPlatformstringSystem platform: Windows or Linux.
SystemVersionstringSystem platform version.
SystemCPUsintegerNumber of system CPUs.
SystemIsContainerbooleanIf 'True' the server runs inside a container.
PrioritystringPriority of the server application: High, Above Normal, Normal, Below Normal or Low. Only available with Windows.
MemoryTotalMBnumberTotal memory of the server process (in megabytes). Only available with Windows.
MemoryUsedMBnumberUsed memory for data of the server process (in megabytes). Only available with Windows.
MemoryUnusedMBnumberUnused memory of the server process (in megabytes). Only available with Windows.
MemoryEfficiencyPercentnumberRatio of used to unused memory of the server (in percent). Only available with Windows.

Code

text
SHOW SYSTEM