Day 16: DDIS - JDBC Data Sources with "Use last run datetime" option unchecked

Scan Check Type: Table Check [sys_data_source]

Repeatedly importing data that has not changed leads to many skipped rows and unnecessarily bounds system resources.

Ensure that each import is not importing all records every time by using the "Use Last Run Datetime" option. If you are running a JDBC import, use the last run datetime option in your import set Data Source. For a type of File import, be sure that whatever is generating your files is only adding data that is new, or has been changed.

This scan was developed using a table check with condition to identify any data source records of type JDBC with a use last run datetime is False. This rule is defined both in ServiceNow’s Health Scan and in QualityClouds checks.

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 16 scan_table_check_bd93dcac2fab11107caa93acf699b6a0.xml