Fix Script to populate Fields

[JamesT-1]

I'm attempting to create a fix script that will populate two new fields on the incident form for all existing incidents.  The two fields (asset tag and serial number) are both dependent on the value of the Configuration item field. With the newly created onChange Client script these two new fields will auto populate with their respective values from the asset chosen in the Configuration item. Below is what I have so far that is not working. Can anyone provide some insight? Thanks.

var grIncident = new GlideRecord('incident');

grIncident.query();

while(grIncident.next()){

    gr.u_inc_asset_tag = gr.cmdb_ci.asset_tag;

    gr.u_inc_serial_number = gr.cmdb_ci.serial_number;

    gr.setWorkflow(false);

    gr.update();

}

[Brad Bowman · Accepted solution]

Your GlideRecord is instantiated as grIncident, but you are using gr. in the while loop.  Change all of these appearances to grIncident, and you should be closer.

[JamesT-1]

I see. Now the script is doing the opposite. It's emptying the value of the new fields for all incidents.

[Debasis Pati]

Hey James,

It's might be the reason that your ci fileds like asset_tag and serial_number might be differnt or the ci's doesn't have these values in the configuration_item table.
Just double check.

Regards,
Debasis

[Brad Bowman]

Do the incidents with the cleared fields have a cmdb_ci populated, and does that CI record have a asset_tag and/or serial_number populated?  Are your custom fields the same Types as the two fields on the CI table/record?