List Server Configuration Properties statement

Lists the configuration properties of Intelligence Server.

Copy

LIST [ALL] PROPERTIES FOR SERVER CONFIGURATION;

ResultSet Columns

BACKUP_FREQUENCY: Number of minutes between server backups, returned as an integer.

BALANCE_SERVER_THREADS: Whether or not server threads are balanced, returned as a boolean value.

CACHE_FILE_PATH: The location of cache files, returned as a string.

CLIENT_SERVER_PROTOCOL: The client-server protocol, such as "TCP/IP". Returned as a string.

CLUSTER_PORT: The intra-cluster port number, returned as a string.

CLUSTER_PROTOCOL: The intra-cluster protocol, returned as a string.

DESCRIPTION: The description of the server, returned as a string.

ENABLE_MEMORY_ALLOCATION: Whether or not single memory allocation governing is enabled, returned as a boolean value.

ENABLE_MEMORY_CONTRACT: Whether or not memory contract management is enabled, returned as a boolean value.

ENABLE_WEB_THROTTLING: Whether or not web request job throttling is enabled, returned as a boolean value.

HISTORY_DIRECTORY: The directory for History files, returned as a string.

HL_AUTO_DELETE_COUNT: The number of History List messages to be deleted to make space for new messages, returned as an integer.

HL_AUTO_DELETE_ERROR_MSG_FIRST: Whether or not to delete error messages from the history list before other messages, returned as a boolean.

HL_AUTO_DELETE_TIMESTAMP: Whether to delete history messages by creation time, modification time, start time, or finish time, returned as an integer:

1024: Start Time
2048: Finish Time
2097152: Creation Time
4194304: Modification Time

IDLE_TIME: The amount of idle time associated with the server, returned as an integer.

LDAP_ATTRIBUTE_GROUP: Which LDAP attribute should be used for the MicroStrategy group name, returned as a string.

LDAP_ATTRIBUTE_LOGIN: Which LDAP attribute should be used for the MicroStrategy login name, returned as a string.

LDAP_ATTRIBUTE_USERNAME: Which LDAP attribute should be used for the MicroStrategy user name, returned as a string.

LDAP_AUTHENTICATION_METHOD: Whether to use LDAP binding or password authentication, returned as an integer:

0: Binding
1: Password comparison

LDAP_AUTH_DISTINGUISHED_NAME: The distinguished name of the trusted LDAP Authentication User who searches the LDAP repository, returned as a string.

LDAP_AUTH_PASSWORD: The password for the trusted LDAP Authentication User, returned as a string.

LDAP_BATCH_IMPORT_GROUP: Whether to import LDAP groups in a batch, and whether to synchronize the MicroStrategy group name with the LDAP group name, returned as an integer:

0: Do not import
1: Import
2: Do not import
3: Import

LDAP_BATCH_IMPORT_USER: Whether to import LDAP users in a batch, and whether to synchronize the MicroStrategy user name with the LDAP user name, returned as an integer:

0: Do not import
1: Import
2: Do not import
3: Import

LDAP_BATCH_SEARCH_FILTER_FOR_GROUP: The LDAP search filter for importing groups in a batch, returned as a string.

LDAP_BATCH_SEARCH_FILTER_FOR_USER: The LDAP search filter for importing users in a batch, returned as a string.

LDAP_BATCH_SYNCHRONIZE_USER_GROUP: Whether to synchronize LDAP user/group information with other authentication information during batch import, returned as an integer:

1: User
2: Group
3: User and group
All other values: Do not synchronize

LDAP_CONNECTIVITY_FILE: The connectivity files used by the LDAP software, with multiple files separated by semicolons, returned as a string.

LDAP_IMPORT_GROUP: Whether to import LDAP groups at login, and whether to synchronize the MicroStrategy group name with the LDAP group name, returned as an integer:

0: Do not import
1: Import
2: Do not import
3: Import

LDAP_IMPORT_USER: Whether to import LDAP users at login, and whether to synchronize the MicroStrategy user name with the LDAP user name, returned as an integer:

0: Do not import
1: Import
2: Do not import
3: Import

LDAP_ISERVER_PLATFORM: The operating system that Intelligence Server is installed on, returned as an integer:

1: Windows
2: Solaris
3: AIX
4: Linux
5: HP-UX

LDAP_NT_AUTHENTICATION: Whether to synchronize MicroStrategy user and group information with LDAP during Windows authentication and import a Windows user link during batch import, returned as a boolean value.

LDAP_SECURITY_CONNECTION: The type of security connection used by the LDAP server, returned as an integer:

0: Clear text (not Encrypted)

1: SSL (encrypted)

LDAP_SERVER_CERTIFICATE: If required, the LDAP server certificate, returned as a string.

