MicroStrategy ONE

List User Profiles statement

Lists profiles for users.

Copy 
LIST [ALL] PROFILES FOR (USER "login_name" | USERS | USERS 
 IN (GROUPS "group_name1" 
 [, ... "groupnameN"] 
 | GROUP "group_name"])) 
 [FOR (PROJECTS "project_name1" 
 [, ... "projectnameN"] 
 | PROJECT "project_name")];

where:

  • USER "login_name" is the login name of the user whose profile is to be listed in a project, of type string.

  • USERS indicates all users.

  • USERS IN GROUPS "group_name1..N" are the names of the groups in which its user profiles are to be listed, of type string.

  • USERS IN GROUP "group_name" is the name of the group in which the user profiles are to be listed, of type string.

  • PROJECTS "project_name1..N" are the names of the projects in which the user profiles are to be listed, of type string.

  • PROJECT"project_name" is the name of the project in which the user profiles are to be listed, of type string.

Examples

Copy 
LIST PROFILES FOR USER "Developer" FOR 
 PROJECT "MicroStrategy tutorial";
Copy 
LIST PROFILES FOR USER "Developer" FOR 
 PROJECTS "MicroStrategy Tutorial", "Customer Analysis Module";
Copy 
LIST PROFILES FOR USER "Developer";
Copy 
LIST PROFILES FOR USERS;
Copy 
LIST PROFILES FOR USERS FOR PROJECTS "MicroStrategy 
 Tutorial", "Customer Analysis Module";
Copy 
LIST PROFILES FOR USERS IN GROUP "Customers";
Copy 
LIST PROFILES FOR USERS IN GROUPS "Customers", 
 "Developers" FOR PROJECTS "MicroStrategy Tutorial", 
 "Customer Analysis Module";

ResultSet Columns

LIST PROFILES FOR USER

  • USER: The name of the user, returned as a string.

  • USER_PROFILES_RESULTSET: A ResultSet containing the list of user profiles associated with the user.

    • PROFILE: The name of the user profile, returned as a string.

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

LIST PROFILES FOR USERS IN GROUP

  • MEMBER_RESULTSET: A ResultSet containing a list of users and user profiles.

    • USER: The name of the user, returned as a string.

    • USER_PROFILES_RESULTSET: A ResultSet containing information about the user profiles associated with the user.

      • PROFILE: The name of the profile.

      • PROJECT: The name of the project associated with the profile.

  • USER_GROUP: The name of the user group, returned as a string.