MicroStrategy - Command Manager - General Usage

Command Manager

What should I know about Command Manager?

  1. Command Manager contains a number of outlines, and procedures. I am already somewhat familiar with the outlines. I need to see what procedures are provided by default. We can study the source code for these sample procedures.

How can our Command Manager procedure produce output that can be export to different format?

What is the purpose of the Command Manager Graphical User Interface?

You can use it to create and edit Command Manager scripts. 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. You should avoid modifying the original code just so that you always have the original version just in case you need to refer back to it.

How can we launch the Command Manager Graphical User Interface?

Start menu -> Programs -> MicroStrategy -> Command Manager -> Command Manager.

On Linux / Unix, browse to the MicroStrategy Home folder, then to the /bin subfolder. Type mstrcmdmgrw and press ENTER.

What is an outline and how can we use it?

An outline is a template, a pre-defined example that you can copy, paste, customize to create your own script. Move your mouse over each icon on the top toolbar until you find one labeled "Insert Outline". Click on this icon. Drill down on the items in the left pane. Click on the item that you are interested in on the left pane. In the bottom right pane, copy the part that you like. In the top right pane, you can customize the text. When you are done, you can click on the "Insert" button at the bottom.

How can we schedule a command manager job to run at a specific time?

You can use which ever method that your operating system support. On Unix / Linux platform, you can use cron. On Windows platform, you can use the AT command. Customize the below command:

"C:\Program Files (x86)\MicroStrategy\Command Manager\cmdmgr.exe" -n 1.DEV -u Administrator -p somepassword -f "C:\CommandManagerScripts\purgeOldUsersScript.scp" -o OutputFile.DEV -e -showoutput

into a .bat or .sh file and the use whichever method that your operating system support to schedule the job. On Windows, you can schedule a job:

Start -> All Programs -> Accessories -> System Tools -> Task Scheduler

What is in the .scp file?

The .scp file is just a text file. It contains the Command Manager script, which is just a series of Command Manager statements or procedure invocations.

How can I do a syntax check?

There is an icon in the toolbar for checking the syntax of your script or commands.

How can I change various options that Command Manager uses?

There is a button in the toolbar for that.

How can we export the result of a Command Manager command?

  1. Click on the Result tab (in the bottom pane)
  2. Right click anywhere in the bottom pane and select Export Results -> To Excel

There is also an Excel icon in the top right corner of the screen. You can use that icon for exporting the result as well.

Where is the documentation for Command Manager?

It is inside the Admin.pdf file, and the Supplemental Admin.pdf file. While using the Command Manager GUI, we can also press F1 or look for the Help menu item.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License