How to Create a CI from an existing asset?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2017 09:41 AM
Hi Community, we had a data import during our Asset implementation that created the Asset records without creating the corresponding CI's. This was related to bad mapping on the model information and has since been corrected so all new imports work as intended.
My question - how can I go back to the 100 or so asset records that do not have CI's and force the creation of the CI? Is there a simple way to do this, or would it be best for me to just delete the assets and re-import all of them?
Thanks,
Teri
- Labels:
-
Enterprise Asset Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-23-2017 06:49 AM
Teri: I believe what you could do also is export those CI records with a unique value (serial number I presume) and import them back in via a transform map.
1) Target table - alm_hardware
2) Coalesce - Serial Number
3) Map the CI reference field - Set
4) Map any other asset related fields that you need
This should create the asset (because it doesn't exist) and associate the existing CI to the asset (without creating a new one). In the business rule that creates the CI, there is a condition where CI is not NULL...so I am hoping that associating the CI at time of creation will work.
Thanks,
Akash