You'll want to setup a server task for the reports you want run and emails.
Create new server task
In the Actions select Run Query, then select the query you want to run
Add a subaction to email the file to the people who should get the report.
Add another subaction to export the file to an appropriate path.
From there it's just setting the schedule and making sure the task is enabled.
And remember to to insert your smtp relay adresse in e-mail server setting "SMTP server name:"
Is it possible to do customization in reports like exclude ESXi hosts if not how to install McAfee Client on ESXi hosts