I am having an issue getting the "email scheduler" to send custom reports properly. Essentially we want a report, that covers 7 days worth of data/logs that will be sent every week via email to a group of people, preferably via CSV format; however speaking with PA support on this issue there is a pending feature request (low priority, so no info on when this feature request will be implemented) to have the email scheduler function and export reports properly to a csv format. Also, the other issue and the main issue that we have currently is that PA support advised to create custom reports to cover a 7 day time frame that we are requesting, using a selected PA predefined report template within the custom reports and pulling the attributes and columns we wanted the report to display. The main issues we are running into are that:
1- using the email scheduler reports do not resolve hostnames properly using the email sceduler.
2- even though we select the "sort by" or "group by" options in the report, the report will sort by time. - so we have to sort through pages and pages worth of data- tjis is why we want the report as a csv format.
3- some of the custom reports will not include all selected "columns" we have selected via the custom reporter.
When we select the "run now" option with these custom reports, using the same parameters we have selected with the email scheduler, the reports generate completely fine, including the capability to successfully export the report into csv format.
Can we write or create a script to essentially perform the "run now" function to export the custom report as a proper csv format and send out the report via email?
... View more