Transform map for cmdb_ci_computer table

Community Alums · ‎02-15-2022

Hi,

I have a transform map where serial_number is the coalesce. But we need to avoid duplicates to create based on a custom field "corporate_number. So when importing the records, we need to make sure there is no record that has the same "corporate_number". If there is one, it should not update the record and throw an error.

How can I achieve this?

For example,

Serial_number corporate_number

1234567 123

7896325 123

We don't want records like this in CMDB.

Please assist

Thank you

Community Alums · ‎02-15-2022

Write an onBefore transform script. In the script glide record the using corporate number. If there is any entry that matches with corporate_number you can set ignore to true. (function transformRow(source, target, map, log, isUpdate) { // Add your code here var gr = new GlideRecord("cmdb_ci_computer"); gr.addQuery("corporate_number", source.corporate_number); gr.query(); if (gr.next()) { ignore = true; error=true; error_message='Corporate number duplicate.'; } })(source, target, map, log, action==="update");

View solution in original post

Community Alums · ‎02-16-2022

Thank you so much

cassieb_ · ‎02-16-2022

I would also suggest using the CI Class Manager to create an Identification rule based on the criteria you need to identify if a CI is to be updated or created for the CI being imported.