search cancel

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

book

Article ID: 20773

calendar_today

Updated On:

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: