Workspace 'My Lists' are all missing

[Dave Wolfe]

We just recently changed all the email/user names in all of our systems, including ServiceNow. When we changed the user name,  the Workspace the 'My Lists' section apparently is tied to the old user name behind the scenes, because all of those lists are now missing. I confirmed that was the source in a sub-production system. I know that the lists are stored in the sys_ux_my_list table, but apparently that table in not editable. Is there any way to change the userID on all the entries of that table as opposed to having to rebuild every list by hand. 

[raul_canales]

I assume you have the Admin role in your instance, so you should be able to edit the Created by field in List view of the sys_ux_my_list table. I just had the same situation happen to one of our users, and I was able to filter their lists by the Created by field and update it to their new User ID. This then brought back their lost lists. The downside for you is that you have many users, not just one.

[RaghavSh · Accepted solution]

@Dave Wolfe Can't you update the sys_created_by field with fix/background script. 

You can use GlideRecordObject.autoSysFields(false); while updating so that the created by field is not overwritten.

Please mark the answer correct/helpful accordingly.

[RaghavSh]

@Dave Wolfe did this work for you?

[Edward Rosario]

Did you check

The lists are configured on the table: UX List Menu Configuration

1. In your application navigator type: sys_ux_list_menu_config.list