Table list view every day common for all in dev instance level

[Manohararuna]

Hi Everyone

   I have the performance issues in Low environment like Dev and UAT

   For that purpose we can use less fields in the table list view and and show records 100 only .

   But other users are means who are having the access they are changes the list view and show record count as per their requirement. because of this again latency will be happen.

So i want to solution like if any person change the list view fields and show list record count but next day it automatically come back previous state.

for i want to solution and one Schedule to run every day midnight 12 AM and bring back previous state in incident and problem, change, approval and all table in Dev and UAT instances level

Finally i want to decrease the Browser response time on each table .

Examples: Before removing unwanted fields and show fields on table list view on Incident table it takes almost 

after removing all unnecessary fields and Show fields on table view it takes half browser time

[Vasantharajan N]

@Manohararuna - You can delete the records created by users from the table sys_ui_list, in order for you to restore the OOTB list view element on the table that you wanted. 

You can use flow designer to achieve it.

[Robert H]

Hello @Manohararuna ,

You can run the following script as a scheduled job, but please don't do this in a production environment as your users won't be happy if their preferences get reset.

var grPrefs = new GlideRecord('sys_user_preference');
grPrefs.addQuery('name', 'rowcount');
grPrefs.addNotNullQuery('user');
grPrefs.deleteMultiple();

var grList = new GlideRecord('sys_ui_list');
grList.addNotNullQuery('sys_user');
grList.deleteMultiple();

In addition, you might also want to update the glide.ui.per_page System Property so user won't be able to select a large number of rows per page.

Regards,

Robert

[Manohararuna]

Hello Robert,

       Thanks for the solution but it won't work on tables level. 

        Please check it and send me the screen shot for reference Robert.

       Please test it on Incident table only. That's enough to me

Regards,

D Manohar Reddy

[Robert H]

Hello @Manohararuna ,

What do you mean "it won't work on table level"?

Everything in ServiceNow is a table, and the solution I provided will reset both the list columns as well as the number of rows back to the default.

Please elaborate how you have tested this.

Regards,

Robert