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.
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
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'