Determining Asset Families Attached to an Asset Search
search cancel

Determining Asset Families Attached to an Asset Search

book

Article ID: 236287

calendar_today

Updated On:

Products

CA IT Asset Manager Asset Portfolio Management ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management

Issue/Introduction

How do we tell which Asset Families are assigned to a given defined Asset Search

Environment

Release : 17.3

Component : ITAM - Other

Resolution

To determine the Asset Families that are assigned to a given Asset Search, one will need to run the following SQL statement in the backend MDB database:

SELECT ca_resource_family.id, ca_resource_family.name FROM ca_resource_family where ca_resource_family.id IN 
(SELECT al_subtype_attribute_def.attribute_value FROM al_subtype_attribute_def where al_subtype_attribute_def.subtype_id IN
 (SELECT al_search_subtype_def.subtype_id FROM al_search_subtype_def where al_search_subtype_def.search_id IN
    (SELECT al_search_def.search_id FROM al_search_def where al_search_def.title = 'XXXX')
 )
)

Replace XXXX with the name of the given Search.  

The above query lists from the following tables:
ca_resource_family:  list of resource families (Asset Families)
al_subtype_attribute_def:  Subtype Attribute Definitions
al_search_subtype_def:  Search Subtype Definitions
al_search_def:  Search Definitions