2 Replies Latest reply on Feb 13, 2009 6:42 AM by gozieeric

    Report writing/formating

      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.

        • Re: Report writing/formating
          Yann

          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

            • Re: Report writing/formating

              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 NodeIP AddressAvailabilityMonth
              9.gif bbt 192.168.20.1 97.44   % January   2009 
              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 
              311.gif PRIVATESERVER 192.168.20.10 98.20   % January   2009 
              17 311.gif TESTINGSERVER 192.168.20.30 2.65   % January   2009 
              1612.gif Use   _set_ to fill your domain name here. 217.20.242.25 97.19   % January   2009 
              9.gif bbt 192.168.20.1 96.54   % February   2009 
              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 
              311.gif PRIVATESERVER 192.168.20.10 98.55   % February   2009 
              17 311.gif TESTINGSERVER 192.168.20.30 1.10   % February   2009 
              1612.gif Use   _set_ to fill your domain name here. 217.20.242.25 96.39   % February   2009