Bulk Upload Asset and CI information

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2019 04:34 AM
Hi,
The customer site I am working on doesn't currently use any form of discovery, the cmdb has been updated in the past by bulk upload via spreadsheet.
We are about to do the same again due a large laptop refresh, these are new assets (and ci's) that don't currently exist, when I upload the asset data a related CI is automatically created as it should be, however as we are going to do this import, I would like to bring in some CI data as well, in particular Form factor and OS. Can I do this all via one spreadsheet, or is it going to have to be one import for asset data and then a second import for CI data?
Thanks in advance,
- Labels:
-
Enterprise Asset Management

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2019 04:40 AM
Hi,
you have to do it using two different import set for the following separate tables:
- Update Asset fields on the Asset [alm_asset] table
- Update CI fields on the Configuration Item [cmdb_ci] table
If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.
Thank you
Cheers
Alberto
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2019 04:43 AM
Hi John,
When we started populating CMDB and Asset I was told that best practice is to load CMDB first. This resulted in minimal Asset data being created as well. We are using the SCCM connector so it is possible that one of the scripts is doing the population. You might try doing a small upload to CMDB in a dev/persnoal instance to determine the right order for doing that load.
:{)
:{)
Helpful and Correct tags are appreciated and help others to find information faster
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-13-2019 02:07 PM
John: What kind of data are you populating in the asset? The previous post about populating the CI (in this case cmdb_ci_computer) will result in the asset being created as well. If some of the fields that will be populated also exist on the CI, then the sync process should populate both (also, same would be from the asset to the CI as well).
The other possibility is to populate in the transform map as an onAfter script. You will need the target.ci value and query the computer table.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-14-2019 01:03 AM
Thanks for the reply.
We are concentrating on desktops, laptops, mobile and desk phones at the minute.
The data we are populating in the asset is: assigned_to, location, department, purchased date, po number, invoice number, lease number (if leased), status, stockroom, cost, request line, vendor, warranty expiration.
The data we are populating for the CI is: form factor, operating system.
As the majority of the data relates to the assets, we have decided to do a single bulk upload of assets and then manually update the CI's.
Do you happen to have an example of using a transform map and an onAfter script, as that may come in useful in the future?