Is there a way to programmatically insert data into the cmdb_software_instance table such that ServiceNow will identify (e.g. with the IRE API) the records so that I can create records without having to worry about duplicates being created?
My goal is to take a .csv list of servers found in a cloud-application's portal (e.g. an anti-virus application) and send that list to ServiceNow, so that the server CI can be linked to the Software (cmdb_ci_spkg) record for that application. I do not want to manually upload data through the ServiceNow UI and the uploaded list will contain (at least) some of the same servers everyday.
I tried creating an import set and transform map to map the server's name (source) to the CI name (cmdb_ci...) and to identify the company sys_id, but when I uploaded the same file twice and ran the transform, I got the same records twice.
Thanks.
