This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Report writing/formating

gozieeric over 15 years ago

Hi all, Some one please say on how to achieve the following reports:

# 1) Report bandwidth figures on monthly biases , while presenting availability of same in percentage.(Charts have been noted). These reports should be in an exportable format like Microsoft sheets, hence should be e-mailed to predefined email addresses at predefined time intervals ,say daily, weekly etc. A sample of the report is attached below:

	Branch name	Location	Bandwidth	April %	June%	July %	Total % AVAILABILITY REPORT	Penalty Remark
1	Slhsls			78	53	99	89	Apply penalty
2	Hsohsos			77	45	66	77	Apply penalty
3	Hoshos			90	97	46	98	pay full
4	nsolnsns			34	45	90	98	pay full
5

Thank you.

Eric.

0 Yann over 15 years ago

Hi,
If you add the &Dataformat=xls string at the end of a report URL, it will prompt you to download a file in the excel format. you can as well use &Dataformat=csv .
I have only been able to use the csv format with Orion Report Scheduler, xls does not seem to work.
How to Schedule reports: http://www.solarwinds.com/NetPerfMon/SolarWinds/OrionAdministratorGuide.1.212.htm
HTH,
Yann
Cancel
Vote Up 0 Vote Down

Cancel

0 gozieeric over 15 years ago in reply to Yann

Thanks Yann,

That was a quick one and stright to the point.

Am now able to download my reports in formats xls formats.

Could you please help with the formating as I illustrated?

Atteched is a copy of the report for January/ feb.

I rather would have them arrenged as illustrated in the mail i sent earlier.

Thanks.

Node ID		Node	IP Address	Availability	Month
6	9.gif	bbt	192.168.20.1	97.44 %	January 2009
7	3955.gif	BBT Call Centre Switch	192.168.20.205	97.61 %	January 2009
16	Unknown.gif	BBT_RECEPTION	192.168.20.2	49.62 %	January 2009
12	311.gif	ERIC2K3ONE	192.168.20.3	78.57 %	January 2009
4	311.gif	PRIVATESERVER	192.168.20.10	98.20 %	January 2009
17	311.gif	TESTINGSERVER	192.168.20.30	2.65 %	January 2009
8	1612.gif	Use _set_ to fill your domain name here.	217.20.242.25	97.19 %	January 2009
6	9.gif	bbt	192.168.20.1	96.54 %	February 2009
7	3955.gif	BBT Call Centre Switch	192.168.20.205	96.64 %	February 2009
16	Unknown.gif	BBT_RECEPTION	192.168.20.2	52.56 %	February 2009
12	311.gif	ERIC2K3ONE	192.168.20.3	65.65 %	February 2009
4	311.gif	PRIVATESERVER	192.168.20.10	98.55 %	February 2009
17	311.gif	TESTINGSERVER	192.168.20.30	1.10 %	February 2009
8	1612.gif	Use _set_ to fill your domain name here.	217.20.242.25	96.39 %	February 2009