What triggers the [sys_updated_on] field to get updated?

Korynn · ‎04-21-2020

I need to know what specifically triggers the [sys_udpated_on] field to get updated (I know EVERY type of change/modification in ServiceNow (SN) does not trigger it to get updated). Long story short: We have an external reporting system that we use for advanced reporting/queries. The updates to that external reporting system are done on an incremental basis. The incremental updates from (SN) are based on the [sys_updated_on] field. Therefore, I need to know what types of updates will/will not make it into our external reporting system.

Gowrisankar Sat · ‎04-29-2020

Hi,

sys_updated_on column on every table is defined by default in the Database of ServiceNow.

- These gets changed whenever there is a manual change in the record.

- Any business rule/script include/workflow/server side script updating the records will update this value.

- This doesn't get updated when there there is this code: autoSysFields(false); in the server side script.

- When you have a code which update sys_updated_on field, this doesn't get updated.

- This will not change sys_updated_on when you save a form, update a record through script but there are no changes in the record.

Check out these community articles for reference:

https://community.servicenow.com/community?id=community_question&sys_id=fafac7addb5cdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=d0064761db1cdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=58819f2ddbdcdbc01dcaf3231f96...

View solution in original post

Bhanu Kiran · ‎08-31-2020

We have an existing article that might help you, in case you are not aware. You can find it here!KB0826232

Global default fields