MicroStrategy ONE

List User Group Members statement

Lists the users and groups that are members of the group.

Copy
LIST MEMBERS FOR USER GROUP "user_group_name";

where:

USER GROUP "user_group_name" is the name of the user group, of type string.

Example

Copy
LIST MEMBERS 
 FOR USER GROUP "Managers";

ResultSet Columns

MEMBER_RESULTSET: A ResultSet containing a list of group members and related details.

  • FULL_NAME: The full name of the member, returned as a string.

  • IS_GROUP: Whether or not the member is a user group, returned as a boolean value.

  • LOGIN: The login of the member, returned as a string.