sys_audit "fieldname": "DELETED"

nimzo88
Giga Contributor

Hello, 

I am examining the sys_audit table, 

and I see many records with fieldname = "DELETED"

        {
            "fieldname": "DELETED",
            "reason": "",
            "sys_id": "<the_sys_id>",
            "newvalue": "DELETED",
            "sys_created_on": "<the_timestamp>",
            "documentkey": "<the_document_key>",
            "internal_checkpoint": "",
            "record_checkpoint": "-1",
            "tablename": "<the_table_name>",
            "user": "system",
            "oldvalue": "DELETED",
            "sys_created_by": "system"
        },

what is the meaning of such events? one example of such event is for table "ais_ingestion_trigger_checkin" .

Is this an internal system process ? 

 

1 REPLY 1

Ricardo Velez
ServiceNow Employee
ServiceNow Employee

This shows when the target record (DocumentID) was deleted from the platform so it is no longer present on source table.  The deleted record should be found in the sys_audit_delete table and if the deleted record is recovered then an audit record will be created with the fieldname/oldvalue/newvalue set to RECOVERED.