How to get a list of contacts who are associated with a certain data partition directly on the contact record?

Document ID : KB000020773
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

This technical document gives Service Desk Manager administrators a way to get a list of contacts who are associated with certain data partition directly.

This task can't be achieved from web interface but sometimes becomes necessary for administrators.

Please also note that therecould be other contacts who may have the data partition from their associated roles and this doc does not cover that.

Solution:

  1. From Service Desk Manager server, run the following command to get the data partition id:
    pdm_extract -f "select id from Domain where sym='xxxxx'"where xxxxx is the name of the data partition. Let's say the id is yyyyy

  2. From a DBMS query tool, run the following statement to get a list of contacts who are associated with this data partition directly:
    select ca_contact.first_name, ca_contact.last_name, ca_contact.userid from ca_contact inner join usp_contact on ca_contact.contact_uuid=usp_contact.contact_uuid where usp_contact.c_domain='yyyyy'