soql – Query recently changed records independent of Object
You can’t query every single table simultaneously to get all the most recent records. I’m not aware of any database system with that level of capability without writing some kind of SQL script or a rather complicated query. Databases simply aren’t meant to make that kind of query. What you can do is open the Developer Console in Salesforce, perform some action you’re interested in tracing, and then read the log file. The log file will include the ID values for every record created, modified, deleted, or undeleted. In the case of asynchronous code, you may need to read through multiple logs.
Read more here: Source link