Unlocking Locked Messages in Inbox

From support-works
Revision as of 17:29, 24 March 2016 by Deenc (talk | contribs)
Jump to navigation Jump to search

To Unlock Messages


STOP swSQLServer and Related Services

Run the Interactive SQL utility on the Supportworks Server and type the following:

 use sw_messagestore;


 update shared__helpdesk_mailbox set msglockedby = where msglockedby !=;
 where ‘shared__helpdesk_mailbox’ should be replaced by your mail box name

Start all Supportworks services.

Risks / Recommendations: 1. We advise this whole process to be tested on test Server first before migrating to the Production Server 2. Take the backup of all files before starting this exercise 3. Testing is suggested once you carry out each step