search cancel

Identifying table and field in backend database

book

Article ID: 237594

calendar_today

Updated On:

Products

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

Issue/Introduction

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:

Environment

Release : 17.3

Component :  CA IT Asset Manager

Resolution

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:

 

 

Attachments