How do we tell which Asset Families are assigned to a given defined Asset Search
Release : 17.3
Component : ITAM - Other
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