SELECT * --column list
FROM historical_events he
LEFT JOIN hist_datasources hd
ON he.hist_datasource_id = hd.id
LEFT JOIN datasources d
ON hd.datasource_id = d.id
LEFT JOIN historical_event_types het
ON he.historical_event_type_id = het.type_id
That doesn't work, as he.hist_datasource_id is NULL for every record where the Event Type = '84' (Access View). Do you have values in that field??
You should be looking for the "Access Datasource" event type name. Events of this type should be created whenever a view is loaded that connects to a published datasource. Let me know if you're not seeing that in your data, though.