Scheduling email of custom CSV report

Reporting
1

(imported topic written by Bill.Ehardt)

I’ve created a few custom reports in web reports and I am trying to email it as a csv via a scheduled activity.

The problem I’m having is that the csv will show the entire code of the custom report, not just the data itself.

For example, I’m seeing :

<table id=
"resultsTable" class=
"sortable"><th>Computer</th><th>LastRun</th><th>Cert Start</th><th>Cert End</th><th>Cert Name</th><tr><td>L98WAT3F</td><td></td><td> </td><td> </td><td> </td></tr>

as well as

h3 
{ font: 10pt verdana background-color: #747170; padding: 4px 4px 4px 4px; color: white; width: 100%; 
}

When I email HTML it looks fine, but it isn’t easy to manipulate. Is there something I need to add to the script, or is there something that isn’t working right?

2

(imported comment written by Bill.Ehardt)

Am I really the only one who sees this? Should I open an issue with support?

3

(imported comment written by MattBoyd)

Is this a custom report that was created yourself? If so, I don’t think the “CSV” option will work. If you generate a report using the “Explore Data” feature, you should get CSV results correctly…

4

(imported comment written by Bill.Ehardt)

Yes it is. This seems like something that should be possible, otherwise we need to find some way to schedule/email reports via different method.

5

(imported comment written by MattBoyd)

Yeah, this is something that I’ve run up against a few times with custom reports. Another big annoyance for me is that the lack of support that relevance has for sorting results. While javascript can help you sort the results in your HTML tables, it won’t work for e-mails.

If you decide to script it yourself, here’s a VBScript I wrote that you may want to use as a starting point: http://forum.bigfix.com/viewtopic.php?pid=25870#p25870 .