Command Manager Reference
MicroStrategy Command Manager
MicroStrategy Command Manager automates maintenance and other administrative operations using simple text-based commands. These commands can be compiled into script files and run from a graphical interface or from the command line. The script files can be scheduled through operating system utilities or integrated into third-party Systems Management Software, automating repetitive maintenance tasks.
Command Manager minimizes administrative costs by automating critical, time-consuming administrative tasks, such as managing users and security, purging caches, and expiring jobs. Command Manager contains over 200 commands that automate administrative tasks. Command Manager makes it easy to incorporate MicroStrategy administration into any software management system.
Command Manager Reference
ACL Statements
Add Configuration Object ACE Statement
Add Folder ACE Statement
Add Group ACE Statement
Add Project Object ACE Statement
Alter Configuration Object ACE Statement
Alter Folder ACE Statement
Alter Folder ACL Statement
Alter Group ACE Statement
Alter Project Object ACE Statement
List ACL Properties Statement
Remove Configuration Object ACE Statement
Remove Folder ACE Statement
Remove Project Object ACE Statement
Take Ownership Statement
Attribute Statements
Add Attribute Child Statement
Add Attribute Form Expression Statement
Add Attribute Form Statement
Add Attribute Parent Statement
Alter Attribute Form Expression Statement
Alter Attribute Form Statement
Alter Attribute Statement
Create Attribute Statement
Delete Attribute Statement
Get Child Candidates Statement
Get Parent Candidates Statement
Get Tables Statement
List Attribute Properties Statement
List Attributes Statement
Remove Attribute Child Statement
Remove Attribute Form Expression Statement
Remove Attribute Form Statement
Remove Attribute Parent Statement
Cache Statements
Alter Element Caching Statement
Alter Object Caching Statement
Alter Report Caching Statement
Delete Report Cache Statement
Invalidate Report Cache Statement
List Caching Properties Statement
List Report Cache Properties Statement
List Report Caches Statement
Load Report Caches Statement
Purge Caching Statement
Unload Report Caches Statement
Change Journaling Statements
Get Change Journaling Statement
List Change Journaling Statement
Purge Change Journaling Statement
Set Change Journaling Statement
Cluster Statements
Add Server to Cluster Statement
List Projects on Cluster Statement
List Cluster Servers Statement
Load Projects to Cluster Statement
Remove Server from Cluster Statement
Unload Projects from Cluster Statement
Connection Map Statements
Alter Connection Map Statement
Create Connection Map Statement
Delete Connection Map Statement
List Connection Maps Statement
Connection Statements
Connect Source Statement
Disconnect Source Statement
Contact Group Statements
Add Contact Group Statement
Alter Contact Group Statement
Create Contact Group Outline
Delete Contact Group Statement
List Contact Group Properties Statement
List Contact Groups Statement
Remove Contact Group Statement
Contact Statements
Alter Contact Statement
Create Contact Statement
Delete Contact Statement
List Contact Group Properties Statement
List Contact Groups Statement
Custom Group Statements
Add Custom Group Element Statement
Alter Custom Group Statement
Create Custom Group Statement
Delete Custom Group Statement
List Custom Group Properties Statement
List Custom Groups Statement
Remove Custom Group Element Statement
Custom Group Element Expression Syntax
-- Attribute Qualification
-- Metric Qualification
-- Shortcut to a Filter
-- Shortcut to a Report
-- Banding Qualifications
-- Custom Functions
-- Joint Element List
Data Load Statements
Alter Data Load Statement
Create Data Load Statement
Delete Data Load Statement
Execute Data Load
List All Data Load Statement
List Properties for Data Load Statement
Database Conection Monitor Statements
Disconnect Database Connection Statement
List Database Connection Properties Statement
List Database Connections Statement
DBConnection Statements
Alter DBConnection Statement
Create DBConnection Statement
Delete DBConnection Statement
List DBConnection Properties Statement
List DBConnections Statement
DBInstance Statements
Alter DBInstance Statement
Create DBInstance Statement
Delete DBInstance Statement
List DBInstance Properties Statement
List DBInstances Statement
DBLogin Statements
Alter DBLogin Statement
Create DBLogin Statement
Delete DBLogin Statement
List DBLogin Properties Statement
List DBLogins Statement
Device Statements
Alter Email Device Statement
Alter File Device Statement
Alter iPad Device Statement
Alter iPhone Device Statement
Alter Print Device Statement
Create Email Device Statement
Create File Device Statement
Create iPad Device Statement
Create iPhone Device Statement
Create Print Device Statement
Delete Device Statement
List Device Properties Statement
List Devices Statement
Document Cache Statements
Delete Document Cache Statement
Invalidate Document Cache Statement
List Document Cache Properties Statement
List Document Caches Statement
Load Document Cache Statement
Unload Document Cache Statement
Document Statements
Alter Document Statement
Delete Document Statement
List Available Schedules for Document Statement
List Document Properties Statement
List Documents Statement
Enterprise Manager Statements
Connect to Enterprise Manager Statement
List Properties for Enterprise Manager Statement
Set Options in Enterprise Manager Statement
Start Monitoring Server for Enterprise Manager Statement
Stop Monitoring Server for Enterprise Manager Statement
Event Statements
Alter Event Statement
Create Event Statement
Delete Event Statement
List Events Statement
Trigger Event Statement
Fact Statements
Add Fact Expression Statement
Alter Fact Statement
Create Fact Statement
Delete Fact Statement
Get Tables Statement
List Fact Properties Statement
List Facts Statement
Remove Fact Expression Statement
Feature Flag Statements
Alter Feature Flags Statement
List All Feature Flags Statement
Fence Statements
Alter Fence Statement
Create Fence Statement
Delete Fence Statement
List Fences Statements
Filter Statements
Alter Filter Statement
Create Filter Statement
Delete Filter Statement
List Filter Properties Statement
List Filters Statement
Filter Qualification Syntax Filter Qualification Syntax
Folder Statements
Alter Folder Statement
Create Folder Statement
Delete Folder Statement
List Folder Properties Statement
List Folders Statement
Remove Folder Contents Statement
Hierarchy Statements
Add Attribute to Hierarchy Statement
Add Relationship Statement
Alter Hierarchy Statement
Create Hierarchy Statement
Delete Hierarchy Statement
List Hierarchy Properties Statement
List Hierarchies Statement
Remove Attribute from Hierarchy Statement
Remove Relationship Statement
Incremental Refresh Statements
Delete Incremental Refresh Report Statement
List Incremental Refresh Reports Statement
Publish Incremental Refresh Report Statement
Intelligent Cube Cache Statements
Activate Intelligent Cube Cache Statement
Deactivate Intelligent Cube Cache Statement
Delete Intelligent Cube Cache Statement
List Intelligent Cube Cache Properties Statement
List Intelligent Cube Caches Statement
Load Intelligent Cube Cache Statement
Unload Intelligent Cube Cache Statement
Update Intelligent Cube Cache Statement
Intelligent Cube Statements
Delete Intelligent Cube Statement
List Intelligent Cube Properties Statement
List Intelligent Cubes Statement
Publish Intelligent Cube Statement
Refresh Cube Statement
Job Monitor Statements
Kill Job Statement
List Job Properties Statement
List Jobs Statement
Language Statements
Alter Language Statement
Create Language Statement
Delete Language Statement
List Available Languages Statement
List Languages Statement
List Resolved Languages Statement
Lock Statements Lock Statements
List Lock Properties Statement
Lock Configuration Statement
Lock Project Statement
Unlock Configuration Statement
Unlock Project Statement
MDXCube Statements
Alter MDX Cube Statement
List MDX Cubes Statement
Maintenance Task Statements
Delete Maintenance Task Statement
Create Maintenance Task Statement
List Maintenance Task Statement
Metric Statements
Alter Metric Statement
Create Metric Statement
Delete Metric Statement
List Metric Properties Statement
List Metrics Statement
Metric Expression Syntax
Simple Metrics
Level (Dimensionality)
Conditionality
Transformations
Compound Metrics
Miscellaneous Statements
Get Object Property Statement
List Dependents
Log Event Statement
Run Command Statement
Set Hidden Property Statement
Start Service Statement
Stop Service Statement
Notes Statements
Append Note Statement
Clear Notes Statement
Get Notes Statement
Replace Notes Statement
Package Statements
Create Undo Package Statement
Import Package Statement
Privileges Statements
Grant Privilege Statement
List of Privilege Tokens
Revoke Privilege Statement
Update Privileges Statement
Procedure Statements
Execute Procedure Statement
Sample Procedures
Execute
ExecuteCapture
PrintOut
PrintErr
ResultSet Methods
ResultCell Methods
Project Configuration Statements
Add DBInstance Statement
Alter Project Configuration Statement
Alter Statistics Statement
List Project Configuration Properties Statement
List Statistics Properties Statement
Purge Statistics Statement
Remove DBInstance Statement
Alter Platform Analytics Statistics Statement
List Platform Analytics Statistics Properties Statement
Project Statements
Alter Project Statement
Create Project Statement
Delete Project Statement
Idle Project Statement
List Project Properties Statement
List Projects Statement
Load Project Statement
Register Project Statement
Resume Project Statement
Unload Project Statement
Unregister Project Statement
Update Project Statement
Report Statements
Alter Report Statement
Delete Report Statement
List Report Properties Statement
List Available Schedules for Report Statement
List Reports Statement
Schedule Statements
Alter Schedule Statement
Create Schedule Statement
Delete Schedule Statement
List Schedule Properties Statement
List Schedules Statement
Schedule Relation Statements
Delete Schedule Relation Statement
List Schedule Relations Statement
Schema Statements
Search Statements
List Searches Statement
Run Search Statement
Security Filter Statements
Alter Security Filter Statement
Apply Security Filter Statement
Create Security Filter Statement
Delete Security Filter Statement
List Security Filter Properties Statement
List Security Filters Statement
Revoke Security Filter Statement
Security Role Statements
Alter Security Role Statement
Create Security Role Statement
Delete Security Role Statement
Grant Security Role Statement
List Security Role Members Statement
List Security Role Privileges Statement
List Security Role Properties Statement
List Security Roles Statement
Revoke Security Role Statement
Server Configuration Statements
Alter Server Configuration Statement
Apply Run-Time Settings Statement
List Server Configuration Properties Statement
Purge Statistics Statement
Server Statements
List All Servers Statement
List Server Properties Statement
Restart Server Statement
Start Server Statement
Stop Server Statement
Shortcut Statements
Alter Shortcut Statement
Create Shortcut Statement
Delete Shortcut Statement
List Shortcut Properties Statement
List Shortcuts Statement
Shortcut Object Hierarchy
Subscriptions Statements
Add User Address Statement
Add User Contact Statement
Add Recipient Statement
Alter User Address Statement
Alter Cache Update Subscription Statement
Alter Email Subscription Statement
Alter File Subscription Statement
Alter Print Subscription Statement
Alter History List Subscription Statement
Alter Mobile Subscription Statement
Create Cache Update Subscription Statement
Create History List Subscription Statement
Create Mobile Subscription Statement
Create Email Subscription Statement
Create File Subscription Statement
Create Print Subscription Statement
Delete Subscription Statement
Delete All Subscriptions Statement
List Contacts Statement
List Subscription Properties Statement
List Subscriptions Statement
Remove User Address Statement
Remove Recipient Statement
Remove User Contact Statement
Trigger Subscription Statement
Trigger Multiple Subscriptions Statement
Table Statements
Add Warehouse Table Statement
Alter Table Statement
List Table Properties Statement
List Tables Statement
List Warehouse Tables Statement
Remove Table / Warehouse Table Statement
Update Structure Statement
Translation Statements
Add Translation Statement
Alter Translation Statement
Delete Translation Statement
List Translation Statement
Transmitter Statements
Alter Email Transmitter Statement
Alter File Transmitter Statement
Alter iPad Transmitter Statement
Alter iPhone Transmitter Statement
Alter Print Transmitter Statement
Create Email Transmitter Statement
Create File Transmitter Statement
Create iPad Transmitter Statement
Create iPhone Transmitter Statement
Create Print Transmitter Statement
Delete Transmitter Statement
List Transmitter Properties Statement
List Transmitters Statement
User Connection Monitor Statements
Disconnect User Statement
List User Connection Properties Statement
List User Connections Statement
Send Message Statement
User Group Statements
Add User Group Statement
Alter User Group Statement
Create User Group Statement
Delete User Group Statement
List User Group Members Statement
List User Group Privileges Statement
List User Group Properties Statement
List User Groups Statement
Remove User Group Statement
User Statements
Add User to Group Statement
Alter Users in Group Statement
Alter User Statement
Create User Statement
Delete User Statement
Import Users from File Statement
List User Properties Statement
List User Privileges Statement
Remove User from Group Statement
User Profile Statements
Create User Profile Statement
Delete User Profile Statement
List User Profiles Statement
VLDB Properties Statements
Alter VLDB Settings Statement
List VLDB Settings Statement
Web Preferences Statements
Apply Web Preferences Statement
List Web Preferences Statement