MicroStrategy ONE

List Subscriptions statement

List all subscriptions for various criteria.

Copy 
LIST [ALL] SUBSCRIPTIONS FOR CONTENT "report_or_document_name" IN FOLDER "location_name" FOR PROJECT "project_name";
Copy 
LIST [ALL] SUBSCRIPTIONS FOR PROJECT "project_name";
Copy 
LIST [ALL] SUBSCRIPTIONS FOR DELIVERYTYPE (EMAIL | FILE | PRINT | HISTORYLIST | CACHE | MOBILE )) FOR PROJECT "project_name";
Copy 
LIST [ALL] SUBSCRIPTIONS FOR OWNER "user_name" FOR PROJECT "project_name";
Copy 
LIST [ALL] SUBSCRIPTIONS FOR SCHEDULE "schedule_name" FOR PROJECT "project_name" ;
Copy 
LIST [ALL] SUBSCRIPTIONS FOR RECIPIENTS (CONTACT "contact_name" | ADDRESS "address_name" | CONTACTGROUP "contact_group_name" | USER "user_name") FOR PROJECT "project_name";
Copy 
LIST [ALL] SUBSCRIPTIONS FOR NAME "subscription_name"  FOR PROJECT "project_name";

where:

  • report_or_document_name is the name of the report or document

  • location_name is the name of the where the report or document resides

  • project_name is the name of the project where the report or document resides

  • user_name is the name of the user

  • schedule_name is the name of the schedule

  • contact_name is the name of the contact

  • address_name is the name of the address

  • contact_group_name is the name of the contact group

  • subscription_name is the name of the subscription

  • subscription_GUID is the subscription ID

ResultSet Columns

LIST ALL SUBSCRIPTIONS FOR PROJECT

  • CONTENT: The content of the subscription, returned as a string.

  • GUID: The GUID of the subscription, returned as a string.

  • NAME: The name of the subscription, returned as a string.

  • OWNER: The owner of the subscription, returned as a string.

  • RECIPIENT_RESULTSET: A ResultSet containing a list of subscription recipients and related details.

    • RECIPIENT: The name of the recipient, returned as a vector of type string.

    • RECIPIENT_ADDRESS: The address of the recipient, returned as a vector of type string.

    • RECIPIENT_TYPE: The type of recipient, such as "USER". Returned as a vector of type string.

  • SCHEDULE: The schedule of the subscription, returned as a string.

  • SUBSCRIPTION_TYPE: The type of the subscription, such as "Mobile". Returned as a string.