I have no idea what kind of overview report you want, but you might find a useful query by doing a Moodle site search for "ad-hoc reports."
Use one as a starting point and add the other fields you want.
Analytics and reporting
Require Overview Report Query!
This discussion has been locked so you can no longer reply to it.