LDAP_SERVER_DRIVER: The type of LDAP server, returned as an integer:

0: Other providers
1: Novell
2: Microsoft Active Directory
3: Sun ONE/iPlanet
4: IBM
5: Open LDAP
6: HP-UX

LDAP_SERVER_NAME: The machine name or IP address of the LDAP server, returned as a string.

LDAP_SERVER_PORT: The port number used by the LDAP server, returned as an integer.

LDAP_SERVER_SEARCH_FILTER_GROUP: The server search filter for importing LDAP groups, returned as a string.

LDAP_SERVER_SEARCH_FILTER_USER: The server search filter for importing LDAP users, returned as a string.

LDAP_SERVER_SEARCH_ROOT_DN: The root Distinguished Name on the LDAP server, returned as a string.

LDAP_SERVER_VENDOR_NAME: The vendor name of the LDAP server software, returned as an integer:

0: Other providers
1: Novell
2: Microsoft Active Directory
3: Sun ONE/iPlanet
4: IBM
5: Open LDAP
6: HP-UX

LDAP_SYNCHRONIZE_USER_GROUP: Whether to synchronize LDAP user/group information with other authentication information at login, returned as an integer:

1: User
2: Group
3: User and group
All other values: Do not synchronize

LICENSE_CHECK_TIME: The time at which to check the license associated with the server, returned as a string.

MAX_ALLOCATION_SIZE: The maximum single allocation size in megabytes, returned as a double.

MAX_CONNECTION_THREADS: The maximum number of connection threads for the server, returned as an integer.

MAX_MEMORY_EXCEL: The maximum memory consumption for Excel files in megabytes (MBytes), returned as an integer.

MAX_MEMORY_PDF: The maximum memory consumption for PDF files in megabytes (MBytes), returned as an integer.

MAX_MEMORY_USAGE: The maximum memory usage for the server as a percentage. Returned as an integer.

MAX_MEMORY_XML: The maximum memory consumption for XML in megabytes (MBytes), returned as an integer.

MAX_NUMBER_OF_CLIENT_CONNECTIONS: The maximum number of client connections for the server, returned as an integer.

MAX_NUMBER_OF_JOBS: The maximum number of jobs for the server, returned as an integer.

MAX_NUMBER_OF_MESSAGES: The maximum number of messages for the server, returned as an integer.

MAX_NUMBER_OF_XML_CELLS: The maximum number of XML cells for the server, returned as an integer.

MAX_NUMBER_OF_XML_DRILL_PATHS: The maximum number of XML drill paths for the server, returned as an integer.

MAX_RAM_WORKSET: The maximum amount of RAM for the working set cache in kilobytes (KBytes), returned as an integer.

MAX_VIRTUAL_ADDRESS_SPACE: The maximum amount of virtual address space for the server as a percentage. Returned as an integer.

MEMORY_IDLE_TIME: The amount of idle time for a memory request, returned as an integer.

MESSAGE_LIFETIME: The lifetime of a message in days, returned as an integer.

MIN_FREE_MEMORY: The minimum free memory allowed as a percentage. Returned as an integer.

MIN_RESERVED_MEMORY: The minimum amount of reserved memory allowed in megabytes (MBytes), returned as a double.

MIN_RESERVED_MEMORY_PERCENTAGE: The minimum amount of reserved memory allowed as a percentage, returned as an integer.

NAME: The name of the server, returned as a string.

SCHEDULER_TIMEOUT: The timeout period for the scheduler in seconds, returned as an integer.

SERVER_DEFINITION: The definition of the server, such as "MicroStrategy Analytics Module Server". Returned as a string.

STATISTICS: The type of statistics logging, such as "Complete Session Logging". Returned as a string.

USE_MSTR_SCHEDULER: Whether or not the MicroStrategy Scheduler is enabled, returned as a boolean value.

USE_NT_PERFORMANCE_MONITOR: Whether or not the Performance Monitor is used, returned as a boolean value.

WEB_IDLE_TIME: The web idle time for the server, returned as an integer.

WORKSET_DIRECTORY: The working set file directory, returned as a string.

CONTENT_SERVER_DB_INSTANCE: The database instance GUID of content server location, returned as a string.

HL_REPOSITORY_TYPE: The history list repository type, returned as a string.

HL_ENABLE_REPORT_CACHE_BACKUP: Whether backup report history caches to database is enabled, returned as a boolean value.

HL_HYBRID_CENTRAL_INBOX_FILE_PATH: The external central storage directory for Database-based History List, returned as a string.

ENABLE_USER_AFFINITY_CLUSTER: Whether user affinity cluster is enabled, returned as a boolean value.

ENABLE_USER_AFFINITY_LOAD_BALANCING: Whether subscription load balancing is enabled, returned as a boolean value