You know that contacts in Service Desk needs to be define with a "Notification method", in this case i'm using the e-mail. I was looking in the database where this option is stored for the contacts.
Do you know where's in the database? Or do you know a way i can set this option for ALL my contacts and doesn't have to do it manually one by one.
notification methods table called ct_mth,
contatct's notification methods stored in usp_contact table, attributes (for low, normal, hight and emergency) called c_cm_id1, c_cm_id2, c_cm_id3, c_cm_id4.
I want to warn that vendor do not recommend to update data using direct SQL queries,
you can use pdm_deref for this task,
useful doc with example could be found here: DEREF - pdm_deref - Everthing do you need know by TMACUL
CA SDM - MS SQL Query Contact x Notification Method
Thanks a lot!!