how to mass update the workshit notification method in the contacts

Document ID : KB000117629
Last Modified Date : 16/10/2018
Show Technical Document Details
Question:
How to mass update the workshit notification method in the contacts?
Environment:
Service Desk Manager 17.x
Answer:
For this, they could update directly MDB d/b (or using pdm_load / pdm_userload).

Example of SQL query to update Contact table.

update usp_contact set c_ws_id1="wrkshft:4602", c_ws_id2="wrkshft:4602", c_ws_id3="wrkshft:4602", c_ws_id4="wrkshft:4602", where c_ws_id2 is NULL

IMPORTANT: It is always recommend to perform a database backup before running any updates. Please ask DBA to do a mdb backup before.

Then, to reflect the modifications without recycling SDM service, you can refresh Contact table by running below command:

pdm_cache_refresh -t ca_contact