Background script to copy existing field to new field within the same table?

[averyckrauss]

I am attempting to update all user records to copy the current usernames (user_name) to a new blank field (u_old_user_id) in the same table (sys_user).  The script below seems to work to update the records, however when run as a background script it is only updating a single user record instead of all users in the sys_user table.  Is there a mistake in the script that is causing it to only update a single record?

var gr = new GlideRecord('sys_user');

gr.query();

while (gr.next()) {

var x = gr.getValue('user_name');

if (x) {

gr.setValue('u_old_user_id', x);

gr.update();

}

}

[Sagar Pagar]

Hi @averyckrauss,

Filter means the condition/query, to get perform the CRUD operations.

Example: active=true

If my response helps to solve your issue. Kindly mark it as helpful & correct. It will be helpful for future readers.
Thanks,
Sagar Pagar