Choice value for Operating System field of cmdb_ci_computer table is getting created with bad characters through integration by Service Graph Connector for Active Directory - Support and Troubleshooting

Choice value for Operating System field of cmdb_ci_computer table is getting created with bad characters through integration by Service Graph Connector for Active Directory Issue When the SGC - Active Directory is running, it is creating bad characters in the choice field of the cmdb_ci_hardware table.

Release All Release

Cause There is an OOB Script Action with the below script:

function(batch, output) { var utils = new sn_sec_sgc_ad.SgcADUtils(); for (var i = 0; i try{ var input = batch[i].input; if(!gs.nil(input)){ output[i] = utils.checkAndDecodeBase64String(input); }else{ output[i] = ''; } }catch(err){ gs.error('[SGC-AD] Exception: '+err); } } })(batch, output);

We run the same script in the background scripts and found that this script is creating the Special/Bad charcaters Resolution The below Script Operation is responsible for the Special Character.

https://instance.service-now.com/sys_rte_eb_script_operation.do?sys_id=79a0bd03c3503510f53ef1067d40ddc0&sysparm_view=&sysparm_domain=null&sysparm_domain_scope=null&sysparm_record_row=1&sysparm_record_rows=3&sysparm_record_list=source_sys_rte_eb_field.nameCONTAINSopera%5esys_rte_eb_definition%3db5ace5cbc3103510f53ef1067d40dd52%5eORDERBYorder

We reached the dev team regarding the script;

They updated the script as below;

[code]

Once the script is updated, please reprocess the SGC - Import Sets

We can see that after reprocessing, after updating the script we can see that no special character is getting created.