Sunday, January 29, 2012

Command Manager Exploration Part - 1

Hi All,

Here are some of the command manager outlines that are useful for the reference. Copy all these scripts and connect to the command manager and execute the scripts one by one and paralelly check this out in the Developer for better clarity.

/* Folder Outlines*/

CREATE FOLDER "Test1" IN "\Public Objects\Reports" DESCRIPTION "Test Folder Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

CREATE FOLDER "Test2" IN "\Public Objects\REPORTS\Test1" DESCRIPTION "Test FOLDER Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

CREATE FOLDER "Test3" IN "\Public Objects\REPORTS\Test1" DESCRIPTION "Test FOLDER Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

ALTER FOLDER "Test3" IN "\Public Objects\REPORTS\Test1" NAME "Test4" DESCRIPTION "Test FOLDER Created by Reginold _ Edited" LONGDESCRIPTION "Just a learning curve"  HIDDEN  FALSE LOCATION "\Public Objects\REPORTS\Test1" FOR PROJECT "Customer Analysis Module";

LIST ALL PROPERTIES FOR FOLDER "Test1" IN "\Public Objects\REPORTS" FOR PROJECT "Customer Analysis Module";

LIST ALL FOLDERS IN "\Public Objects\REPORTS\Test1" FOR PROJECT "Customer Analysis Module";

CREATE FILTER "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1" EXPRESSION "Customer@ID in(1,2,3,4)" DESCRIPTION "Filter Creation Script" LONGDESCRIPTION "My First Filter Creation Script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

CREATE FILTER "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1\Test2" EXPRESSION "Customer@ID in(1,2,3,4)" DESCRIPTION "Filter Creation Script" LONGDESCRIPTION "My First Filter Creation Script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

CREATE FILTER "Customer DESC Filter" IN FOLDER  "\Public Objects\REPORTS\Test1\Test4" EXPRESSION "Customer@DESC in (^"Carole Vorndran^",^"Melanie Searles^",^"Monica Neptune^")" DESCRIPTION "FILTER Creation script WITH DESCRIPTION Column" LONGDESCRIPTION "This is my SECOND FILTER creation script" HIDDEN FALSE ON PROJECT  "Customer Analysis Module";

REMOVE FOLDER CONTENT  "\Public Objects\REPORTS\Test1\Test2" IN "\Public Objects\REPORTS\Test1\Test2" FROM PROJECT "Customer Analysis Module";
REMOVE FOLDER CONTENT CASCADE "\Public Objects\REPORTS\Test1\Test4" IN "\Public Objects\REPORTS\Test1\Test4" FROM PROJECT "Customer Analysis Module";
DELETE FILTER  "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1" FROM PROJECT  "Customer Analysis Module";

DELETE FOLDER "Test1" IN "\Public Objects\REPORTS" FROM PROJECT "Customer Analysis Module";

/* Filter Outlines*/

CREATE FOLDER "Test1" IN "\Public Objects\Reports" DESCRIPTION "Test Folder Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

CREATE FOLDER "Test2" IN "\Public Objects\REPORTS\Test1" DESCRIPTION "Test FOLDER Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

CREATE FILTER "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1" EXPRESSION "Customer@ID in(1,2,3,4)" DESCRIPTION "Filter Creation Script" LONGDESCRIPTION "My First Filter Creation Script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

CREATE FILTER "Customer ID FILTER" IN FOLDER "\Public Objects\REPORTS\Test1\Test2" EXPRESSION "Customer@ID in(1,2,3,4)" DESCRIPTION "Filter Creation Script with ID column" LONGDESCRIPTION "My First Filter Creation Script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

CREATE FILTER "Customer DESC Filter" IN FOLDER  "\Public Objects\REPORTS\Test1\Test2" EXPRESSION "Customer@DESC in (^"Carole Vorndran^",^"Melanie Searles^",^"Monica Neptune^")" DESCRIPTION "FILTER Creation script WITH DESCRIPTION Column" LONGDESCRIPTION "This is my SECOND FILTER creation script" HIDDEN FALSE ON PROJECT  "Customer Analysis Module";

ALTER FILTER "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1" NAME "Customer FILTER _ Edited" EXPRESSION "Customer@ID in(1,2)" DESCRIPTION "First Alter Filter Scripts" LONGDESCRIPTION "Just a Editing script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

LIST ALL PROPERTIES FOR FILTER "Customer ID FILTER" IN FOLDER "\Public Objects\REPORTS\Test1\Test2" FROM PROJECT "Customer Analysis Module";

