List User Connection Properties statement

Lists the properties of a user connection to a MicroStrategy Intelligence Server.

This statement can only be used with three-tier or four-tier project source names.

Copy

LIST [ALL] PROPERTIES FOR USER CONNECTION ("login_name" | SESSIONID sessionid);

where:

USER CONNECTION "login_name" is the login name of the user for whom user connection properties are to be listed, of type string.
SESSIONID sessionid is the ID of the user connection, of type GUID.

Example

Copy

LIST ALL PROPERTIES 
 FOR USER CONNECTION SESSIONID 849C4BBC11D353F2C000159051708F4F;

CLIENT_MACHINE: The name of the client machine associated with the user connection, returned as a string.

CONNECTION_TIME: The date and time the user connection last connected, returned as a date/string.

FIRST_JOB_TIME: The date and time of the user connection's first job, returned as a date/string.

JOB_COUNT: The number of jobs associated with the user connection, returned as an integer.

LAST_JOB_TIME: The date and time of the user connection's last job, returned as a date/string.

MACHINE_NAME: The name of the machine associated with the user connection, returned as a string.

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

PROJECT: The project associated with the user connection, returned as a string.

SESSION_ID: The session ID of the user connection, returned as a string.

SOURCE_APP: The source application associated with the user connection, such as "MicroStrategy Command Manager". Returned as an integer: