MicroStrategy - Managing scheduled reports with Command Manager

Command Manager

LIST ALL SUBSCRIPTIONS FOR DELIVERYTYPE EMAIL FOR PROJECT "QPrecision";
LIST SUBSCRIPTIONS FOR OWNER "<login_name>" FOR PROJECT "<project_name>";
LIST SUBSCRIPTIONS FOR SCHEDULE "<schedule_name>" FOR PROJECT "<project_name>";
LIST SUBSCRIPTIONS FOR RECIPIENTS 
    (CONTACT "<contact_name>"  | ADDRESS "<address_name>" | CONTACTGROUP "<contact_group_name>" | USER "<login_name>" )
    FOR PROJECT "<project_name>";
LIST SUBSCRIPTIONS FOR NAME "<subscription_name>" FOR PROJECT "<project_name>";

How can we trigger a particular subscription?

TRIGGER SUBSCRIPTION GUID F4475B4842D3E718E18DB8AE467E09C7 FOR PROJECT "MicroStrategy Tutorial";
TRIGGER ALL SUBSCRIPTIONS FOR SCHEDULE 'scheduleName' FOR PROJECT 'projectName';

How can we trigger all subscription for a particular project?

TRIGGER ALL SUBSCRIPTIONS FOR PROJECT "MicroStrategy Tutorial";

How can we list all subscriptions for a particular report?

LIST [ALL] SUBSCRIPTIONS 
    FOR CONTENT ("<report_or_document_name>"  IN FOLDER "<location_name>" | GUID <report_or_document_guid>) 
    FOR PROJECT "<project_name>";

How can we list all subscriptions for a particular project?

LIST [ALL] SUBSCRIPTIONS 
    FOR PROJECT "<project_name>";

How can we list all subscriptions for a particular delivery type?

LIST [ALL] SUBSCRIPTIONS 
    FOR DELIVERYTYPE (EMAIL | FILE | PRINT | HISTORYLIST | CACHE | MOBILE ) 
    FOR PROJECT "<project_name>";

How can we list all subscriptions for a particular user?

LIST [ALL] SUBSCRIPTIONS 
    FOR OWNER "<login_name>" 
    FOR PROJECT "<project_name>";

How can we list all subscriptions for a particular schedule?

LIST [ALL] SUBSCRIPTIONS 
    FOR SCHEDULE "<schedule_name>" 
    FOR PROJECT "<project_name>";

How can we list all subscriptions for a particular recipient?

LIST [ALL] SUBSCRIPTIONS 
    FOR RECIPIENTS 
        (
            CONTACT "<contact_name>"  | 
            ADDRESS "<address_name>" | 
            CONTACTGROUP "<contact_group_name>" | 
            USER "<login_name>" | 
            GROUP "<user_group_name>"
        ) 
    FOR PROJECT "<project_name>";

How can we list all subscriptions for a particular subscription name?

LIST [ALL] SUBSCRIPTIONS 
    FOR NAME "<subscription_name>" 
    FOR PROJECT "<project_name>";

How can we create history list subscriptions?

CREATE HISTORYLISTSUBSCRIPTION "My first history list subscription" 
    FOR OWNER "demo" 
    SCHEDULE "Books Closed" 
    USER "demo" 
    CONTENT "Customer Income Analysis" IN FOLDER "\Public Objects\Reports\Subject Areas\Customer Analysis"  
    IN PROJECT "Microstrategy Tutorial" 
    OVERWRITEOLDERVERSION TRUE  
    HISTORYLINKURL "samplehistorylinkurl" 
    HISTORYLINKWEBSERVER "samplehistorywebserver";
CREATE HISTORYLISTSUBSCRIPTION "PromptedSubscription3' 
    FOR OWNER "Administrator" 
    SCHEDULE "Books Closed" 
    USER "Administrator" 
    CONTENT "prompt3" 
    IN FOLDER "Public Objects\Reports" 
    IN PROJECT "Microstrategy Tutorial" 
    PROMPT "Elements of Region" 
    ANSWER "8D679D4B11D3E4981000E787EC6DE8A4:1"

How can we alter a history list subscription?

ALTER HISTORYLISTSUBSCRIPTION "My first history list subscription" 
    NAME  "My altered subscription" 
    SCHEDULE "Monday Morning" 
    USER "demo" 
    CONTENT "Yearly Revenue Growth by Customer Region" IN FOLDER "\Public Objects\Reports\Subject Areas\Customer Analysis"  
    IN PROJECT "Microstrategy Tutorial" 
    OVERWRITEOLDERVERSION FALSE ;

How can we create email subscriptions?

CREATE EMAILSUBSCRIPTION "My first email subscription" 
    FOR OWNER "demo" 
    SCHEDULE "Books Closed"  
    CONTACT "Contact1" 
    CONTENT "Customer Income Analysis" IN FOLDER "\Public Objects\Reports\Subject Areas\Customer Analysis"  
    IN PROJECT "Microstrategy Tutorial"  
    DELIVERYFORMAT PDF 
    COMPRESSCONTENTS ZIPFILENAME "zip.txt"  
    EXPIRATIONDATE 05/11/2007 
    FILENAME "MySubscription"  
    SUBJECT "My First Subscription" 
    MESSAGE "My First Message" 
    INCLUDELINK TRUE 
    SENDPREVIEWNOW TRUE 
    SENDTOHISTORYLIST TRUE 
    INCLUDEDATA TRUE;

How can we alter email subscription?

ALTER EMAILSUBSCRIPTION "My first email subscription" 
    OWNER "demo" 
    SCHEDULE "Monday Morning" 
    CONTACT "Contact2" 
    CONTENT "Yearly Revenue Growth by Customer Region" IN FOLDER "\Public Objects\Reports\Subject Areas\Customer Analysis" 
    IN PROJECT "MicroStrategy Tutorial" 
    DELIVERYFORMAT PDF 
    COMPRESSCONTENTS ZIPFILENAME "zip.txt" 
    ZIPFILEPASSWORD "password" 
    FILENAME "Some Subscription" 
    SUBJECT "My altered subscription" 
    MESSAGE "My alter message" 
    INCLUDELINK FALSE 
    SENDPREVIEWNOW FALSE 
    INCLUDEDATA FALSE;

How can we add a user to a subscription?

ADD USER "demo" 
    TO SUBSCRIPTION GUID F4475B4842D3E718E18DB8AE467E09C7 
    FOR PROJECT "Microstrategy Tutorial";

How can we add a contact to a subscription?

ADD CONTACT "contact1" 
    TO SUBSCRIPTION GUID F4475B4842D3E718E18DB8AE467E09C7 
    FOR PROJECT "Microstrategy Tutorial";

How can we remove a user from a subscription?

REMOVE USER "demo" 
    FROM SUBSCRIPTION GUID F4475B4842D3E718E18DB8AE467E09C7 
    FOR PROJECT "Microstrategy Tutorial";

How can we delete all subscriptions for a particular project?

DELETE ALL SUBSCRIPTIONS FROM PROJECT "MicroStrategy Tutorial";

How can we delete all email subscriptions for a particular project?

DELETE ALL SUBSCRIPTIONS 
    FOR DELIVERYTYPE EMAIL 
    FROM PROJECT "MicroStrategy Tutorial";

How can we delete all subscription for a particular user?

DELETE ALL SUBSCRIPTIONS 
    FOR OWNER "demo" 
    FROM PROJECT "MicroStrategy Tutorial";

How can we list all properties for a particular subscription?

LIST ALL PROPERTIES 
    FOR SUBSCRIPTION GUID F4475B4842D3E718E18DB8AE467E09C7 
    FOR PROJECT "MicroStrategy Tutorial";

How can we delete a particular subscription?

DELETE SUBSCRIPTION GUID F4475B4842D3E718E18DB8AE467E09C7 FROM PROJECT "MicroStrategy Tutorial";

How can we delete all subscriptions for a particular report?

DELETE [ALL] SUBSCRIPTIONS 
    FOR CONTENT ("<report_or_document_name>" IN FOLDER "<location_name>" | GUID <report_or_document_guid>) 
    FROM PROJECT "<project_name>";

How can we delete all subscriptions for a particular project?

DELETE [ALL] SUBSCRIPTIONS 
    FROM  PROJECT "<project_name>";

How can we delete all subscriptions for a particular delivery type?

DELETE [ALL] SUBSCRIPTIONS 
    FOR DELIVERYTYPE (EMAIL | FILE | PRINT | HISTORYLIST | CACHE | MOBILE ) 
    FROM PROJECT "<project_name>";

How can we delete all subscriptions for a particular user?

DELETE [ALL] SUBSCRIPTIONS 
    FOR OWNER "<login_name>" 
    PROJECT "<project_name>";

How can we delete all subscription for a particular schedule?

DELETE [ALL] SUBSCRIPTIONS 
    FOR SCHEDULE "<schedule_name>"  
    FROM PROJECT "<project_name>";
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License