LIST ALL FILTERS IN  FOLDER "\Public Objects\REPORTS\Test1" FOR OWNER "Administrator" FOR PROJECT "Customer Analysis Module";

LIST ALL FILTERS IN  FOLDER "\Public Objects\REPORTS\Test1\Test2" FOR OWNER "Administrator" FOR PROJECT "Customer Analysis Module";

DELETE FILTER "Customer DESC FILTER" IN FOLDER "\Public Objects\REPORTS\Test1\Test2" FROM PROJECT  "Customer Analysis Module";

DELETE FILTER  "Customer ID FILTER"  IN FOLDER "\Public Objects\REPORTS\Test1\Test2" FROM PROJECT  "Customer Analysis Module";

DELETE FILTER "Customer FILTER _ Edited" IN FOLDER "\Public Objects\REPORTS\Test1" FROM PROJECT  "Customer Analysis Module";

DELETE FOLDER "Test1" IN  "\Public Objects\REPORTS" FROM PROJECT "Customer Analysis Module";

/* User Outlines*/

CREATE USER "remanty" FULLNAME "Reginold Mano Antony" DESCRIPTION "Created by Reginold password" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "password" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER;
CREATE USER GROUP "USER GROUP Test" DESCRIPTION "My FIRST USER GROUP" LONGDESCRIPTION "Just a learning curve"  MEMBERS "remanty";

CREATE USER "freemonty" FULLNAME "Reginold Mano Antony" DESCRIPTION "Created by Reginold password" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "password" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER IN GROUP "User Group Test";

CREATE USER "testuser" FULLNAME "Reginold Mano Antony" DESCRIPTION "Created by Reginold password" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "password" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER;

ADD USER "testuser" TO GROUP "User Group Test";

CREATE USER GROUP "ALTER USER GROUP" DESCRIPTION "ALTER USER GROUP" LONGDESCRIPTION "USER GROUP FOR the freemonty";

ALTER USER "testuser" NAME "freemonty_reginold" PASSWORD "password"
FULLNAME "Monty Panesar" DESCRIPTION "login for Monty" LONGDESCRIPTION "Edited by reginold"
ALLOWCHANGEPWD FALSE ALLOWSTDAUTH TRUE CHANGEPWD FALSE
PASSWORDEXP NEVER
ENABLED IN GROUP "Alter User Group";


REMOVE USER " freemonty_reginold" FROM GROUP "USER GROUP Test";

LIST ALL PROPERTIES FOR USER "freemonty_reginold";

LIST ALL PROPERTIES FOR USER "freemonty";

LIST ALL PROPERTIES FOR USER "remanty";

LIST ALL PROPERTIES FOR USERS IN GROUP "User Group Test";

LIST ALL PROPERTIES FOR USERS IN GROUP "ALTER USER GROUP";

ALTER USERS IN USER GROUP "User Group Test" PASSWORD "password_1" DESCRIPTION "Changed the Password to password_1" LONGDESCRIPTION "Password change done on user request" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE
CHANGEPWD TRUE PASSWORDEXP IN 365 DAYS PASSWORDEXPFREQ 15 DAYS ENABLED GROUP "User Group Test";


LIST ALL PROPERTIES FOR USERS IN GROUP "User Group Test";

LIST INHERITED PRIVILEGES FOR USER "remanty";

LIST ALL PRIVILEGES FOR USER "remanty";

LIST GRANTED PRIVILEGES FOR USER "remanty";

DELETE USER GROUP "User Group Test";

DELETE USER GROUP "Alter User Group";

DELETE USER "remanty";

DELETE USER "freemonty";

DELETE USER "freemonty_reginold";

/* User Group Outlines*/

CREATE USER GROUP "USER GROUP PARENT" DESCRIPTION "USER GROUP parent" LONGDESCRIPTION "Just a learning curve";

CREATE USER GROUP "USER GROUP PARENT2" DESCRIPTION "USER GROUP parent" LONGDESCRIPTION "Just a learning curve";

CREATE USER GROUP "USER GROUP REGINOLD" DESCRIPTION "user group child" LONGDESCRIPTION "user group child" IN GROUP "USER GROUP PARENT";

CREATE USER GROUP "ALTER USER GROUP" DESCRIPTION "ALTER USER GROUP" LONGDESCRIPTION "USER GROUP FOR the Alter group command";

CREATE USER "Reginold" FULLNAME "Reginold Mano Antony" DESCRIPTION "Created by Reginold password" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "password" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER IN GROUP "USER GROUP REGINOLD";

