1. Script Outlines The Command Manager script outlines help you insert script statements with the correct syntax into your scripts. 1. PRIVILEGE_NAME: The name of the privilege, returned as a string. contact_name is the name of the recipient contact. The sample procedures are stored in the Command Manager directory, in \Outlines\Procedure_Outlines\User_Procedures\ . In MicroStrategy Command Manager 9. A list of outline categories displays on the left side of the dialog box. This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. These properties are not specified in the example script provided in Command Manager. You can avoid this security risk by saving these scripts in an encrypted format. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). 1. For more information about Command Manager, including steps to use Command Manager scripts, see the Command Manager chapter of the System. Retrieving information from ResultSet objects. 4) In MicroStrategy Developer, connect to the MicroStrategy. For more information about. ) From the Connection menu, select Execute. More architectural examples can be found here. In some scenarios, it is required to list all users with email addresses under specific user group with Command Manager script. Place the Command Manager procedure file in the specified procedure directory. Delete User Group Statement. exe" -n "MicroStrategy Tutorial Direct" -u Administrator -p 007007 -f C:startserver. By executing Command Manager scripts, external systems can trigger events and cause the associated tasks to be run. MicroStrategy Administrator - Command Manager 9. You can compose Command Manager scripts to manage user subscriptions. Command Manager makes it easy to incorporate MicroStrategy administration into any software management system. KB6392: How to execute a command manager script through a command line interface with MicroStrategy Administrator - Command Manager 9. All up to date privilege tokens are accessible in Command Manager, see Inserting Sample Statements: Outlines for more information. " For a list of the commands available in Command Manager Runtime, with syntax and examples for each command, refer to the [ System Administration Help ]. KB13380: How to create a list of Project Configuration Settings using MicroStrategy Command Manager 10. List User Group Members Statement. USER GROUP "user_group_name" is the name of the group whose security roles you want to list, of type string. Loading. MEMBER_RESULTSET: A ResultSet listing the members of the security role. Execute the command "export DISPLAY=:0. Procedures can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager statements in Java commands. x? ANSWER: The following administrative tasks can be automated using Command Manager in MicroStrategy 9. for a script with several commands, one of which being a cube publication command, the. For an introduction to Command. MicroStrategy Command Manager is a script-based tool for automating Intelligence Server administration. Its primary functions are accessed through the menu bar and toolbar. List Attributes statement. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. How to automatically trigger reports to execute after Intelligent Cubes are published or refreshed in MicroStrategy 9. In Command Manager, from the File menu, select New. Write out the ADD ATTRIBUTEFORMEXP command with the new expression, the mappingmode, lookup table and other identifiers. OWNER: The owner of the subscription, returned as a string. Create a user as shown below: CREATE USER "jaime" PASSWORD "user" FULLNAME "jaime User" IN GROUP "Web Users"; Create a DbLogin for the user created in Step 2, as shown below: CREATE DBLOGIN "dblogin_ jaime". Attribute threshold applied to wrong rows when exporting sample documents with formatting. For a list of statements available to Command Manager Runtime, see List of statements supported in Command Manager Runtime. This document shows one user procedure which could do the same task as below: The sample outline of executing this procedure is as below: EXECUTE PROCEDURE. x or 10. ResultSet Columns. The command line options for executing Command Manager scripts using the command line are included in the following table. Method. x and newer has a built in command line interface. If you create a batch file to execute a Command Manager script from the. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. The below command manager script can be used to check whether Messaging Services is enabled in Intelligence Server, and the Kafka Producer configuration can also be checked by this command. Go to the Display tab and check or uncheck the "Enable Auto-complete" option as shown in the following image: Click Ok. Select On from the drop-down. • Telemetry Manager (Zookeper) • MicroStrategy Intelligence Server Log Consumer (Kafka Consumer). (3) Your Command Manager license has expired. Security: Grant or revoke user privileges; create security filters and apply them to users or groups; change security roles and user profiles; assign or revoke ACL permissions; disconnect users. Note: The following steps assume that a network drive has been mapped on the Microsoft Windows machine that hosts MicroStrategy Narrowcast Server 9. 0 and later Command Manager can be used to retrieve a list of all users assigned with given Security Role in a given project. You can also create multiple metrics at the same time by using a Command Manager script. SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. (From the File menu, select Open . This is only visible when running Enterprise Manger Scripts on Windows. /setup. Go to the Start Menu > All Programs > Microstrategy > Command Manager. sh to the startup scripts or service definition. exe) — Enables you to execute existing Command Manager scripts using parameters in the command line mode. Editing a script. CM is being used since REST API work only in Library and can't modify Web related objects and settings. For the syntax of metric expressions in Command Manager, see Metric expressions syntax. MicroStrategy Command Manager Help. MicroStrategy Administrator - Command Manager 9. Examples include Execute SQL, Send Email, Wait, and Download Using FTP, among. For example, you can create multiple empty documents that use the same document template. This statement can only be used with three-tier or four-tier project. After altering the Database connection using the script from Command Manager in MicroStrategy 9. Dedicated Gallery with mstrio library code content modules, sample scripts, code snippets, and built-in search for easy navigation. NTLINK "new_nt_user_id" is the new Windows user name ID to be linked to the user, of type string, with format DOMAINusername. Type mstrcmdmgrw and press Enter. "You can also create an XML file to import an update package from the command line, similar to using an XML file to create an update package as described in Creating an Update Package from the Command Line. Voici d'autres exemples de tâches que vous pouvez effectuer à l'aide de Command Manager : : Ajoutez, supprimez ou modifiez des. x. Some of the symbols used in the syntax reference are not part of the syntax at all. Outline syntax; Privileges and time zones; Steps to insert an outline into a script; Steps to insert part of an outline into a script; Steps to. The time it takes to execute the script is also shown in the Messages tab. x and 10. The syntax details for each project source statement are grouped by the type of objects they affect. MicroStrategy provides a rich array of SDKs to help you customize, extend, integrate and embed the power and functionality of MicroStrategy analytics into your Web and mobile applications. In the example above, the script executes and completes successfully because it checks that the event was. LIST [ALL] PROPERTIES FOR REPORTreport_nameIN FOLDERlocation_pathFOR PROJECTproject_name; report_name is the name of the report, of type string, between double quotes (" "). LIST ALL PROPERTIES FOR INTELLIGENT CUBE CACHE GUID 1234567890ABCDEF IN PROJECT "Development Project 5"; ResultSet Columns. ” command to the normal Command Manager command. WAIT causes the script to. If you have purchased a license for Command Manager, you can use Command Manager scripts to create and manage your schedules and subscriptions. Connect to a project source or Narrowcast Server using the CONNECTMSTR or CONNECTNCS command. l ong_description is the long description of the fact, of type string, between double quotes ("). Rework the Command Manager script so that it will change the "User must change password at next login" option to FALSE, such as in the following example: ALTER USER "TestUser" PASSWORD "19eighty2" ALLOWCHANGEPWD FALSE. NUMERIC: When the answer is a number such as when trying to qualify on 2011 in the Year attribute in MicrosStrategy Tutorial project, use the following syntax: Procedures can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager statements in Java commands. Using a Command Manager script: You can also execute a Command Manager script to import an update package without using Object. Until that version, however, it was possible for users to export Command Manager results to CSV file format when executing through Windows command line. In some situations this may be more efficient than navigating the Developer GUI, since you can quickly change the names of reports, users, or projects with. TRIGGER EVENT event_name;. WORKAROUND: Follow the next steps to workaround this limitation and create prompted security filters. x from a command line interface. MEMBER_RESULTSET: A ResultSet listing the members of the security role. Command line syntax. Run and preview scripts; New features in MicroStrategy 2021 Update 2: Create scripts directly in the Workstation Script Editor. Click the Outline button. 4. For example, you can create multiple empty documents that use the same document template. Starting in MicroStrategy Command Manager, the user can take advantage of Procedures, a new concept that introduces the flexibility of using java code with regular command manager commands. For a list of statements available to Command Manager Runtime, see List of statements supported in Command. Right mouse click the grid and choose 'Export Results -> to Excel'. For the Command Manager syntax for starting and stopping Intelligence Server, see the Command Manager Help (press F1 from within Command Manager). ; Begin date: The start date in which this data load. Trending Articles. Example. FULL_NAME: The full name of the user or group, returned as a string. Outline syntax; Privileges and time zones; Steps to insert an outline into a script; Steps to insert part of an outline into a script; Steps to. This Knowledge Base article addresses a syntax issues encountered when running the Cache Update Command Manager script with prompts. The syntax is for MicroStrategy Command Manager version 8. To Execute a Script from the Command Manager Command Line InterfaceHere are more examples of tasks you can perform using Command Manager: User management: Add, remove, or modify users or user groups; list user profiles. /mstrcmdmgr -connless -f /home/mstr/MicroStrategy/test. Answer. GUID cache_guid1. In this example the file name "691031. This command will only return subscriptions where the user executing the command is the owner or recipient of the subscription. - In the Destination File, specify. ; Actions: The actions this data load will trigger. 3. Please note that the Xmx parameter is case sensitive. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. x. Afterwards you will see Kafka log files created in the Kafka installation folder: C:Program Files (x86)MicroStrategyMessaging Services mpkafka-logs. Project source statement syntax. Parameters Explained: mstrio for Python - Create Dataset. The command line options for executing Command Manager scripts using Command Manager Runtime are included in the following table. In this example, the script was created as follow: CREATE FILTER "Nested Filter" IN FOLDER "Public ObjectsFilters" EXPRESSION "" ON PROJECT "microstrategy tutorial"; 3) Execute the script. KB42309: When using MicroStrategy Command Manager script ALTER SERVER. Syntax errors occur when Command Manager encounters an instruction that it does not understand. List Report Properties statement. For detailed information. This article describes how to automatically trigger Narrowcast services using Command Manager scripts. Script Gallery tooltip with insights on how to uses classes and functions, with usage. Creating a procedure is very similar to creating a script. x . For example, you want to execute several reports immediately after a database load occurs so that these reports. Type cmd and press ENTER. • Command line interface (using CmdMgr. e. exe" -n "MicroStrategy Tutorial" -u Administrator -p 007007 -f C: estartserver. The documentation for every method includes the 8. With. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. The command prompt in console mode displays the metadata source and user to which Command Manager is connected. When running the Command Manager scripts concurrently in two clients, two folders with the same name are created under the same parent folder. Settings for an individual recipient overwrite settings at the subscription level. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. Knowing this, a user can create their own User Procedures starting from scratch or based in any Sample Procedure provided and making their own modifications. The following list describes each of them。1. x outline to alter the metric dimensionality. Using MicroStrategy Command Manager, create a script file for starting the MicroStrategy Narrowcast Server as "startserver. 3. For a complete guide to the commands and statements used in Command Manager, see the Command Manager Help. Examples. x - 10. Excel was not a supported file format for the Command Manager execution output in command line mode in MicroStrategy 9. SUMMARY: This issue has been classified as a defect by MicroStrategy. This article provides instructions on how to configure Enterprise Manager Data Loads using Command Manager scripts in MicroStrategy 10. Both examples can be found in the MicroStrategy Tutorial project in the following folder: MicroStrategy Tutorial/Schema Objects/Facts. administrators to automate nearly all administrative and maintenance tasks. The Auto-complete feature can help reduce your. With this Graphical User Interface, you can look at various examples that was provided by MicroStrategy, copy the code into your own script, and edit your own script to your heart content. exe) — Enables you to execute existing Command Manager scripts using parameters in the command line mode. LIST ALL PROPERTIES FOR USER "palcazar"; LIST ALL PROPERTIES FOR USERS IN GROUP "MicroStrategy Tutorial Managers"; ResultSet Columns. x and newer has a built in command line interface. x or 10. ACTION:This command terminates the entire Command Manager process. To include Java in a Command Manager script, you write a procedure containing the Java code, and execute the procedure from a Command Manager script. You can manage configuration settings within the MicroStrategy platform, for either project sources or Narrowcast Server metadatas. MicroStrategy makes it possible for organizations to push external data in JSON format into in-memory cubes that are on the MicroStrategy Intelligence Server to readily consume, process, and analyze the corresponding data. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. Project name: Specifies the project which data will be used. where: expression is the expression to be modified in the form, of type string, between double quotes ("). For example, you can create a procedure called NewUser that creates a user and adds the user to groups. You can then call. This command line interface is used to run command manager scripts without having to load the graphical interface and to. sh -silent -options <path of the options. 3. For more information about Command Manager, including steps to use scripts, see the Command Manager chapter of the System Administration Help. where: fact_name is the name of the fact, of type string, between double quotes (" "). . Examples include Execute SQL, Send Email, Wait, and Download Using FTP, among. Then click 'OK'. List User Privileges statement. The following steps show how to implement this functionality in MicroStrategy Command Manager: Create User Profile Folder In MicroStrategy Command Manager, using the User Profile outlines to write a script to create the user profile folder. Type mstrcmdmgrw and press Enter. Returned as an integer: 257: Custom Group. Alter User Group Statement. Introducing “mstrio” – Python and R wrappers for the MicroStrategy REST APIs. x, when using the Command Manger ADD ACE FOR FOLDER or REMOVE ACE FROM FOLDER outlines to affect ACLs in MicroStrategy Developer, the changes are not saved after an I-Server restart or purging object cache. Command line syntax. bat. Command Line. You can also create, edit, or delete multiple documents at the same time by using a Command Manager script. LIST PROPERTIES FOR SECURITY ROLE "Architect Users"; ResultSet Columns. This file is created using MicroStrategy Object Manager. By default, Command Manager scripts are saved in plain text format. List Attributes statement. In System Manager, use the Find and Replace File Content task to change the string in the Command Manager script file to the parameter value. 1. exe /?. A full list of parameters can also be accessed from a command prompt by entering cmdmgrlt. Use MicroStrategy Object Manager to migrate consistent versions of the tables (from a metadata backup or any QA/Dev environment) and replace the inconsistent tables. 1, the changes do not get applied to the reports unless the database instance is opened in Developer. MEMBER_RESULTSET: A ResultSet containing a list of group members and related details. Creating, Importing, and Deleting Users and Groups. MicroStrategy Command Manager includes a complete set of script outlines. Create User Group Statement. 3. x . Type cmdmgr . Open MicroStrategy Administrator - Command Manager and log into a 3-tier mode project source. 2) Create the second. This particular workflow is a template that is delivered out-of-the-box with System Manager. Hi @Peter Ott(Inactive) (Microstrategy, Inc. scp. A full list of parameters can also be accessed from a command prompt by entering cmdmgr. where: executable_program is the name of the executable program to be launched/run, which indicates the full path and additional parameters (if necessary), of type string, between double quotes (" "). The script file is empty. To do this, you could create a script to increase the number of low priority database. project_name is the name of the project, of type string, between double quotes ("). Exact outline that is failing. Example. Type mstrcmdmgrw and press Enter. xThe previous commands can be saved in a script that also requests the Command Manager console to be open through the command prompt. DESCRIPTION "new_user_description" is the new description of the users, of type string. Script errors: Execution errors. GUID cache_guid1. For example, you want to execute several reports immediately after a database load occurs so that these reports. Is it possible to export Command Manager results to CSV or Excel when executing scripts in Windows command line for MicroStrategy Analytics Command Manager 9. Using X11 program create a Command Manager script such as "LIST ALL USER GROUPS". x, from the Command Outline window, follow the steps below to insert a sample into the active script window: Click to select the Samples window to bring it into focus (the current window has a white background) Highlight the desired sample to be inserted. where: user_name is the name of the user contact_name is the name of the contact contact_group_name is the name of the contact group address_name is the name of the. PUBLISH INCREMENTAL REFRESH REPORT ("name" IN FOLDER "folder_name" | GUID "guid"). 71K. 4. An example of the above is as follows:. Name: The name of the object returned by the search, returned as a string. (CERATE for CREATE, for example) or a statement that does not follow the required syntax in another way. Java code, and execute the procedure from a Command Manager script. exe and press ENTER. If you're using 32-bit, please adjust accordingly. Parameters Explained: mstrio for R - Get Cube. Creating a Custom Group. Each statement ends with a semicolon (; ). location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). From the View menu, select Options. These statements are identified in the list below, and in each statement. This script can be executed or be scheduled to be executed at a certain time. Call the Command Manager executable, cmdmgr. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Related Topics. (From the File menu, select Open . Command line syntax for Command Manager Runtime. For reference on a comprehensive list of. The following is a list of the different properties of a MicroStrategy metadata object that can be listed using Command Manager 8. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. Purges the object server caching and element server caching. 81K KB18804: After executing a ’PURGE [ALL REPORT] CACHING' script in MicroStrategy Administrator Command Manager 9. For example, as part of a delivery mechanism, it may be necessary to activate statistics following duplication. x from a command line interface. Source: MicroRooster. Both can be located under the Procedures outlines folder as shown in the following image:For the Command Manager syntax for starting and stopping Intelligence Server, see the Command Manager Help (press F1 from within Command Manager). MicroStrategy recommends that you follow these best practices for configuring your upgrade test environment:. Currently this issue is being reviewed for feasibility by our Technology team for a potentical. If help information for using the command line version of System Manager is displayed, this means that System Manager is installed correctly. The output of any LIST commands is shown in the Results tab of the Script window. Platform Analytics. A list of outline categories displays on the left side of the dialog box. To create a new procedure. GRANTED indicates only privileges that are directly granted to the user. PROJECT "project_name" is the project for which you want to list the security roles for the user or group, of type string. This script does the following: Connects to MicroStrategy; Downloads all usersYou can also create an XML file to import an update package from the command line, similar to using an XML file to create an update package as described in Creating an Update Package from the Command Line. List User Properties statement. Script Gallery tooltip with insights on how to uses classes and functions, with usage. Create a new metric "Test DIM 2" in the Public ObjectsMetricsCount Metrics folder with the following definition: Count. sh script with the json request message as an argument,. 67K. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. Connect to a project source or Narrowcast Server. Select the Members tab. Using a Command Manager script: You can also execute a Command Manager script to import an update package without using Object. location_path is the folder where the attribute resides, of type string, between double quotes ("). CHECKCACHEEXISTENCE indicates to check for a given cache's existence before purging it. For example, you want to execute several reports immediately after a database load occurs so that these reports always have a. Trigger Event statement. new_desc is the new description of the attribute, of type string,. Automating Administrative Tasks with Command Manager. LONGDESCRIPTION "new_long_description" is the new long. For detailed instructions on using Java in procedures, see the Command Manager Help. When running a script via MicroStrategy Command Manager to stop MicroStrategy Intelligence Server, the users find that when re-starting MicroStrategy Intelligence Server, the schema is locked by MicroStrategy Command Manager. List of machines involved (OS types of machine) and which one is running command manager. LIST ALL DEPENDENTS FOR METRIC "New Metric" IN FOLDER "Public ObjectsMetrics" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. new_end_date is the new end date of the schedule, of type date (mm/dd/yyyy). IS_GROUP: Whether the member is a user or a group, returned as a Boolean. In windows command prompt, append“ | findstr. From MicroStrategy Web. You can also create, edit, or delete multiple documents at the same time by using a Command Manager script. - UNIX and Linux: Type mstrsysmgr and press ENTER. A blank visualization appears in the dossier. While specifying the filtering and grouping condition, please refer to the metric dimensionality symbols guide in KB7952. a Script History that saves previously executed scripts and inserts them into the. Sending request as a file by sftp to MSCT server. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager. Delete the inconsistent table objects if no other objects are depending on it. doesFieldExist (DisplayPropertyEnum iProperty) TRUE if a column for the specified PropertyID exists in the ResultSetTo modify the Web Idle Timeout, use the following script can (an abbreviated version of the above outline): ALTER SERVER CONFIGURATION WEBIDLETIME <number_of_seconds>; where <number_of_seconds> should be replaced with the new number of seconds, without any additional quotation marks or delimiters. You can deny user or group access to a specific MicroStrategy project by using a security role. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThe aim of this article is to catalog and expedite the troubleshooting process for Command Manager by ensuring that complete data makes it into our support organization before troubleshooting begins. The main Command Manager window contains the Script windows you use to edit and execute Command Manager scripts. cmdmgr -n "Project Source Name" -u Username -f "Input File" . Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. cmdmgr -n "Project Source Name" -u Username -f "Input File" . Execute the command ". If help information for using the command line version of System Manager is displayed, this means that System Manager is installed correctly. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. However, if starting Intelligence Server is not successful, the first thing that occurs is that the Update Loop Counter configuration updates a parameter for the workflow. The description of each parameter is as follows: -n Project_Source_Name: Specifies the project source name to which the application must connect to execute the script. CHECKCACHEEXISTENCE indicates to check for a given cache's existence before purging it. form_name is the name of. The Expression page is where the expression is built. The MicroStrategy REST API is a RESTful application that uses HTTP requests such as POST, GET, and DELETE. exe -help. Command Manager script files that are used to create and administer the undo package files. 4. List User Group Privileges Statement. 1? ANSWER: When executing Command Manager scripts via Command Manager GUI, users have the option to save the outputs to CSV or Excel file format. Double-click the security role you want to assign to the user or group. 4. If you try to execute a script with statements that are not available in Command Manager Runtime, the script fails with. They can be manipulated as follows: To see the actual outline statements, expand a category by clicking the + sign next to it. If you have purchased a license for Command Manager, you can use Command Manager scripts to create and manage your schedules and subscriptions. Other examples of tasks you can perform using Command Manager include: User management: Add, remove, or modify users or user groups; list. MicroStrategy Command Manager 9. Execute the command ". Creates an attribute within a project. Controlling Access to a Project. 4. It was saved as Year = 2011:. You can compose Command Manager scripts to manage user subscriptions. MEMBER_RESULTSET: A ResultSet containing a list of group members and related details. Encrypting a script. Another advantage of this feature is that if any of the Intelligent Cubes fails during the publication, this won't affect. In Microstrategy Administrator - Command Manager an administrator can move reports from one folder to another and can even re-name these reports when moving them. Lists all attributes from a given location path within a project. You can also save or execute the script. By executing Command Manager scripts, external systems can trigger events and cause the associated tasks to be run. In order to change an attribute form expression of an attribute form, use the "add attributeformexp" script with the overwrite option. Some of its features include: find and replace functionality (including regular expressions) object search for the name of the object you want to reference in a command. CAUSE. Steps to automatically complete a script command. These text-based scripts can also run from the command line and are therefore available from inside third-party applications. You can then call this procedure from another Command Manager script, supplying. PROJECT "project_name1. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). Settings for an individual recipient overwrite settings at the subscription level. Below are the syntax and examples (from Microstrategy Tutorial Project) necissary to answer Date value, Attribute qualification, Attribute element list, Text value, and Object prompts when using the 'CREATE HISTORYLISTSUBSCRIPTION' command in MicroStrategy Command Manager 9. scp":. The changes will. Outlines are preconstructed statements with optional features and user-defined parameters clearly marked. For a full list of product privileges, see Privileges by License Type. It contains the Command Manager script, which is just a series of Command Manager statements or procedure invocations. x and newer has a built in command line interface. The following can be reproduced with MicroStrategy Tutorial on a Linux machine in command line. Example. How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. EXPRESSION IN SUBSCRIPTION: An example of how to pass in expression prompt answer in a CREATE EMAILSUBSCRIPTION command using MicroStrategy Tutorial. This command terminates the entire Command Manager process. Users can. Just checked and it seems you have to omit the base path to the table.