Search 85,947 posts and 653 resources contributed by 43,569 members or post a topic.

Already Joined? Sign in
Automating Export to CSV

Page 1 of 1 (3 items) | RSS

rated by 0 users
Not Answered This post has 0 verified answers | 2 Replies | 2 Followers | 377 Views


1 Posts
Points 5
mbsimon posted on Sun, Nov 30 2008 3:19 PM
rated by 0 users
Hello all, I am involved in an automated reporting project that needs to collect data regularly from SW. I have created a custom report with the data I need, and now all I need to do is to get the report to run hourly and export to a CSV. The shipped report scheduler seems not to support this for 3 reasons: 1) Won't allow hourly scheduling 2) Won't allow write-to-disk report generation, only email or print. 3) Won't allow export to CSV. I see that this report schedule builds an xml definition file for use by the "runorionjob" tool, and schedules execution of this tool as a windows schedule task. I can adjust the frequency in the task definition to overcome point #1. Also, I've noticed that if I add the "DataFormat=csv" flag to the URL for pulling the report, it will dump a csv, even over the web. This gives me hope for point #3. Does anybody know how the runorionjob tool works? Perhaps there are undocumented options in the XML format that would let me accomplish all of these goals? Or some other technique that will allow me to schedule a report run/export to csv on an hourly basis? Thanks in advance, Matt
  • | Post Points: 5

All Replies


1,000 Posts
Points 5,477
SolarWinds Certified Professional
Yann replied on Mon, Dec 1 2008 7:26 AM
rated by 0 users

Hi,

I tried to have the Report Scheduler to download a CSV report from the webconsole but did not manage to have it working.

The Schedule features will not let you run the job more than once a day.

A workaround could be to use wget to retrieve the CSV file each hour. You can write a vbscript/perl/bash/etc. script which runs the following wget command each hour and save the file in a different name each time it runs.

 wget -b -O report-date-string.csv -p "http://xxx.yyy.zzz.www/NetPerfMon/Report.asp?Report=Average+Response+Time&Dataformat=csv&AccountID=USER&Password=PWD"

 HTH,

Yann 

  • | Post Points: 1

136 Posts
Points 449
SolarWinds Certified Professional
cnorborg replied on Mon, Dec 1 2008 8:08 AM
rated by 0 users

 Hmm...  The "Dataformat=csv" and "Dataformat=xml" are really nice.  It would be great if there was a header put on each report that was "Export to CSV" and "Export to XML"...

Craig Norborg Senior Network Analyst Robert Bosch Corporation

  • | Post Points: 1
Page 1 of 1 (3 items) | RSS

© 2003 - 2010 SolarWinds, Inc. All Rights Reserved.

Who is SolarWinds?

SolarWinds is rewriting the rules for how companies manage their networks. Guided by a global community of network engineers, SolarWinds develops simple and powerful network management software and network monitoring software for networks of all sizes. SolarWinds also offers a network certification program to become a SolarWinds Certified Professional (SCP).

What is thwack?

thwack, SolarWinds online community site, was designed by network engineers, for network engineers. thwack is a vibrant, growing community of more than 30,000 IT pros who share a passion for technology.

Explore Resources, Answers, Templates, and Advice

Download Free Networking Tools


Learn More About SolarWinds Products