CREATE USER "Feisal" FULLNAME "Mohammed Feisal" DESCRIPTION "Created by Reginold PASSWORD" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "PASSWORD" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER;

ADD USER "Feisal" TO GROUP "user group REGINOLD";

REMOVE USER "Feisal" FROM GROUP  "user group REGINOLD";

ADD USER "Feisal" TO GROUP "ALTER USER GROUP";

ALTER USER GROUP "USER GROUP REGINOLD" NAME "USER GROUP REGINOLD" DESCRIPTION "Alter group practice" LONGDESCRIPTION "Alter group practice Reginold" GROUP "USER GROUP PARENT2";

LIST MEMBERS FOR USER GROUP "USER GROUP REGINOLD";

LIST ALL PROPERTIES FOR USER GROUP "USER GROUP PARENT";

LIST USER GROUPS;

LIST USER GROUPS;

LIST ALL PRIVILEGES FOR USER GROUP "USER GROUP PARENT2";

REMOVE USER GROUP "USER GROUP REGINOLD" FROM GROUP "USER GROUP PARENT2";

DELETE USER GROUP "USER GROUP PARENT2";

DELETE USER GROUP "USER GROUP PARENT";

DELETE USER "Reginold";

DELETE USER "Feisal";

DELETE USER GROUP "user group reginold";

DELETE USER GROUP "alter user group";

/* User Profile Outlines*/

CREATE USER GROUP "Reginold CAM" DESCRIPTION "Reginold's User Group" LONGDESCRIPTION "Specifically for Reginold.";

CREATE USER  "reginolda" FULLNAME "Reginold Mano Antony" DESCRIPTION "login specifically designed for Reginold" LONGDESCRIPTION "password is blank" PASSWORD "" ALLOWCHANGEPWD FALSE ALLOWSTDAUTH TRUE CHANGEPWD FALSE PASSWORDEXP NEVER ENABLED IN GROUP "Reginold CAM";

CREATE USER  "delete" FULLNAME "Reginold Mano Antony" DESCRIPTION "login specifically designed for Reginold" LONGDESCRIPTION "password is blank" PASSWORD "" ALLOWCHANGEPWD FALSE ALLOWSTDAUTH TRUE CHANGEPWD FALSE PASSWORDEXP NEVER ENABLED IN GROUP "Reginold CAM";

CREATE USER PROFILE FOR USER "reginolda" IN FOLDER "\Profiles" FOR PROJECT "Customer Analysis Module";

CREATE USER PROFILE FOR USER "delete" IN FOLDER "\Profiles" FOR PROJECT "Customer Analysis Module";

LIST PROFILES FOR USER "reginolda" FOR PROJECT "Customer Analysis Module";
DELETE USER PROFILE "delete" FROM PROJECT "Customer Analysis Module";

/* Update Schema Outline*/

UPDATE SCHEMA REFRESHSCHEMA RECALTABLEKEYS RECALTABLELOGICAL RECALOBJECTCACHE FOR PROJECT "Customer Analysis Module";

/*Server Outlines*/

LIST ALL SERVERS;

LIST ALL PROPERTIES FOR SERVER "REGINOLDA-PC" PORT 34952 LOGIN "administrator" PASSWORD "";

STOP SERVER IN "REGINOLDA-PC" PORT 34952 LOGIN "Administrator" PASSWORD "";

START SERVER IN "REGINOLDA-PC" PORT 34952 LOGIN "Administrator" PASSWORD "";

RESTART SERVER IN "REGINOLDA-PC" PORT 34952 LOGIN "Administrator" PASSWORD "";

4 comments:

  1. Thanks for Shareing valuble data
    Regards,
    krishna.

    ReplyDelete
  2. Hi,
    I want to create a user through command manager whose properties should be that they should change password on first login
    i am not able to find it in the command manager template
    any idea?

    ReplyDelete
  3. Hi Akshat,

    Sorry for the late reply...The CHANGEPWD TRUE; parameter will allow you to change the password on your first logon.

    CREATE USER "freemonty" PASSWORD "password" FULLNAME "Monty Panesar" DESCRIPTION "Architect" ALLOWCHANGEPWD TRUE CHANGEPWD TRUE;

    ReplyDelete
  4. Hello Reginold,
    Thanks for the post. It is very helpful. Can you please provide a script to display emails for users created in Microstrategy? Also it would be really helpful if you can provide a sync script to authenticate into Microstrategy from an external application (any portal) and get users information.

    ReplyDelete