Show Connections

Shows the connections.

Permissions

Command Kind	Needed User Kind
Read	Admin, Sys

Parameters

Name	Type	Description	Required	Default	Values
Database	string	Name of the database ([Database]).	no
Find	string	Value to search for in username, UDI, database name, last datetime, client agent, client ip, server host and server port.	no
MaxRecords	integer	Maximum number of records to be returned. The default value is 500000.	no	500000

Result

Name	Type	Description
User	string	Name of the connected user.
Uid	string	Unique ID, to identify the connection which is used for subsequent commands.
Database	string	Name of the connected database.
Last	string	Last contact with the connection.
ClientUserAgentHash	string	Hash of the client user agent.
ClientIpHash	string	Hash of the client IP address.
ServerHost	string	Ip address of the server.
ServerPort	integer	Port of the server.
Sys	boolean	'True' if user is 'Sys'.
SysTech	boolean	'True' if user is 'SysTech'.
Admin	boolean	If 'True' the connected user has admin permissions.
Designer	boolean	If 'True' the connected user has designer permissions.
Import	boolean	If 'True' the connected user has the permission to import data ('Import Dimension', 'Import Table'...), independent of database permissions.
Fixed	boolean	If 'True' the connected user cannot be changed ('Sys' or 'SysTech').

Code

SHOW CONNECTIONS
DATABASE=[string]
FIND=[string]
MAXRECORDS=[integer, default=500000]