Extended field definition storage in ITAM MDB database

book

Article ID: 224214

calendar_today

Updated On:

Products

CA Service Management - Asset Portfolio Management

Issue/Introduction

What tables can be accessed to view the definition of a given extended field for a given Asset Family.

Environment

Release : 17.3

Component :  IT Asset Manager/Asset Portfolio Manager

Resolution

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".  

Additional Information

Direct DB manipulation is not advised for any of the Service Management products unless directed by Support.  The above is provided for informational purposes.