Why Are My Deleted Records Still Active?

Question

I have enabled read permissions for the sys_audit_delete table in ServiceNow. Why do deleted records still appear as active in my destination?

Environment

Connector: ServiceNow

Answer

Deleted records may remain active for either of the following reasons:

1. The ServiceNow sys_audit_delete table only captures deletions for tables with auditing enabled. You must enable auditing separately for each parent and child table.
2. Deletes performed by background scripts, business rules, import sets, direct database operations, automated cleanup jobs, or bulk data management scripts may bypass the normal audit trail.

For more information, see Which sys_audit_delete Fields Does Fivetran Need to Capture Deletes?.