How can I update Asset costs with the IT Asset Manager Data Importer.

Document ID : KB000011168
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How can I update Asset costs with the IT Asset Manager Data Importer.

Answer:

Steps to update an Asset cost record via the ITAM Data Importer:

  1. Set the import tool to automatically create secondary lookup objects from the Tools-advanced settings->check the box to automatically create secondary lookup objects.

  2. Run the following sql statement against the mdb to enable the costid field as a destination field.

    UPDATE arg_attribute_def
    SET api_updatable = '1', api_searchable = '1'
    WHERE (attribute_label = 'Cost Id') AND (class_name = 'cost')

    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.

  3. Extract the costid from the database.

    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

  4. Export the results to csv.

  5. Incorporate the costid into the source import csv file.

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