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

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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'

Environment

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