EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB9353: How to create a list of MicroStrategy users contained within a project source for export to Excel


Community Admin

• Strategy


Strategy Command Manager can be used to create a list of users within a single project source for export to Microsoft Excel. To achieve this, perform the following steps:

  • Open Strategy Command Manager and log into the appropriate Project Source and provide a user name and password for each user with access to the Command Manager.
  • From the Connections menu, click on 'Results' and choose 'To Grid'. This will output the information from the script that will be run in a grid format.
  • Select the Choose Outline icon (which resembles a white sheet of paper with a red arrow). These outlines can also be located through the File menu and selecting open script, then, open the folder labeled 'Outlines'.
  • From the Choose Outline screen, select the User_Group_Outlines folder. From this folder, select the List_User_Group_Members_Outline, as illustrated below:
ka0PW00000019AvYAI_0EM440000002J7b.png
  • Between the quotes, place the user group name 'Everyone' to retrieve a list of all of the users located within that project source accompanied by additional information for those users, as shown below:
ka0PW00000019AvYAI_0EM440000002J7W.png
  • Execute the script.
  • To export the results from grid to Excel, select the "Export result set to Excel" option, as shown below:
ka0PW00000019AvYAI_0EM440000002J7q.png

Comment

0 comments

Details

Knowledge Article

Published:

June 12, 2017

Last Updated:

March 7, 2024