How to check for deleted record(non-audited)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2024 07:56 AM
A record from sysauto_report is deleted, we want to check how it was deleted. Fortunately I have backup in another instance.
My question is where to check and how check it was deleted. Tried searching logs with table name and deleted record sys_id but couldn't find anything.
Please let me know if there is a way find out what happened

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2024 08:26 AM - edited ‎10-10-2024 08:28 AM
I just checked in my instance and auditing is not turned of in the sysautom_report table. Unless you have some custom ACLs the only user who can delete a scheduled report need report_scheduler role or admin role.
Edit: If someone has report_admin they have report_scheduler role.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2024 08:52 AM
Hi Brian,
Unfortunately, sysauto_report table in my instance is not audited. There is no way I can check this in Deleted records. I want to check how it was happened in the first place.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2024 09:28 AM
found the solution in this table :sys_audit_list
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-15-2025 09:52 PM
Thank you for adding soling ways, and the name should be sys_aduit.