From the View menu, select Options. Consider the following command from the command line:For purging the object cache use the IDSSSource interface. Example. The steps below show you how to create a custom group in MicroStrategy Web. 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". Lists all attributes from a given location path within a project. Execute the command ". Execution errors occur when an instruction is formed correctly but returns an unexpected result when it is executed. PASSWORD "new_user_password" is the new password for the users, of type string. - UNIX and Linux: Type mstrsysmgr and press ENTER. This command terminates the entire Command Manager process. -connlessmstr MicroStrategy Metadata MicroStrategy Metadata Connection-less -connlessncs NarrowCast Server MicroStrategy Metadata Connection-less -f Script input filefMicroStrategy. For example, the user could type UNR and press CTRL+SPACE to fill in the rest of UNREGISTER without having to type the complete word. MicroStrategy Command Manager is a scripting tool that allows. You can compose Command Manager scripts to manage user subscriptions. Note: For more information on executing a workflow in. For more information about. These reports are located in the project under: Public Objects > Reports > Project Analysis > Object Usage Analysis > Command Manager Reporting. In Command Manager, procedures are reusable scripts that can be executed from other scripts. Call the Command Manager executable, cmdmgr. Example: Open Command Manager. If -p is omitted, Command Manager Runtime assumes a null. Command Manager manipulates MicroStrategy objects by means of user-created scripts rather than a graphical user interface. DBINSTANCE "dbinstance_name" is the name of an existing database instance (role) that will be used. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. x. For more information about Command Manager, including steps to use scripts, see the Command Manager chapter of the System Administration Help. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). You can reuse procedures with different input values, so that the procedure performs the same task in a slightly different way. Creating, Importing, and Deleting Users and Groups. Editing a script. You can retrieve subscriptions by filtering for Object Type = Subscriptions/Schedule. Go to the Display tab and check or uncheck the "Enable Auto-complete" option as shown in the following image: Click Ok. These procedures are briefly described below. where: USER "user_ name" is the login name of an existing user to whom the connection map is to apply, of type string. 2. To Start the Command Manager Graphical Interface. "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. With the workflow shown above, if Intelligence Server starts successfully the first time, the Command Manager script is executed next and the loop is not needed. Java code, and execute the procedure from a Command Manager script. 2. scp". sh -silent -options <path of the options. For late-breaking updates to. This statement can only be used with three-tier or four. How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. Despite the fact that the Supplemental Reference for System Administration Guide provides an example of this script being used, use of 'NTLINK' is redundant when using 'IMPORTWINUSER'. In MicroStrategy Command Manager 9. SESSION_ID: The session ID of the user connection, returned as a string. So this will work: CREATE FACT "TestFact" IN FOLDER "Schema ObjectsFactsBulkFactTest" EXPRESSION "StuffCount" EXPSOURCETABLES "TableName" FOR PROJECT. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. A list of outline categories displays on the left side of the dialog box. For information on deploying a workflow from the command line or as a silent process, see Deploying a Workflow. Check the outline-example for "Create Fact" of the CommandManager (always helpful). Each statement ends with a semicolon (; ). Click the Outline button. For a list of statements available to Command Manager Runtime, see List of statements supported in Command. Controlling Access to a Project. It is possible to create users individually using the User Manager interface in Developer, or using Command Manager (for a detailed explanation of how to use Command Manager, including examples, see Automating Administrative Tasks with Command Manager). For details on this process, refer to the. For example, you want to execute several reports immediately after a database load occurs so that these reports always have a. x Number of Views 2. x that will trigger a number of services to execute sequentially: Open MicroStrategy Command Manager. Purges the object server caching and element server caching. MEMBER_RESULTSET: A ResultSet containing a list of group members and related details. SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. cmdshell. x. MicroStrategy Developer と MicroStrategy Command Manager は、同じコンピューター上、または異なるコンピューター上にインストール. MicroStrategy Command Manager can trigger events from the Windows command line. 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. RUN COMMAND executable_program [WAIT];. In MicroStrategy Command Manager go to the Tools menu and select Options. This statement can only be executed in a Windows. txt file. It contains the Command Manager script, which is just a series of Command Manager statements or procedure invocations. MicroStrategy. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. They can be manipulated as follows: To see the actual outline statements, expand a category by clicking the + sign next to it. x. You can also create, edit, or delete multiple metrics at the same time by using a Command Manager script. project_name is the name of the project, of type string, between double quotes ("). 4. For example, the Visual Basic 6 code is similar to the following: Public ObjSource as IDSSSource Set ObjSource = objSession. Click the desired topic below to view more details, or scroll down to view each of the following topics: The menu bar. The MicroStrategy REST API is a RESTful application that uses HTTP requests such as POST, GET, and DELETE. Administrators no longer need to install Narrowcast Server on the machine where Command Manager. You can reuse procedures with different input values, so that the procedure performs the same task in a slightly different way. The documentation for every method includes the 8. INHERITED indicates only privileges that the user inherits from groups or security roles. " 2. This script can be executed or be scheduled to be executed at a certain time. Number of Views 884. The steps below show you how to create a custom group in MicroStrategy Web. For more information about Command Manager logging, see Using log files. It is the most basic, simple, and therefore, the most massive way to use command Manager. Enterprise Manager or Narrowcast script?. 4. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. Type. numbers in any notation dates object GUIDs other special characters such as carriage returns, tabs, or spacesThe Command Manager command line interface opens, in console mode, with an active connection-less project source connection. This Knowledge Base article addresses a syntax issues encountered when running the Cache Update Command Manager script with prompts. ' This issue does not occur if changes in thread priorities are made via the MicroStrategy Desktop interface. These text-based scripts can also run from the command line and are therefore available from inside third-party applications. For LIST statements, the last section contains information about the ResultSet returned when the statement is used in a Java procedure. Symbols, such as ;^ , ' ". It is using mstrio Python library and Command Manager scripts. ) From the Connection menu, select Execute. Example. Command Manager script files that are used to create and administer the undo package files. This article provides steps to modify the Project Configuration settings through a MicroStrategy Sample Procedure in Command Manager. To see a list of instructions for the command line. LONGDESCRIPTION "new_long_description" is the new long. As a MicroStrategy system administrator, you may be responsible for managing MicroStrategy Web and Mobile environments. scp" -o "RefreshService. These outlines facilitate the script development by providing the command syntax for the instructions submitted to the script executor for object manipulation. new_attr_name is the new name of the attribute, of type string, between double quotes ("). PROJECT: The project associated with the user connection, returned as a string. Trending Articles. Some of the symbols used in the syntax reference are not part of the syntax at all. For detailed instructions on using Java in procedures, see the Command Manager Help. List User Group Properties Statement. This particular workflow is a template that is delivered out-of-the-box with System Manager. e. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. Notice this sample is based on the MicroStrategy Tutorial Project. By default, this is C:Program FilesMicroStrategyCommand ManagerCommand Manager. Command Manager facilite l'intégration de l'administration MicroStrategy dans n'importe quel système de gestion. x or 10. USER GROUP "user_group_name" is the name of the user group that contains the users to be altered, of type string. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. For example, to create profile folder for user with ID `bkelt` in. If help information for using the command line version of System Manager is displayed, this means that System Manager is installed correctly. ” command to the normal Command Manager command. exe) — Enables you to execute existing Command Manager scripts using parameters in the command line mode. PROJECT "project_name" is the name of the project in which the security filter is to be created, of type string. This is done through the Connect Source outline in Command Manager: CONNECT SOURCE "<project_source_name>" USER "<user_name>" [PASSWORD "<password> "]; Executing the script file through the command line execution of Command Manager appears like this:. The following can be reproduced with MicroStrategy Tutorial on a Linux machine in command line. MicroStrategy Administrator - Object Manager is the component in the MicroStrategy Product Suite that allows system administrators to conduct project life-cycle management. Using X11 program create a Command Manager script such as "LIST ALL USER GROUPS". This statement can only be executed in a Windows. The following list describes each of them。1. This command will only return subscriptions where the user executing the command is the owner or recipient of the subscription. USER GROUP "user_group_name" is the name of the group whose security roles you want to list, of type string. Project name: Specifies the project which data will be used. For example, you can create a subscription to send multiple recipients a report via email but specify that one member of the subscription receive the information as a link. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Microstrategy Command Manager script to alter Email transmitter causes malformed XML exception in Date Server. Click on the "Log" tab. Assuming that the statistics tables have already been created in the. 1. Select On from the drop-down. Returned as an integer: 257: Custom Group. For example, the script may have tried to write to a read-only file, or read from a file that does not exist. 512: Template. Create a new metric "Test DIM 2" in the Public ObjectsMetricsCount Metrics folder with the following definition: Count. The device is based on a transmitter in the system. From the Select a Project drop-down list, select the project for which to assign the security role. address. This article provides instructions on how to configure Enterprise Manager Data Loads using Command Manager scripts in MicroStrategy 10. contact_name is the name of the recipient contact. 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. The Procedure window is used in much the same way as the standard Script window. Runs an executable program. where: fact_name is the name of the fact, of type string, between double quotes (" "). When running a command to list cube caches for the current metadata connection in Command Manager 10. MicroStrategy Configuration Wizard – mstrcfgwiz. List User Properties statement. 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. x from a command line interface. The Security Role Editor opens. In Windows: From the Windows Start menu, go to All Programs > MicroStrategy Tools > Command Manager. where: subscription_name is the name of the subscription. Click the desired topic below to view more details, or scroll down to view each of the following topics: The menu bar. /mstrcmdmgr -connless -f /home/mstr/MicroStrategy/test. In this example the file name "691031. ResultSet Columns. N are the GUIDs of the report caches to be deleted, of type GUID. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. This requires a cron job to be scheduled to run the MSCT cron script, which checks the message receipt folder frequently. exe -help. 4. (6) The. Command line syntax. Migration Package using MicroStrategy Object Manager. KB442655: Default value changed for "Separate Count Distinct" VLDB setting for Impala 2. MicroStrategy Administrator - Command Manager 9. At the end of the database load routine, you include a statement to add a line to a database table, DB_LOAD_COMPLETE, that indicates that the database load is complete. 1. location_path is the folder where the attribute resides, of type string, between double quotes ("). Comments display as green. Just checked and it seems you have to omit the base path to the table. Execute a Microstrategy Command Manager script through a command line interface. 3. Examples include Execute SQL, Send Email, Wait, and Download Using FTP, among. List all properties for a specific subscription. LIST [ALL] PROPERTIES FOR REPORTreport_nameIN FOLDERlocation_pathFOR PROJECTproject_name; report_name is the name of the report, of type string, between double quotes (" "). Please contact MicroStrategy Technical Support for further assistance on the issue. This can be done by choosing the 'Save as Encrypted Script' option from the File menu, as shown: The user is then prompted to enter a password after selecting the location of the script file and the save button, as shownSeptember 18, 2018 Command Manager Scripts in Microstrategy to create a user and add to a group CREATE USER "LDAPID" FULLNAME "FirstName LastName" NTLINK "DOMAINLDAPID" PASSWORD "123456" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD FALSE PASSWORDEXP NEVER; ADD USER. subscription_GUID is the ID of the subscription. In Command Manager, from the File menu, select New. 5. This server should previously be added to Enterprise Manager using the Start Monitoring command. (2) The command line parameters could not be parsed. For example, you want to execute several reports immediately after a database load occurs so that these reports. x and 10. You can also import users. SYMPTOM: In MicroStrategy Command Manager 10. You can then call. This document introduced How to establish a "connectionless" session in MicroStrategy Command Manager 9. 1, the changes do not get applied to the reports unless the database instance is opened in Developer. The steps below show you how to deploy a workflow from within System Manager. Information if the script that is falling come from the outline list or this is new created script. CONTENT: The content of the subscription, returned as a string. To do this, you could create a script to increase the number of low priority database. The Command Manager script engine uses a unique syntax that is similar to SQL and other such scripting languages. Script errors: Execution errors. This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. CM is being used since REST API work only in Library and can't modify Web related objects and settings. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. To include Java in a Command Manager script, you write a procedure containing the. Double-click on MicroStrategy Intelligence. 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. From the Windows Start menu, choose Run. In the example above, the script executes and completes successfully because it checks that the event was. 4. x? ANSWER: The following administrative tasks can be automated using Command Manager in MicroStrategy 9. Creating a Custom Group. FULL_NAME: The full name of the member, returned as a string. MicroStrategy provides a library of functions with examples that we can use to create our own scripts by clicking on the button: In some scenarios, it is required to list all users with email addresses under specific user group with Command Manager script. If the MCST application is to be used with an enterprise scheduler or workflow agent, configure the agent to run the mstr_cube_trigger. Until that version, however, it was possible for users to export Command Manager results to CSV file format when executing through Windows command line. To reproduce the issue with MicroStrategy Tutorial, an Administrative user can run the following MicroStrategy Command Manager 8. Example. Procedures are only available for use with project sources. ; Actions: The actions this data load will trigger. A Command Manager script consists of one or more script statements. Using a Command Manager script: You can also execute a Command Manager script to import an update package without using Object. Administrators no longer need to install Narrowcast Server on the machine where Command Manager. The following topics contain syntax details and example script statements for each object. USER "login_name" is the name of the user whose security roles you want to list, of type string. 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 Auto-complete feature can help reduce your. For a more general introduction to MicroStrategy Command Manager, see Automating Administrative Tasks with Command Manager. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. 71K. Click the links below for syntax details for each type of metric expression: Simple. STEPS TO. (5) Command Manager was unable to establish a connection to Narrowcast Server. Source: MicroRooster. The Command Manager script engine uses a unique syntax that is similar to SQL and other such scripting languages. sh to the startup scripts or service definition. For example, you can edit all custom groups to use a different attribute element. A token is a word, a list of words enclosed in quotation marks, or a symbol. Insert a package outline to create an Undo package using following syntax as example: Click Insert Visualization . It is using mstrio Python library and Command Manager scripts. NOTE: Parameters enclosed in brackets '' are optional. Entering a Command Manager script instruction switches Command Manager into edit mode. This is done through the Connect Source outline in Command Manager: CONNECT SOURCE "<project_source_name>" USER "<user_name>" [PASSWORD "<password> "]; Executing the script file through the command line execution of Command Manager appears like this:. x the script ADD WHTABLE and UPDATE STRUCTURE FOR WHTABLE fails to find a table specified when using multisource functionality and the table does not exist in all the databases being used. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. form_name is the name of. To invoke Command Manager from the database server, use one of the following. To Access Fact Expressions For a New Fact with an Expression. For more information about. By executing Command Manager scripts, external systems can trigger events and cause the associated tasks to be run. Exact outline that is failing. " This syntax reference guide lists the statements available for Command Manager Runtime and gives the syntax and examples for each statement. Beginning with MicroStrategy 9. 4. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. The Expression page is where the expression is built. For example, the script may have tried to write to a read-only file, or read from a file that does not exist. The output of any LIST commands is shown in the Results tab of the Script window. Place the Command Manager procedure file in the specified procedure directory. Dedicated Gallery with mstrio library code content modules, sample scripts, code snippets, and built-in search for easy navigation. FULL_NAME: The full name of the member, returned as a string. PRIVILEGE_NAME: The name of the privilege, returned as a string. To incorporate the results of a Command Manager statement into a procedure, use the ExecuteCapture command. STEPS TO REPRODUCE: 1. EXPRESSION IN SUBSCRIPTION: An example of how to pass in expression prompt answer in a CREATE EMAILSUBSCRIPTION command using MicroStrategy Tutorial. x and newer has a built in command line interface. Program FilesMicroStrategyAdministratorCommand ManagerScript. Consider an example of Regional Sales Reports Regional Manager East • Region = East. GUID cache_guid1. new_attr_name is the new name of the attribute, of type string, between double quotes ("). MicroStrategy Command Manager provides the ability to create text-based scripts and automate common administrative functionality. FILTER "filter_name" is the name of the filter to provide the. Dedicated Gallery with mstrio library code content modules, sample scripts, code snippets, and built-in search for easy navigation. The following can be reproduced with MicroStrategy Tutorial on a Linux machine in command line. Settings for an individual recipient overwrite settings at the subscription level. In order to achieve so, Command Manager procedure has been provided as a sample. 4. A blank visualization appears in the dossier. IS_GROUP: Whether the member is a user or a group, returned as a Boolean. where: expression is the expression to be modified in the form, of type string, between double quotes ("). Go to the Start Menu > All Programs > Microstrategy > Command Manager. Execution errors occur when an instruction is formed correctly but returns an unexpected result when it is executed. Sure, currently just exploring the mstrio. Add, remove, or modify users or user groups. MicroStrategy Command Manager 9. new_end_date is the new end date of the schedule, of type date (mm/dd/yyyy). 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). KB233716: How to pass a System Manager parameter value into a Command Manager script or procedure. Open the script. location_path is the folder where the attribute resides, of type string, between double quotes ("). Schema objects, the building blocks of business intelligence and application objects that generate useful analytical information, can be transferred within or between. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. LONGDESCRIPTION "new_long_description" is the new long. Sometimes, administrators may require that the execution of a subsequent script be delayed for a certain amount of time. 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". The process to grant privileges using MicroStrategy Command Manager is: Open MicroStrategy Command Manager and connect to the appropriate metadata. xConsider the following example: A user would like to create a schedule that will execute daily at 7:00 P. List Attributes statement. When this command is executed, Command Manager waits for the report to finish executing before continuing to the next statement in the script. RUN COMMAND executable_program [WAIT];. Other examples of tasks you can perform using Command Manager include: User management: Add, remove, or modify users or user groups; list. scp Encrypted Script Files Which administrative tasks can be automated with Command Manager using out-of-the-box scripts in MicroStrategy 9. Procedures are reusable scripts that can be executed from other scripts. Method. You can deny user or group access to a specific MicroStrategy project by using a security role. desc is the description of the attribute, of type string, between double quotes ("). If you are using UNIX, you must use Command Manager to manage your system's security roles. List User Privileges statement. As of MicroStrategy 9. The user has the option to send all logs to one single file. To include Java in a Command Manager script, you write a procedure containing the. The following procedure describes how to write a script for MicroStrategy Command Manager 9. executeCapture runs any Command Manager command and returns the results (if the. log Note: the “KeyWord” should be set in the. • Command line interface (using CmdMgr. 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. . By default, this executable is located in C:Program FilesMicroStrategyCommand Manager. 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. ) ,. txt -o c:mstroutput. Example. With introduction of Library there is a need to synchronize user language preferences between Web and Library interfaces. 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. • Command line interface (using CmdMgr. Users can. • System Tools—These processes enable you to perform tasks external to MicroStrategy. You can avoid this security risk by saving these scripts in an encrypted format. The main Command Manager window contains the Script windows you use to edit and execute Command Manager scripts. These commands can be compiled into script files and run from a graphical interface or from the command line. 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. Add User Group Statement. MicroStrategy System Administration Guide. For example, if an administrative user changes the project level setting 'Report execution time (sec)' through MicroStrategy Desktop and clicks `OK`, the change will take effect without restarting MicroStrategy Intelligence Server since it is a runtime setting. 3. NAME: The name of the subscription, returned as a string. To invoke Command Manager from the database server, use one of the following. 04K. 0, Command. txt file>. The command line options for executing Command Manager scripts using the command line are included in the following table. Click tab 'Display' and select 'Results to grid' in the dropdown list. Execution: Choose whether the Command Manager statements to run are in a script file or the ones that you enter here: Script File (. It contains the Command Manager script, which is just a series of Command Manager statements or procedure invocations. Create the user using two Command Manager scripts instead of one. - In the Source File, specify the location of the original Command Manager script file. When running the Command Manager scripts concurrently in two clients, two folders with the same name are created under the same parent folder. This statement can only be used with three-tier or four. Script Gallery tooltip with insights on how to uses classes and functions, with usage. MicroStrategy System Administration Guide. 1 Hotfix 3. 4. x or 10. The sample code could be as below where the ResultsFile that follows. In the menu, go to 'Tools -> Options'. The main Command Manager window contains the Script windows you use to edit and execute Command Manager scripts. LIST ALL PROPERTIES FOR SERVER CONFIGURATION; By default this settings it TRUE. In the Log file path field, type the path of a log file, or use the folder (browse) icon to browse to a log file. When executing Command Manager scripts via Command Manager GUI, users have option to save the outputs to CSV or Excel file format. From the Visualizations panel, select Grid . OR. 2. To invoke Command Manager from the database server, use one of the following commands: SQL Server: exec xp. 3. lookup_table is the name of the lookup table to be used in the form, of type string, between double quotes ("). 4. First script creates the basic user. . For example, the script may have tried to write to a read-only file, or read from a file that does not exist. USER GROUP "user_group_name" is the name of the group whose security roles you want to list, of type string. PROJECT "project_name" is the project for which you want to list the security roles for the user or group, of type string. It was saved as Year = 2011:. Type the command of <script> CHECK to check if the syntax is correct. They can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager. Below is a sample: cmdmgr. 5. In MicroStrategy Command Manager 9. LIST ALL REPORTS FOR PROJECT "MicroStrategy Tutorial"; LIST ALL REPORTS IN FOLDER "Public ObjectsReports" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. NAME "new_login_name" is the new login name of the user, of type string. This command line interface is used to run command manager scripts without having to load the graphical interface and to. Type the command of <script> EXEC to execute the script. When running these five newly created stored procedures, via ISQL (Command Line utility for SQL Server commands), there will be three MicroStrategy Administrator - Command Manager scripts that will later be executed via command line. 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.