List User Connections statement

Lists connections to an Intelligence Server. You can list all connections, all connections for a project, or all connections for an individual user login.

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

Copy

LIST (ALL | ACTIVE) USER CONNECTIONS [("user_login" | FROM PROJECT "project_name")];

where:

ALL indicates all user connections in the project, whether or not they are active.
ACTIVE indicates only the active user connections in the project.
USER CONNECTIONS "user_login" is the login name of the user to list connections for, of type string.
PROJECT "project_name" is the name of the project from which the user sessions are to be listed, of type string.

Example

Copy

LIST 
 ALL USER CONNECTIONS FROM PROJECT "Testing Project 1";

ResultSet Columns

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, returned as an integer:

1: MicroStrategy Developer
6: MicroStrategy Web
7: Scheduler
13: MicroStrategy Command Manager
21: Control Center
23: Office