Need to know where the notification method fields are located in the database

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

Where the notification method fields for contacts are located in the database?

Environment

Release : 17.3

Resolution

The notification methods are saved in the usp_contact table, fields: 

c_cm_id1 (Low)

c_cm_id2 (Normal)

c_cm_id3 (High)

c_cm_id4 (Emergency)

The values set in those fields are foreign keys from the values stored in the ct_mth table, id field.

Example:

 

It's not recommended to update the values directly from the database. It's recommended to use pdm_load for this purpose. Refer to the following link: pdm_load--Add, Update, and Delete Database Records