# 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 changeCopy 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