Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Automatically exporting reports to CSV files through Report Writer

dpeterson87

Hello,

I was wondering if anyone knew how to set up something to automatically export CSV files through the Report writer.

Thank you in advance for any advice you have.

Regards,

-Dustin

Find more posts tagged with

Accepted answers

dkeyser

Sounds like you have this set up to send as an html format report. Have you tried changing this to pdf? It may be that your email client is limiting the preview of the email. Are you using outlook?

Also make sure "Group historical report by days" is not checked on the general tab of the report in report writer.

Sent from my iPad

All comments

adatole

When/how do you want to get this CSV output?

If you want it ad-hoc, as in "I click the report in the Solarwinds portal and I get CSV instead of on-screen data", then you can add "&dataformat=excel" to the end of the report URL,

If you want the CSV delivered to you via email (a la the report scheduler) then the only way I've found is to mimic the SQL and set up a scheduled job to email you straight from the database itself (ie: set it up in SQL Management Studio).

dpeterson87

I tried adding the "&dataformat=excel" to the URL but it is not working for me.

Now when I get the emails everything is blank and at the bottom it says Enable Javascript to login.

Do you have any idea's on how to get around this?

dkeyser

Have you tired '&dataformat=xls" ?

The list of usable formats I have are:

txt

xls

csv

jpg

raw

xml

Know of any others?

dpeterson87

Thanks for the tips.

Now I am having a different issue. When I run the report they continually say at the bottom " Enable Javascript to login"

I have went through IE and tried turning on every setting I could think of but I keep getting that message.

Anyone have Idea's on how to fix that?

Thanks again,

-Dustin

dkeyser

Have you tried the following to enable jave in IE?

On web browser menu click "Tools" menu and select "Internet Options".
In the "Internet Options" window select the "Security" tab.
On the "Security" tab click on the "Custom level..." button.
When the "Security Settings - Internet Zone" dialog window opens, look for the "Scripting" section.
In the "Active Scripting" item select "Enable".
When the "Warning!" window pops out asking "Are you sure you want to change the settings for this zone?" select "Yes".
In the "Internet Options" window click on the "OK" button to close it.
Click on the "Refresh" button of the web browser to refresh the page.

dpeterson87

Hi dkeyser,

I have tried what you suggested and I get the same thing.

When I browse to our solarwinds page in IE I am able to get there fine and see everything.

It is just when I run the reports that is says enable javascript to login.

Thanks again for your help

dkeyser

I'm unable to reproduce any results like the ones you've mentioned. It sounds like your browser is having trouble opening the webpage. Are you sending the login credentials using the report writer?

Maybe try clearing cookies and cache to see if something was stuck.

dpeterson87

Hmm, I made a new report and instead of using a service account we created I ran the report using my AD credentials and it worked

Now, I have another issue with the reports.

When I look at the reports on the web I only get 5 or 6 lines, but when I execute the query in the report writer I get about 2000 lines.

Do you know why that is?

Thanks again for all your help

dkeyser

What format are you sending the report?

dpeterson87

I have tried sending it as a csv file and as an xls file.

When I put the &dataformat=xls or &dataformat=csv at the end of the URL the report will not email out.

If I take those things off the end of the URL the report will send but I only get 5 or 6 lines.

Thank you,

-Dustin

dkeyser

Sounds like you have this set up to send as an html format report. Have you tried changing this to pdf? It may be that your email client is limiting the preview of the email. Are you using outlook?

Also make sure "Group historical report by days" is not checked on the general tab of the report in report writer.

Sent from my iPad

dpeterson87

THANK YOU SOOOO much dkeyser, your suggestion of unchecking "group historical report by days" worked and now I can see all the data from the report on the website.

I just tried changing the report to pdf in the report scheduler but it is still not getting sent out for some reason.

Thanks for all your help

dpeterson87

Never mind!!! the report just came through and it did it is CSV format problem solved

Thanks again!!!

dkeyser

Excellent!I still can't get mine to send an email with the csv format. Congrats! You should do a write up on how you did it so others can benefit.

dpeterson87

Hi dkeyser,

Thanks again for everything and I just have one more issue with the report.

I got the CSV to sent but when it is send it shows all the fields.

In the report I have hidden fields and when I look at the report on the Orion website, the hidden fields don't show up, but in the exported CSV file they do.

Do you have any idea what would cause that or how to fix that?

Thanks again,

-Dustin

dkeyser

I'd check to make sure I was using the right version of the report. If you had created more than one version in your testing you may be seeing one version on the site and sending another version. Since I can't send the reports as CSV files myself I can't reproduce your results and test from there. Would you explain how you did it and what you used? like if you used chrome instead of Internet Explorer or if you have special settings to accomplish this?