Remove Unwanted Prefix from Serial Number Discovered by SNOW Software

[Service now11]

Hi,

I am facing an issue with the serial number in the computer table that is generated from SNOW Software. These records are integrated with the SNOW tool. This is an incoming connection from SNOW to ServiceNow. The BIOS serial number in SNOW Software is 4206f0ba74195be736d078b6133fd839. However, it is being reflected as VMware - 4206f0ba74195be736d078b6133fd839 in ServiceNow. I do not want "VMware" in the serial number. I want the exact values from the SNOW tool. So how to solve this. I am writing transform script for this. I don't know this will help or not. Kindly provide me a solution to solve this.

Below is the transform map script:

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

    if (source.u_biosserialnumber.indexOf('VMware-') === 0) {

        // Remove the 'VMware - ' prefix

        target.serial_number = source.u_biosserialnumber.replace('VMware-', '');

    } else {

        // If no prefix, just copy the source serial number

        target.serial_number = source.u_biosserialnumber;

    }

})(source, target, map, log, action == "update");

Thanks.

[Robbie]

Hi @Service now11 ,
 
No worries. Did you see my other response? Thinking out loud, based on the fact your script runs as desired (tested via a background script), have you tried applying this log in a mapped field?
Essentially, when you map the field similar to how all other fields are mapped you can check the 'Use source script' checkbox and apply the logic there.
 
To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[Robbie]

Hi @Service now11,

Thinking out loud, based on the fact your script runs as desired (tested via a background script), have you tried applying this log in a mapped field?

Essentially, when you map the field similar to how all other fields are mapped you can check the 'Use source script' checkbox and apply the logic there.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.

Thanks, Robbie