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

Automating Excel reports

I know the report scheduler does not support sending excel sheets at this current point in time, however has anyone had any luck using cURL to grab the excel sheets and then email them with some clever bash scrip

Find more posts tagged with

report_automation

Accepted answers

All comments

Network_Guru

Subscribed!

I'm looking for the same functionality as well.

hcy01uk

One possible answer is using MS SQL reporting service. You can install MSSQL Reporting Service on your Orion DB server. Using MS Report Builder to created the reports from DB directly. Schedule (subscribe) the reports on DB server to email you the report in Excel format. MSSQL reports are more rich than Solarwinds reports, you can include tables, charts, text in the report.

Network_Guru

Thanks for the suggestion.

I have never used this feature before and just ran into it yesterday for the first time on another vendors product (that's what they use to create reports). How steep is the learning curve for this? The Orion Report Writer is very simple to use and self explanatory, so I would expect this to be similar. I am not an SQL guru and would hate to have to hand-craft queries from scratch to get this working.

hcy01uk

Maybe the best way is to ask your DBAs to setup the reporting service and install the report builder. If you are happy with Orion Report Writer reports, you can just copy the SQL queries to MSSQL report builder. It should work without or little modification.