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

KB486769: How to use the Script Gallery for Streamlined Administration Workflows in MicroStrategy WorkStation


Rainiero Leon

Support Engineer • MicroStrategy


This article delineates the process of utilizing the Script Gallery in MicroStrategy WorkStation to streamline your administration workflows. By using the prebuilt Python scripts available in the Script Gallery, you can efficiently manage various administrative tasks such as adding emails to new users, deleting inactive cube caches, delete addresses from departed users, list active user privileges, list empty user groups, list security roles per user, and more.

Symptom

As a specific Strategy environment evolves, it becomes imperative to implement administration workflows to maintain optimal performance. Regular purging of obsolete elements, which accumulate over time, is essential to prevent potential slowdowns and ensure the system's efficiency.
 

Cause

The system naturally accumulates inactive and unused elements over time, including dormant accounts and inactive caches. These can potentially lead to inefficiencies within the system, necessitating regular maintenance to prevent slowdowns and optimize performance.
 

Solution

1. Connect to Your Environment: Initialize the connection to your Strategy environment.
2. Navigate to Administration: Access the administration panel to manage scripts and workflows.
3. Access Scripts Section: Go to the scripts section where you can create or modify scripts.
4. Select Your Environment: Choose the appropriate environment where the script will be executed.
5. Open Gallery Tab: In the right section of the interface, select the Gallery tab to view available workflows and scripts.
6. Expand Administration Workflows: Find and expand the Administration Workflows section to access various administrative scripts.
7. Launch and 'Administration Workflow' Script: Double-click on a script from the following list to open and view its details:
•    Add email to new users.
•    Delete addresses from departed users.
•    Delete inactive cube caches.
•    Delete subscriptions of departed users
•    List active user privileges
•    List empty user groups
•    List security roles per user
8. Execute the Script: Hit the run button to execute the selected script.
9. Script Review and Customization: Before finalizing, review the script to comprehend its structure and functionalities. Customize specific parameters if necessary to align with your administrative goals.

ka0PW0000002CLFYA2_0EMPW000006YvBk.jpeg

Note

The scripts in the Script Gallery utilize the ‘mstrio-py’ package, which is a Python client designed for easy interaction with the Strategy REST API. It facilitates various operations, including connection management and project object manipulation. You can find more information about this package on the Strategy GitHub repository https://github.com/MicroStrategy/mstrio-py.
 

Related articles

Python within Workstation https://www2.Strategy.com/producthelp/Current/Workstation/en-us/Content/intro_scripts.htm 
Preview Python Scripts https://www2.Strategy.com/producthelp/Current/Workstation/en-us/Content/preview_scripts.htm
mstrio-py https://github.com/MicroStrategy/mstrio-py 
https://www2.Strategy.com/producthelp/Current/Workstation/en-us/Content/intro_scripts.htm 
Customization Warning:
This customization is provided as a convenience to Strategy users and is only directly applicable to the version stated. While this code may apply to other releases directly, Strategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. In the event of a code change in future builds, Strategy Technical Support makes no guarantee that an updated version of this particular customization will be provided. For enhancements to this customization or to incorporate similar functionality into other versions, contact your Account Executive to inquire about Strategy Consulting assistance.


Comment

0 comments

Details

Knowledge Article

Published:

June 10, 2024

Last Updated:

June 10, 2024