ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Identifying table and field in backend database


Article ID: 237594


Updated On:


CA Service Management - Asset Portfolio Management CA IT Asset Manager Asset Portfolio Management CA IT Asset Manager


How to tell what table/field matches up to a given field in the ITAM GUI. 

Example:  The cost tab for a given asset.  We will identify which table/field is the "Unit Amount" field tied:


Release : 17.3

Component :  CA IT Asset Manager


Login to ITAM as a System Administrator user (uapmadmin)

Step 1:  On the Asset Tab, click on the "ON" link, next to "Configure". 

Step 2:  Click on the "Costs" link on the left side of menu.

Step 3:  On the "Unit Amount" field, click on the first icon to display the field information.

You will see a pop up that displays field/table information: