Clarity Service Management

CA SDM - MS SQL Query Contact x Notification Method 

04-01-2016 09:03 AM

aaa

 

select cnt.contact_uuid, cnt.userid, cnt.last_name, m1.sym as method1,  m2.sym as method2,  m3.sym as method3,  m4.sym as method4

from ca_contact as cnt

left join usp_contact as usp on cnt.contact_uuid = usp.contact_uuid

left join ct_mth as m1 on usp.c_cm_id1 = m1.id

left join ct_mth as m2 on usp.c_cm_id2 = m2.id

left join ct_mth as m3 on usp.c_cm_id3 = m3.id

left join ct_mth as m4 on usp.c_cm_id4 = m4.id

 

 

know_more.jpg

CA SDM - MS SQL - Script select Group Member (Analyst x Group)

CA SDM - MS SQL - Script to count member group

CA SDM - MS SQL Query para visualizar os Logins realizados na solução

CA SDM Cleaning duplicate contacts - MS SQL

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.