Restore subscriptionstatus

When an user has mistakenly updated the subscriptionstatus, use this procedure to restore the previous state.

• Right click on the subscriptionfolder and click "Report".
  An excel file is created. The latest sheet contains the historical changes to each item in the folder. The column "PreviousStatusCode" contains a formula that calculates the previous status.

• Filter on the user and/or date to filter the changes that was made by the user

• Filter on the CurrentStatus column on the wrongly assigned status
  This has to be done to filter out changes that have been executed after the user has made the wrong change

• Copy the result to a new sheet. Use Paste Values to replace the calculated with the result of the formula

  • Rename the column ObjectID to CM_ID
  • Rename the column PreviousStatusCode to Status
  • Remove all the other columns

The end result is a sheet with two columns, column A = CM_ID and column B = Status

• Save the sheet to a new file

• Open CM, goto Configuration, CRM Configuration and click on the tab Import

• Select the file with the new status

• Select importtype Update

• Select Always overwrite

• Click on Import

• Click Refresh until the import is finished

Check the result in the subscriptionfolder