cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Highlighted
Level 11

Should emailed reports include an actual attachment or just a url?

I have a stupid question that I just can't find an answer on.  I need to know for certain how the report scheduler is designed to work.  If I'm using the report scheduler and want to generate a report and send an email should the report arrive in my inbox as an attachment?  I just upgraded to NPM12 thinking that I had a bug in 11.5 and I'm still seeing the same stuff. 

Instead of receiving an attachment I am receiving a link to the report. 

I've include a screenshot of the settings I have for this particular issue.

Here is my email body and it is the same message as it was prior to upgrading to NPM12.

The attached report provides details on current space usage for each volume being monitored in Solarwinds for ClientXYZUnable to retrieve url: https://www.xyz:443.com/Orion/Report.aspx?ReportID=803 using CSV type.Unable to retrieve url: https://www.xyz.com:443/Orion/Report.aspx?ReportID=803 using Excel type.

0 Kudos
4 Replies
Highlighted
Level 15

Re: Should emailed reports include an actual attachment or just a url?

I would start with this: Unable to retrieve the PDF, CSV, or URL of scheduled reports - SolarWinds Worldwide, LLC. Help and S...

Past that, and it might be a silly one, but you're positive that the report in question only has a custom table resource right? Also, can you run the report in the SolarWinds website directly and then export to CSV/Excel from there?

If you have looked through all of the steps in that KB, I think the next helpful bit for this thread would be a screenshot of the actual report in the SolarWinds website.

-ZackM

Loop1 Systems: SolarWinds Training and Professional Services

0 Kudos
Level 15

Re: Should emailed reports include an actual attachment or just a url?

That might be the issue. I do not think that the old win32 app Report Writer reports can actually be exported to CSV or Excel.

I would remake that report using the web report writer and see if that resolved the issue.

You might be able to update your URL as well, I haven't tried this in years so I can't promise it wil work: How to Export NPM Report Writer Data to Excel (xls or csv)???

Basically you just append

&dataformat=csv

or

&dataformat=xls

to the end of your report URL.

0 Kudos
Highlighted
Level 11

Re: Should emailed reports include an actual attachment or just a url?

I have an update and I was looking at the wrong report before.  The report IS web based. 

Appending &dataformat=xls to the end of the url does not change the display when I copy/past the url with or with out the data formatting option.  I am still required to then click to export as excel or click to export as pdf.  Below is the Custom Table. 

Web Based.JPG

0 Kudos
Highlighted
Level 15

Re: Should emailed reports include an actual attachment or just a url?

If it's a web-based report; then you do not need to use the addition to the end of the URL.

If you are now able to export to excel after running the report in the website and then clicking the "export to excel" option; then the export functionality is definitely working.

At this point, if you are still not able to see the excel attachments, then I would suggest opening a ticket with SolarWinds tech support to have an investigation in the logs to see if there is an observable error.

I would probably ping your email admin as well and make sure that the emails aren't being stripped of attachments due to a security policy.

0 Kudos