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