How to Remove Future Statuses from Workplace

If you have added Future Statuses to Workplace (such as through Outlook Sync. or Exchange Sync.), Workplace is not currently able to delete all these statuses automatically. A user may open the Workplace calendar, right-click each event, and delete each individual event if necessary. However, this would only be useful for small amounts of future statuses or small amounts of employees. If you would like to remove all future statuses at once, this can be done on the back end of Workplace.

Note: Because this requires you to edit your Workplace database, this feature is only available to Customer-Hosted customers. Also, because you are editing the Workplace database, you must be very careful to not change any other settings or database tables that may impair Workplace’s functionality. If you are a Workplace-Hosted customer who would like to add colors OR if you are a Customer-Hosted customer who would like Workplace’s support team to take care of this database work for you, feel free to purchase a Block of Support. Workplace’s support team can do all the necessary work for you over a web conference! For details, visit our Professional Services Guide.

To edit the future statuses in your Workplace database, follow these instructions:

1. On the server machine with your Workplace database, open SQL Server Management Studio.
2. Browse to your Workplace database (the default name is SolutionSavant).
3. Right-click the database and select New Query.
4. You will now be able to type queries into the Workplace Database. Be aware that all changes made to the database are permanent. It is recommended that you make a backup of your database before running any queries.

You have a couple of options when deleting future statuses. Depending on which future statuses you would like to delete, run the following queries on the Workplace database.

Delete ALL Future Statuses

DELETE FROM FutureStatus

Delete Only Future Statuses that haven’t occurred yet

DELETE FROM FutureStatus WHERE AutoReturnProcessed = 0

Delete ALL Future Statuses that are synchronized (but not manually added statuses)

DELETE FROM FutureStatus WHERE ISNULL(OutlookEntryID, 0) <> ‘0’ AND AutoReturnProcessed = 0

View a list of all Future Statuses

SELECT * FROM FutureStatus