You can also import users. csv - information about every user group in the metadata. Grant/Revoke privilege. Windows from the command line, then perform the following steps: From the Windows Start menu, select Run. CREATE HISTORYLISTSUBSCRIPTION "hl_sub_prompt_2" SCHEDULE "Monday Morning" USER "administrator" CONTENT "Store Sales" IN FOLDER "Public ObjectsReportsSubject AreasDaily Analysis" IN PROJECT "MicroStrategy Tutorial" PROMPT "Predefined. The full procedure file is attached in this tech note for references. Example In addition to the graphical user interface and the command line execution, Command Manager has a text-based command line interface. x. subscription_GUID is the ID of the subscription. Select each folder, right-click and choose 'Properties', and in the Security tab delete all the permissions and add the user that owns that folder and assign Full Control in the Object and Children levels. In MicroStrategy 2019, the primary form of consumption of Cards will be through a Google Chrome extension. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. Enterprise Manager consists of a MicroStrategy project, the Enterprise Manager server (service), and an interface in MicroStrategy Command Manager where administrators can control how the server. In Microstrategy Administrator - Command Manager an administrator can move reports from one folder to another and can even re-name these reports when moving them. exe --ResponseFile="C: esponse. x-10. The auto-complete feature can significantly speed up the time it takes users to create a Command Manager script and also will reduce the dependency to the. x-10. Create, modify, and delete database instances, connections, and logins. x-10. The auto-complete feature can significantly speed up the time it takes users to create a Command Manager script and also will reduce the dependency to the. ; From the Choose a project drop-down list, select the project that you want to create a security filter for. MicroStrategy Command Manager is an application designed to simplify and automate administration tasks, such as add, delete, or update enterprise-level data associated with large numbers of users and user groups. This can be done with MicroStrategy SDK 9. “occurs during unloading a project via Command Manager or Developer when there is user session or job execution. Knowing this, a user can create their own User Procedures starting from scratch or based in any Sample Procedure provided and making their own modifications. Run the command script. If you create a batch file to execute a Command Manager script from the. scp file. 4. For general information about Command Manager, see Automating Administrative Tasks with Command Manager. Such profile folders for which users do not exist anymore can be identified and deleted using a sample Command Manager procedure/outline. 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. Refresh. After running the command in Command Manager, edit the subscription and the delivery format for that subscription is now set to. This document is a sample. Execute a Microstrategy Command Manager script through a command line interface. A token is a word, a list of words enclosed in quotation marks, or a symbol. Uses MicroStrategy REST APIs; Optional Containerization (Kubernetes) Secure MicroStrategy connections; Cube refresh instructions and parameters are provided by the calling process, i. 1) In MicroStrategy Tutorial project, create a new subscription and define its name as Test. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. " 2. The following procedure describes how to use MicroStrategy Command Manager 9. x. Start, stop, or restart the Intelligence Server, configure clusters, and disconnect active sessions. REPRODUCTION: Login to MSTR web and access a. To test, run the script. Create the user using two Command Manager scripts instead of one. Adding support for TLS is done by selecting the Use SSL checkbox. Exact outline that is failing. Assign users to this group who need to view reports. 3. The folder and its contents remain on the system and ownership is assigned to Administrator. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. ini". You can also configure these settings using Command Manager scripts located at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_Outlines. Use the "CREATE USER" outline to write a script to create a new user. A Command Manager script consists of one or more script statements. Once the above outline is executed in Command Manager, all addresses associated with all users under Everyone will be deleted. MicroStrategy Command Manager can trigger. When creating many users, it is necessary to use MicroStrategy Command Manager to increase the speed of creating users. Right click on the System Administrator's. 1. You are returned to the Summary page. To create to a direct project source. scp -o DisableUsers_output. This can be achieved as follows: Connect to a project. Update Structure statement. MicroStrategy Web (. ACTION: Use a user ID that has administrator privileges to run the. Specifying "Shared Reports Folder" is one of the missing outlines in the Command Manager. 1. Would you like to use this machine name anyway? CAUSE: The user ID that was used to launch Command Manager through the command line does not have administrator privileges on the machine. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. That XML file can then be used to create the package from the. All objects in the update package are copied to the destination project or project source, following the rules specified in the update package. It is used to apply database (row-level) security to a MicroStrategy user. x when running the ALTER PROJECT CONFIGURATION command and the EMPTYREPORTMESSAGE parameter contains HTML tags. Knowing this, a user can create their own User Procedures starting from scratch or based in any Sample Procedure provided and making their own modifications. Open MicroStrategy Web and click Add external data. With this interface, you can create and execute Command Manager scripts in an environment where the graphical user interface is unavailable, such as when accessing a UNIX system via telnet. Each statement ends with a semicolon (; ). 1 HF3 Command Manager syntax for the command. For the syntax for using the executable, see Executing a Command. address. Install Enterprise Manager on a machine that is separate from Intelligence Server. 7: Scheduler. x and receives the following error:. This optimizes performance and enables administrators to select specific user requests or subscriptions to process first based on priority level. The 'Enabled Status' form is a flag that has been added to the EM_USER table in the MicroStrategy Enterprise Manager warehouse. " after running the Create User script with multiple qualifications in MicroStrategy Command Manager. For instructions on how to view or edit a sample procedure, see Inserting sample statements. Published: Oct 12, 2021. In MicroStrategy 10. x and newer. Run the script LIST ALL CHANGE JOURNALINGS. 4. The following examples show a URL for accessing a MicroStrategy folder when the user does not have an existing session. Select only Configuration Objects for documentation. 31K KB45030: How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. First, the user needs to use MicroStrategy Object Manager to create an XML file specifying what objects are to be included in the update package. This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. Command Manager returns an "Object with ID 'XXX' and type 34 (User) is not found in metadata. x offers the ability to update Web Preferences for both Project level and individual user level. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. The following table lists folders and files of interest that are included in the default directory structure after an installation of Object Manager. 4. Open Command Manger and create a connected or connection-less session. USER "login_name" is the login name of the user to be altered, of type string. " Specify and change the Log output. x Number of Views 2. You can also configure these settings using Command Manager scripts located at C:\Program Files (x86)\MicroStrategy\Command Manager\Outlines\Cache_Outlines. x. This article explains how to use Command Manager Script to add recipient(s) from "Personal List" to existing Subscriptions. When possible, references to original articles are listed on each page. In the Service drop-down list, select the service. User should be careful with using this procedure. xAs Bruno said, the Outlines option gives you all the templates that there are in Command Manager, which you can build together and define to do what you want. Click Yes to open the command prompt with administrator privileges. This does not include the case of a user retrieving a report from the History List (which does not create a job). x and 10. x . These types of subscriptions will need to be expired using Command Manager using the steps below. You. x-10. Edit the schedule to be an event-based. Thus, it is possible to get a list of users that which are enabled by adding a filter to the report with 'Enabled Status. 5. Grant and revoke privileges to users. for (int i = 0; i < _addresses. The following MicroStrategy Command Manager script will create a user that must change their password on their next logon: CREATE USER "login_name" PASSWORD "password" FULLNAME "User Full Name" DESCRIPTION "Developer" ALLOWCHANGEPWD TRUE PASSWORDEXPFREQ 30 DAYS CHANGEPWD TRUE; In MicroStrategy Web, create a grid report containing at least three columns. In MicroStrategy Command Manager, perform the ‘LIST ALL GROUPS;’ script and confirm that only the English group name ‘new_Eng_Group’ is returned and not not ‘한글그룹’ as shown in the image below:. 4. Connectivity in MicroStrategy Weband MicroStrategy Desktop. Create a batch file by saving the script and creating a . The user then creates a subscription to "Test Report" in MicroStrategy Command Manager that specifies the folder name and location of the report. The following procedure describes how to use MicroStrategy Command Manager 9. Alter Report Caching statement. NOTE: This script does not appear in the outlines list. Data Load is enabled: </ScheduleType><Enabled>1</Enabled></EMSchedule>. A blank visualization appears in the dossier. The Save dialog box opens. For more information about Command Manager, see the Automating Administrative Tasks chapter. For example, a report with the "User" attribute and "RP Number of Jobs" metric will only list users whose number of jobs is greater than 0. The MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. 9 MicroStrategy Command Manager MicroStrategy Command Manager is a scripting tool that allows administrators to automate nearly all administrative and maintenance tasks. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. To Deny User or. For configuration purposes either will work. STEPS TO REPRODUCE: 1. Number of Views 884. 2. Another method for providing a script to non administrative users for them to use, without giving them access to the adminstrative credentials, is to use encrypted scripts. After executing a ’PURGE [ALL REPORT] CACHING' script in MicroStrategy Administrator Command Manager 9. Checking Who Is Logged-in To A Remote Computer or Server. Open User Preferences > Project Defaults. You may later assign ownership and access control lists for the folder and its contents to other users. bat file. To Start the Command Manager Graphical Interface. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. Data Management "I want to create 500+ attributes in bulk using. The value of '1' means that the user is enabled. x, as shown below: All report caches, even caches associated with History List messages are deleted. Grant or revoke user privileges, create security filters, and disable user accounts. Users might also observe that a particular user who is in the export of the command " LIST MEMBERS FOR USER GROUP "Everyone";" might not be in the " LIST MEMBERS FOR USER GROUP "LDAP Users"; CAUSE This is a known defect in MicroStrategy Command Manager 10. Mouse over the Hadoop data source options and choose Impala. To Deny User. The Subscription Manager allows you to manage all the subscriptions for a project from one interface. This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. If the value is '0', then the user is disabled. The WHLINK option sets the login name for both database authentication and. Type the command of . From the Visualizations panel, select Grid . Run the ALTER CONTACT script to change the LINKMSTRUSER to the new user. For the sample to work, the MicroStrategy Web JAR files must be accessible by the Java Runtime. Tokens can be: reserved words. x-10. scp -o. ACTION Contact Microstrategy Technical. ADD GROUP "Customers" TO SUBSCRIPTION "Test" FOR PROJECT "MicroStrategy Tutorial". ACTION: Click Insert Visualization . x metadata using a Command Manager outline. KB440526: How-to-create-a-User-Procedure-based-on-a-Sample-Procedure-in-MicroStrategy-Command-Manager . Workaround. You can deny user or group access to a specific MicroStrategy project by using a security role. 0. user_or_group_name is the name of the recipient user or group. The Advanced Metric Assistant allows you to combine simple metrics with filters or transformations to. Type mstrcmdmgrw and press Enter. Go to Administration > User Group > Everyone. 4. This is only visible when running Enterprise Manger Scripts on. For configuration purposes either will work. KB36573 describes many of these privileges in detail. This allows the new source to be created with the UseSSL setting enabled. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting. 2. Controlling Access to a Project. In the Command Manager editor, the user can use the key word "AND", "OR" to separate the conditions within the security filter expression command outline. The command below is a non-admin command, so you can run it as a standard user. This technical note explains how this can be accomplished using MicroStrategy Administrator - Command Manager . The value of '1' means that the user is enabled. In order to kick off this Command Manager file, we then create a windows . Create a folder Command name: “mkdir” - stands for “Make Directory. Alternately, the warehouse login ID can be set using Command Manager. Select Automatic as the Startup Type option. Start the Command Manager graphical interface: In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. x, when using the Command Manger ADD ACE FOR FOLDER or REMOVE ACE FROM FOLDER outlines to affect ACLs in MicroStrategy Developer, the changes are not saved after an I-Server restart or purging object cache. Therefore, MicroStrategy recommends to add. PROJECT "project_name" is the project for which you want to list the security roles for the user or group, of type string. x and 10. You can then call this procedure from another Command Manager script, supplying. x, create a new report with the following definition:. Open Workstation and connect to the environment with "Workstation_user". Users wish to execute scripts in MicroStrategy Command Manager 9. 5. Click on the "+" button next to "Reports" to create a new report. The value of '1' means that the user is enabled. In MicroStrategy Command Manager 9. Schema objects, the building blocks of business intelligence and application objects that generate useful analytical information, can be transferred within or between. As such, the upgrade between Enterprise Manager and Platform Analytics is not supported. x, all subscriptions outlines are specified in Subscription_Outline folderExpand Administration, then expand Configuration Managers, and then select Subscriptions. In Microstrategy Administrator - Command Manager an administrator can move reports from one folder to another and can even re-name these reports when moving them. 4. 4. To manage your subscriptions, select from the tasks below: To create a subscription, right-click in the Subscription Manager and select Subscription Creation Wizard. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). get (i); addr. NAME "new_login_name" is the new login name of the user, of type string. Go to the Languages tab. where: subscription_name is the name of the subscription. Hive. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. Workaround. Delete the inconsistent table objects if no other objects are depending on it. Save these files to a folder. One means of doing this is to use the "List all metrics for project" outline under OutlinesMetrics in Command Manager and export the content for further analysis. That XML file can then be used to create the package from the command. From the Select a Project drop-down list, select the project for which to assign the security role. In Windows: From the Windows Start menu, go to All Programs > MicroStrategy Tools > Command Manager. Select any project that is in the project source that contains the users and groups and click Next. Alternatively, the user can split the logs between Results, Failed Instructions, and. . 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" LOGIN "sa" PASSWORD "sa"; Create the. The value of '1' means that the user is enabled. However, if it uses Windows authentication, the user name passed to Command Manager is ignored and the Windows security credentials are used instead. these scripts are at C:Program Files (x86)MicroStrategyCommand. In order to configure a project source and list projects to be monitored by MicroStrategy Enterprise Manager, the user must satisfy one of the following. Create Data Load and check EM_Configuration table. A MicroStrategy Intelligence Server was not found at this location. Procedures can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager statements in Java commands. This technical note explains how this can be accomplished using MicroStrategy Administrator - Command Manager . MicroStrategy Command Manager can trigger events from the Windows. In Command Manager, I then save this code into a . A list of security roles in the project source opens in the main Developer pane. All the logical tables using this warehouse table will also get their definitions updated. All up to date privilege tokens are accessible in Command Manager, see Inserting Sample Statements: Outlines for more information. x-10. HIDDEN indicates whether the security filter is hidden. scp) to be executed. The Command Manager application provides a convenient feature that allows the user to create a project (data) source directly in the application rather than switching to MicroStrategy Developer. List of statements supported in Command Manager Runtime. Number of Views 884. To Execute a Script from the Command Manager Graphical Interface. Use Command Manager to import users with a Windows link. For example, administrators may configure fences for users who require more processing power or high availability. x and 10. x. The Command Manager application provides a convenient feature that allows the user to create a project (data) source directly in the application rather than switching to MicroStrategy Developer. MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. Click Enter. KB34483: ‘List All Groups’ script in MicroStrategy Command Manager 9. Workstation provides a central place to create and manage multiple cards. com" DELIVERYTYPE EMAIL DEVICE "generic EMAIL" TO USER "test01"; 2. Run the following command to connect the Enterprise Manager Data Loader service to a MicroStrategy environment by choosing an Intelligence Server from that environment. Command Manager manipulates MicroStrategy objects by means of user-created scripts rather than a graphical user interface. In MicroStrategy Command Manager 10. The syntax is for MicroStrategy Command Manager version 8. where: USER "login_name" is the login name of the user for whom properties are listed, of type string. This procedure needs to be supplied with the project name for which the profile. The command prompt is displayed. ACTION:Open MicroSoft Notepad and save the following commands as file: cmdmgr -n LON-GOTTFRIED -u Administrator -p Ad3pwx4 -f c:winntDisableUsers. How can we create a Command Manager procedure? In Command Manager, from the File menu, select New Procedure. x, if the user alters data load by, for example, adding new projects to be monitored, or modifying data load name, the data load is disabled. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from cubes and reports, create new datasets, add new data to existing datasets, and manage Users/User Groups, Servers, Projects, and more. x. x Number of Views 2. x. the workflow manager or enterprise scheduling tool, as a json request message; Requests messages can be sent from the workflow manager or. The Kernel XML trace (communication between IS and command manager) Kernel XML trace:When opening command manager outlines, look for the 'Alter_user' or 'Alter_users' outlines located under the 'User oulines' folder. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. ” How to use it: mkdir <new folder name> This will create a folder inside the current folder you are in (use pwd to check where you are) Delete a folder or a fileCreate a command script in Command Manager and save it as encrypted. reg file under the setting. ini". A list of security roles in the project source opens in the main Developer pane. MicroStrategy Command Manager provides a set of Sample Procedures, which take advantage of java code flexibility, out of the box. List all properties for a specific subscription. To list all enabled users is the everyone group, here is sample code: import java. scp -o DisableUsers_output. This article describes how to generate a list of which user/group has access to a project using Command Manager. 1. In MicroStrategy Command Manager, users can take advantage of the auto-complete feature that will help in predicting the next words that can be included in a script statement while typing. KB442598: User occasionally fails to copy objects from one project and paste to another project across different project s… Number of Views 267 KB438574: MicroStrategy Command Manager 10. If you have a large number of objects to create or edit, you can also use MicroStrategy Command Manager to work with these objects. LIST ALL SUBSCRIPTIONS FOR CONTENT GUID <report_or_document_guid> FOR PROJECT "<project_name>"; CAUSE: This is a known limitation MicroStrategy Command. Thus, the user may want to create a set of global variables that are accessible by all of these files for convenience. In MicroStrategy 10. USER "login_name" is the name of the user whose security roles you want to list, of type string. Configure Through Command Manager. Use this module to create or execute MicroStrategy Command Manager scripts. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. 4. The default file extension for update packages is . To modify a schedule, right-click the schedule and select Edit. 5. x, Command Manager returns a row of 1 for script “LIST ALL. x. ‒ Uses an English like scripting language to convert a manual process into an automated one ‒ Executes a script automatically at a scheduled time without any. del c:cmdmgr rigger. the workflow manager or enterprise scheduling tool, as a json request message; Requests messages can be sent from the workflow manager or. FILTER "filter_name" is the name of the filter to provide the. 2) In order to add the Customers group to this newly created subscription in MicroStrategy Command Manager 9. bat with the following commands: if not exist c:cmdmgr rigger. x behavior), put ;-at the end of the level statement (inside the braces). Follow these steps to achieve this customization:. However, this is not the case. it is evident that the user does not have Write permissions to this object. 4. 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. MicroStrategy Command Manager 10. To create an event using Command Manager. MicroStrategy Command Manager MicroStrategy Command Manager gives the administrators the ability to create scripts to automate the most common administrative tasks. x - 10. 4. However, if it uses Windows authentication, the user name passed to Command Manager is ignored and the Windows security credentials are used instead. To use the Application level, go to 'Tools' > 'Options' > 'Results' tab as shown below. Inside command manager, navigate to Outlines -> Procedure_Outlines -> Sample_Procedures -> List_Disabled_Users. Open Command Manger and create a connected or connection-less session. Both of these outlines contain the commands for modifying either a groups password policy or a single user's password policy. The MicroStrategy system uses the metadata to know where in the data warehouse it should look for information. 4. ). csv - information about every user in the metadata. To invoke Command Manager from the database server, use one of the following. By default, Command Manager scripts are saved in plain text format. The schedule wizard will be displayed as shown below. The MicroStrategy Web JAR files can be found under: MicroStrategy Web Universal (JSP): {web_root}/WEB-INF/lib directory. From the Tools menu, select Import Package: Browse to the saved update package and select it. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. Log in using and Administrator account. KB312890: "LIST ALL USER GROUPS;" in MicroStrategy Command Manager returns different result after upgrading from 9. Information if the script that is falling come from the outline list or this is new created script. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. ANSWER: Currently, there are two ways that a user may manually trigger an email subscription for other users: Find the schedule associated with the subscription in question. The "OBJECTS" section. It connects to Metadata, downloads all needed information and creates four CSV files with information needed to visualize user structure. x-10. contact_name is the name of the recipient contact. project_name is the name of the project, of type string, between double quotes ("). Thus, it is possible to get a list of users that which are enabled by adding a filter to the report with 'Enabled Status. In MicroStrategy Object Manager 9. Enterprise Manager consists of a MicroStrategy project, the Enterprise Manager server (service), and an interface in MicroStrategy Command Manager where administrators can control how the server. The second script, using the Alter User. To Execute a Script from the Command Manager Graphical Interface. MICROSTRATEGY. Such profile folders for which users do not exist anymore can be identified and deleted using a sample Command Manager procedure/outline. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. Enable user. Environment. Hover over the Properties column and click Open Intelligence Server Administration Portal . First, the user needs to use MicroStrategy Object Manager to create an XML file specifying what objects are to be included in the update package. x and newer on Windows and Unix/Linux; Knowledge Base: How to perform a License Audit in MicroStrategy Intelligence Server 10. x, no or incomplete results are returned. In MicroStrategy, users have the option to create subscriptions in Command Manager using an outline much like the following example: Since the subscription is created using a path and report name, most users would expect the path and name to be evaluated every time the subscription runs. The sample procedures are stored in the Command Manager directory, in OutlinesProcedure_OutlinesUser_Procedures. Enterprise Manager reports in 9. Command Manager allows administrators to: Add, remove, or modify users or user groups. x. Thus, the user cannot create a new folder inside of the Public Objects folder. Select Project Sources and click Next. Developers of OEM applications that use embedded MicroStrategy projects may need flexibility in configuring their environment. NET): Program FilesCommon FilesMicroStrategy directory. CREATE ATTRIBUTE "Month" DESCRIPTION "Duplicate of Month Attribute from folder Time" IN FOLDER "Schema ObjectsAttributes" ATTRIBUTEFORM "ID" FORMDESC "Basic ID form" FORMTYPE TEXT SORT ASC EXPRESSION " [MONTH_ID]" LOOKUPTABLE "LU_MONTH" FOR PROJECT "MicroStrategy Tutorial";• granting Access to users • Creating Security Roles using Microstrategy Desktop • Migrating project changes from Development to UAT and from UAT to Production using Microstrategy Object Manager • Setting preferences for different projects that govern the way projects are run for web users using Microstrategy Web • Creating Command. Description of the illustration b1. SOURCE_APP: The source application associated with the user connection, returned as an integer: 1: MicroStrategy Developer. This means that the Administrator will not be able to directly modify the subscriptions to set them as expired. 1. ACTION: This issue has been fixed in MicroStrategy 10. x, it is possible to setup a system to automate creating, importing and undoing Packages for Object Manager entirely from command line. 3. For example, to create a user with ID 'mstr_test' and full name "MSTR Test", type the following command: CREATE USER "mstr_test" PASSWORD "123. x, select 'Project Documentation' from the Tools menu to start the wizard. Cloudera CDH Hadoop Gateway System. Command Manager contains a large number of sample procedures that you can view and modify. This section lists the basic commands you need to execute in Command Manager to begin capturing, analyzing, and reporting on data about your system with Enterprise Manager. x: In the Results tab, Right Mouse Click > Export Results > to Excel as shown in the image below:. License Manager can be run on Windows or UNIX, in either GUI mode or command line mode.