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

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

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 there could be other contacts who may have the data partition from their associated roles and this doc does not cover that.

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component:

Resolution

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

   Switch #### for the id number from step 1.