Day 5: DDIS - User Preference "Rows per Page" set above 100

Scan Check Type: Table Check [sys_user_preference]

System performance may degrade if many users set their "rows per page" user preference to high values.

Set the default rows per page back to 100 for each user who has changed it. Navigate to sys_user_preference table, and update the rowcount and mobile_rowcount preferences.

This scan was developed using a table check with condition to identify any user preference records with a rowcount/mobile_rowcount name, and a value that is greater than 100. This check appears both in ServiceNow’s Health scan and Quality Cloud’s product. Some sources disagree on the exact number to be used (some cite 20 or 50), but above 100 can definitely cause issues. The suggestion may be to set the default to 20, but allow users to select 50/75/100.

Download and import the XML to check it out in your instance! At the end of the month I will be bundling all the checks together.

Day 5 scan_table_check_e925dc412f4311107caa93acf699b6f3.xml