What tables can be accessed to view the definition of a given extended field for a given Asset Family.
Release : 17.3
Component : IT Asset Manager/Asset Portfolio Manager
Consider an extended field definition that applies for the Asset Family "Computer".
The following SQL queries can be executed to view internal backend database information about the given extended fields:
Select * from arg_extension_rule_def where ext_table_name = 'ucapme_computer'
Select * from arg_field_def where table_name = 'ucapme_computer'
Select * from arg_class_def where table_name = 'ucapme_computer' OR class_name = 'ucapme_computer'
Select * from arg_attribute_def where table_name = 'ucapme_computer' OR class_name = 'ucapme_computer'
In addition, table ucapme_computer can also be accessed alongside ca_owned_resource and usp_owned_resource tables to view the content of a given asset that belongs to the Asset Family "Computer".
Direct DB manipulation is not advised for any of the Service Management products unless directed by Support. The above is provided for informational purposes.