MicroStrategy ONE

Using Command Manager

With Command Manager you can change multiple configuration settings all at once as part of an automated script. For example, you can change the system to allow more low priority jobs to complete at night than during regular hours. To do this, you could create a script to increase the number of low priority database connections and modify several Intelligence Server governor settings. Then, you could schedule the script to run at 8 P.M. You could then create another script that changes the database connections and Intelligence Server settings back for daytime use, and schedule that script to run at 6 A.M.

To schedule a script to run at a certain time, use the Windows AT command with the cmdmgr executable. For the syntax for using the executable, see Executing a Command Manager Script.

Here are more examples of tasks you can perform using Command Manager:

  • User management: Add, remove, or modify users or user groups; list user profiles
  • 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 or disable their accounts
  • Server management: Start, stop, or restart Intelligence Server; configure Intelligence Server settings; cluster Intelligence Server machines; change database connections and logins; manage error codes and customize output data; disconnect active sessions on server or project
  • Database management: create, modify, and delete connections, connection mappings, logins, and database instances
  • Project management: List or kill jobs; change a project's mode (idle, resume); expire and delete caches; change filter or metric definitions; manage facts and attributes; manage folders; update the project's schema; manage shortcuts; manage hidden properties; create tables and update warehouse catalog tables
  • Scheduling: Trigger an event to run scheduled reports
  • Narrowcast Server administration: Start and stop a Narrowcast Server; start, stop, and schedule Narrowcast Server services; add, modify, and remove subscription book users; define and remove user authentication