How to populate CMDB tables using CSV file data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2024 01:24 AM
We have a tool that works just like ServiceNow's eDiscovery on an Agency’s data centers to collect server names and software packages installed and then report on this data i.e. it's able to provide us with a CSV file of that information. We'd like to replace eDiscovery to cut costs and populate the ServiceNow tables cmdb_ci_computer and cmdb_ci_appl with the information from the CSV files.
Can someone please tell me how this can be done using System Import - Load Data? The upload should ONLY CREATE new records if no similar record is found. If a similar record exists, then it should only update its version number and installed date.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2024 02:19 AM
1) Create data source
2)Install IH ETL
3)Add the CSV on data source
4)Create new ETL using the data source.
IH ETL call IRE so it will take care of the duplication and other issues.