You can absolutely do that, you will need to build a report that unions together a bunch of the tables that start with history. For example
,'Renamed from ' + [OldName] as Action
SELECT TOP 1000 [DocumentID]
when 1 then 'Deleted File'
when 2 then 'Restored File'