MicroStrategy ONE

Delete all subscriptions statement

Delete all subscriptions for a user, report, document, project, type of delivery in a project, owner, or schedule.

Copy
DELETE [ALL] SUBSCRIPTIONS FOR (USERuser_name| 
 CONTACTcontact_name| CONTACTGROUPcontact_group_name| ADDRESSaddress_name) FROM PROJECTproject_name;
Copy
DELETE [ALL] SUBSCRIPTIONS FOR CONTENT (report_or_document_name IN FOLDER location_name) | GUID report_or_document_guid) FROM PROJECTproject_name;
Copy
DELETE [ALL] SUBSCRIPTIONS FROM PROJECTproject_name;
Copy
DELETE [ALL] SUBSCRIPTIONS FOR DELIVERYTYPE (EMAIL 
 | FILE | PRINT | HISTORYLIST| CACHE | MOBILE) FROM PROJECTproject_name;
Copy
DELETE [ALL] SUBSCRIPTIONS FOR OWNERuser_nameFROM 
 PROJECTproject_name;
Copy
DELETE [ALL] SUBSCRIPTIONS FOR SCHEDULEschedule_nameFROM PROJECTproject_name;

where:

  • user_name is the name of the user

  • contact_name is the name of the contact

  • contact_group_name is the name of the contact group

  • address_name is the name of the address

  • report_or_document_name is the name of the report or document

  • report_or_document_guid is thereport or document ID

  • schedule_name is the name of the schedule

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