You can get this information from the CDR files. Depending on how easy/hard it is to access those files (depending on where your PBX is hosted), that might be a straightforward way to automate the process.
Our 3CX Exporter tool can automate the entire process for you, and we will write the report for you.