Hey @ccorbalan all of this information is stored in audit_log table. TBH this has proved to be an invaluable piece of the system when starting to work in big teams and provide services out.
It all depends what you are looking for. The best way to go about this it to do a simple desc audit_log, you can then see the columns involved, then do a select * from audit_log limit 10; This will give you a picture of what information is there. You can then start refining your select based on the different bundles, objects, object_ids and actions and date_added.
Here is the desc of the bundle and objects, then object id will refer to the ID of the specific object (example campaign, segment, email…)