How to set the list layout for all the users overriding individual user's personalize columns?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2019 08:22 AM
Hi,
We'd want list layout definition to override an user's personalization.
We're aware that Configure->List layout and arranging the columns would accomplish this. However, it requires an user to manually set "Reset to column defaults", if I'm not wrong.
Is there anyways to define the columns in list layout?
Thanks.
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2019 08:25 AM
You can wipe out personal list customizations by going to System UI > Lists (sys_ui_list). It looks a lot like the User Preferences table - just find the right user, and the right table name, then delete the record(s).
As a user, you can go up to the List Mechanic (top left corner of the list), and hit the "Reset to Column Defaults" option.
Regards,
Sachin

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2019 08:28 AM
Hi there,
You would need to remove the Lists + List Elements for the list concerned for all users. These are the "overrides" which will always win from the column defaults.
See table "sys_ui_list".
Filter on the table you are after, for example "incident"
Filter on the view you are after, for example "Default view"
Filter on Use not empty
Remove these
Kind regards,
Mark
---
Kind regards,
Mark Roethof
Independent ServiceNow Consultant
10x ServiceNow MVP
---
~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2019 08:30 AM
When deleting the sys_ui_list record, you will get a Confirmation popup about the List Elements. Accept this by choosing "Delete".
Kind regards,
Mark
---
Kind regards,
Mark Roethof
Independent ServiceNow Consultant
10x ServiceNow MVP
---
~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2019 10:17 AM
Thanks for the response.
There are more than 1000 users who'll be using this application. So, deleting for all the users may not be feasible. Is this possible through background script or any other feasible ways?