Adding and updating Costs with the ITAM DATA Importer.

book

Article ID: 52244

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

New Costs:

Process new cost inserts in one batch without lookups. This will create individual costs without attention to duplicates.

Updating Costs:

Process updates to costs in another batch while using the cost id (created when the costs were added) as a lookup key.

Note: The costid must be known to update the cost record. The costid is an integer value in the arg_costdet table of the mdb.

To extract the costid from the database.

  1. Run an advance search in the UAPM GUI choosing the following fields to display in the results. All of these fields are not needed, but they will help identify the cost records.

    asset name
    asset serial number
    asset cost cost type value
    asset cost Begin date
    asset cost Unit amount
    asset cost cost id

  2. Export the results to csv.

  3. Incorportate the costid into the source import csv file.

  4. Use the costid as a lookup key in the mapping.

Environment

Release: UAPMAC990JPP-11.3-Asset Portfolio Management-Asset Configuration
Component: