Difference between revisions of "Unlocking Locked Messages in Inbox"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
| − | update shared__helpdesk_mailbox set msglockedby ='' where msglockedby !=''; | + | update shared__helpdesk_mailbox set msglockedby =<nowiki>'' where msglockedby !=''</nowiki>; |
| − | where ‘shared__helpdesk_mailbox’ should be replaced by your mail box name | + | |
| + | where ‘shared__helpdesk_mailbox’ should be replaced by your mail box name | ||
Start all Supportworks services. | Start all Supportworks services. | ||
Latest revision as of 10:30, 30 January 2018
To Unlock Messages
STOP SwSQLServer and Related Services and take a backup of the sw_messagestore database. Thereafter restart the Swsql server service.
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