TMACUL

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

Blog Post created by TMACUL Champion on Mar 11, 2016

select t.name as tenant_name, grp.last_name as group_name, analyst.last_name, grpmem.notify_flag

from grpmem

inner join ca_tenant as t on t.id = grpmem.tenant

inner join ca_contact as grp on grp.contact_uuid = grpmem.group_id

inner join ca_contact as analyst on analyst.contact_uuid = grpmem.member

 

know_more.jpg

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

Outcomes