sys_metadata

[nowitsvashu]

Hi 

Just want to know if someone deletes the record from the sys_metadata table then in which table we can found that deleted record?

[Maddysunil]

@nowitsvashu 

I think ServiceNow provides audit functionality that tracks changes made to records, including deletions. The audit data is stored in the sys_audit table. You can use this table to track when records were deleted, who deleted them, and other details.

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks

[nowitsvashu]

suppose the record i'm searching for someone also deleted from the sys_audit table

[Maddysunil · Accepted solution]

@nowitsvashu 

If the record you're searching for has been deleted from both the sys_metadata table and the sys_audit table, and you don't have any other backups or audit trails enabled, it may be challenging to recover the deleted record directly within the ServiceNow instance.

In such cases, you might need to resort to external backups or database backups if you have them. Further, Here are some steps you could take:

1. Check Database Backups: If your organization has a database backup strategy in place, you might be able to recover the deleted record from a recent database backup. You would need to work with your database administrator or whoever manages the backups to restore the relevant data.

2. Contact ServiceNow Support: If the deleted record is critical and you're unable to recover it through other means, you could reach out to ServiceNow support for assistance. They may have additional options or suggestions for recovering the data.

Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Thanks