In History Audit(sys_history_line) table, why the updated and updated by is having blank value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-01-2018 08:01 AM
In History Audit(sys_history_line) table, why the updated and updated by is having blank value.
I have tested in Jakarta and Helsinki it shows blank. But i remember earlier it was populating with last updated by user and with last updated time.
Anyone is facing the same issue,
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-01-2018 11:03 AM
sys_history_line is built from sys_audit data. Generally the only field in the sys_created / sys_updated that will be populated is sys_created_on and that should be the time/date which the history was built from when someone modified an item.
For instance:
new: 2018-02-01 11:05:44
set: 651c8ab837c0d70099018350d3990e67
user_name: Service-now: Adam Greenberg
old: NULL
update: 3
label: Closed
type: audit
audit_sysid: c0c8b7c9374cd70099018350d3990e0d
relation: NULL
update_time: 2018-02-01 19:05:44
user_id: adam.greenberg
old_value: NULL
internal_checkpoint: 16152c2a8440000001
user: adam.greenberg
new_value: 2018-02-01 19:05:44
email: NULL
field: closed_at
sys_id: 0cc87709370cd70099018350d3990e62
sys_updated_by: NULL
sys_updated_on: NULL
sys_created_by: NULL
sys_created_on: 2018-02-01 19:05:44
sys_mod_count: NULL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-05-2018 07:45 AM
Thanks Adam for your quick response. But i am not clear as it was visible on individual record but when i go to list it disappears.
Thanks
Hiran