Change Request Deleted

[Taylor W]

Hello! We created a custom table which extends Change Request. We noticed that randomly there were records missing on our custom table. Seems very odd but is there anything that would purge Change Requests on a schedule? Note, we don't have any code in our Scoped App that would delete these records. Thanks in advance!

[Allen Andreas]

Hi,

I don't believe there is anything, especially for a custom table, that would randomly delete records without you all setting something up. Here's the documentation for out of box table cleaning, for example: https://docs.servicenow.com/bundle/rome-platform-administration/page/administer/managing-data/concep...

With that said, something must be going on with this table to be deleting records. You'd want to check any scheduled jobs, flows, business rules, etc. and try and pinpoint a trend on this table and all that.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Hitoshi Ozawa]

Hi Taylor,

FYI, scripts won't process extended tables so scripts that process Change Requests won't process the custom table that extends Change Request.

Check sys_audit_delete table to see if the records are actually deleted. If it deleted, by whom and at what time. Filter on "Display value" on the Change Request number.

1. In Application Navigator, go to "System Definition" > "Deleted Records"