In History Audit(sys_history_line) table, why the updated and updated by is having blank value

hiranmayee
Tera Contributor

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,

2 REPLIES 2

adamjgreenberg
ServiceNow Employee
ServiceNow Employee

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


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