Steps to generate the Daily Zone Wise Product Spend report:
- Run the following queries against cloud_reports DB, to enable the sample report on CloudPortal Business Manager UI:
- INSERT INTO custom_reports (name, class) VALUES ('<Please provide a Report Name here>', ' com.vmops.reports.DailyProductUsagePerZone '')
- INSERT INTO sched_custom_reports (customreportid, frequency, deliveryurl) VALUES (<ID of the above insert>, 'DAILY', '<The FTP path to transfer as in <TransaferType>://<FilePath Based on the TransferType>
- Log in to CloudPortal Business Manager UI as Root user.
- Click Reports > Custom Reports.
- Select the report (Same as the report name provided in the 1st query) that you want to view and click Generate.
- You can also download these reports and forward them via email.