Event Espresso 4. Custom report that includes the Event Name, Event Start Date, Ticket End Date. Paste into phpMyadmin's SQL tab. If your WP database has a unique prefix (instead of wp_) you'll need to replace your prefix for each wp_

custom_report.sql

SELECT `wp_posts`.`post_title`, `wp_esp_datetime`.`DTT_EVT_start`, `wp_esp_ticket`.`TKT_end_date`
FROM wp_posts
LEFT JOIN `wp_esp_event_meta` ON `wp_posts`.`ID` = `wp_esp_event_meta`.`EVT_ID`
LEFT JOIN `wp_esp_datetime` ON `wp_posts`.`ID` = `wp_esp_datetime`.`EVT_ID`
LEFT JOIN `wp_esp_ticket` ON `wp_esp_event_meta`.`EVTM_ID` = `wp_esp_ticket`.`TKT_ID`
WHERE `wp_posts`.`post_type` LIKE 'espresso_events'
ORDER BY `wp_esp_datetime`.`DTT_EVT_start` DESC