KB429093: Is it possible to export Command Manager results to CSV or Excel when executing script in Windows command line for MicroStrategy Command Manager 9.4.1?

Question

When executing Command Manager scripts via Command Manager GUI, users have option to save the outputs to CSV or Excel file format. But is it possible to export Command Manager results to CSV or Excel when executing script via Windows command line?

Answer

Excel was not a supported file format for the Command Manager execution output in command line mode in Strategy 9.4.x. Until that version, however, it was possible for users to export Command Manager results to CSV file format when executing through Windows command line.
The sample code could be as below where the ResultsFile that follows "or" parameter is a file in .CSV format.

cmdmgr -n "Strategy Analytics Modules" -u "UserName" -p "Password" -f "ScriptName.scp" -or "ResultsFile.csv"

Starting with Strategy 9.5, Excel is also a supported file format

KB429093