12 Replies Latest reply on Dec 7, 2009 7:43 AM by MathieuJM

    How to make single chart for multiple interfaces?

      I want to analyse the outband traffic of our netwrok which has four links.
      I know I can use "sum" function to get the total in "current traffic" section in report writer for a real time result.
      How can I get a historical traffic chart for a total resule of the four links?

      Thanks.
        • Re: How to make single chart for multiple interfaces?
          Network_Guru
          Do not use the Node Names in the report. Base the report on a custom property which is assigned to all 4 routers. Then use that only that name in the report.

          Then, under interfaces in the Custom Property editor create a description under something like 'Circuit number' such as "Outbound" on each of the four interfaces. Then in Report Writer filter on "Where Circuit number = "outbound". You will get a single figure based on the aggregated traffic seen on all interfaces with the "outbound" description assigned to them.

          I do this for the Call Centers which have multiple routers & links, when I create the Monthly Data transferred to/from each Call Center report.

          -=Cheers=-
                    NG
          • Re: How to make single chart for multiple interfaces?
            Thanks Network_guru.
            I want to view the chart but dose report writer make chart?
            Yes follow your instructions I can query and get the historical data from database of those interface,but not chart.
            How can I view this chart from Orion Web pages?
            Thanks.
            Maybe another way is paste the data to Microsoft Excel and make chart :).


            quote:Originally posted by Network_Guru

            Do not use the Node Names in the report. Base the report on a custom property which is assigned to all 4 routers. Then use that only that name in the report.

            Then, under interfaces in the Custom Property editor create a description under something like 'Circuit number' such as "Outbound" on each of the four interfaces. Then in Report Writer filter on "Where Circuit number = "outbound". You will get a single figure based on the aggregated traffic seen on all interfaces with the "outbound" description assigned to them.

            I do this for the Call Centers which have multiple routers & links, when I create the Monthly Data transferred to/from each Call Center report.

            -=Cheers=-
            NG
            • Re: How to make single chart for multiple interfaces?
              Jemini,
              There are a number of ways to do this. Here are a couple ....

              Method one - download and install charts built for Yahoo

              We built some custom charts like this for Yahoo some time ago that would show traffic for all aggregated Internet links. you can download them from ftp://ftp.solarwinds.net/pub/Orion-NPM-V7/YahooCharts.zip
              Download this package and follow the ReadMe.txt in the zip file.


              Method two - View with a custom limitation

              This method works for Network Performance Monitor version 7.6 and greater. If you are not running version 7.6 pre-release, you will need to wait for the upgrade before this feature is available.
              You can tell what verion of Orion you are running from the bottom of any Orion web page.

              From your Orion web site, build a new View named "Internet" and place the Network Wide charts you would like on it. Then apply a "View Limitation" to the "Internet" View. (Applying a View limitation is new in version 7.6). Limit the view to the list of Interfaces you would like to see combined on a single chart. Whenever you select this view, the charts will now show the aggregated data for the Interfaces you selected.



              • Re: How to make single chart for multiple interfaces?
                Network_Guru
                If you have Office XP or 2003 installed on your PC, you can just right click on any Orion report in your browser(IE) and select - "Export to Excel".

                Once you have it in Excel, just select the data and press F11.
                Voila, instant graph.

                -=Cheers=-
                          NG
                • Re: How to make single chart for multiple interfaces?
                  Hi
                  I have download yahoo_charts. It works fine but instead of getting agregate for all the links, how can i get a chart with each interface displayed on the the same chart

                  Errol
                  • Re: How to make single chart for multiple interfaces?
                    Thank Don ,the new resource works great!
                    • Re: How to make single chart for multiple interfaces?
                      BryanBecker
                      quote:Originally posted by Don Yonce

                      Jemini,
                      There are a number of ways to do this. Here are a couple ....

                      Method one - download and install charts built for Yahoo

                      We built some custom charts like this for Yahoo some time ago that would show traffic for all aggregated Internet links. you can download them from ftp://ftp.solarwinds.net/pub/Orion-NPM-V7/YahooCharts.zip
                      Download this package and follow the ReadMe.txt in the zip file.


                      Method two - View with a custom limitation

                      This method works for Network Performance Monitor version 7.6 and greater. If you are not running version 7.6 pre-release, you will need to wait for the upgrade before this feature is available.
                      You can tell what verion of Orion you are running from the bottom of any Orion web page.

                      From your Orion web site, build a new View named "Internet" and place the Network Wide charts you would like on it. Then apply a "View Limitation" to the "Internet" View. (Applying a View limitation is new in version 7.6). Limit the view to the list of Interfaces you would like to see combined on a single chart. Whenever you select this view, the charts will now show the aggregated data for the Interfaces you selected.






                      I downlaoded the yahoo charts and get a red 'X' when I load it.  I double-checked the custom property and eveything.  Not sure what's going on.

                      BB
                      • Re: How to make single chart for multiple interfaces?
                        Don,I have another question for "yahoo chart"....how to deal with multiple interface with different bandwidth?


                        quote:Originally posted by Don Yonce

                        Jemini,
                        There are a number of ways to do this. Here are a couple ....

                        Method one - download and install charts built for Yahoo

                        We built some custom charts like this for Yahoo some time ago that would show traffic for all aggregated Internet links. you can download them from ftp://ftp.solarwinds.net/pub/Orion-NPM-V7/YahooCharts.zip
                        Download this package and follow the ReadMe.txt in the zip file.


                        Method two - View with a custom limitation

                        This method works for Network Performance Monitor version 7.6 and greater. If you are not running version 7.6 pre-release, you will need to wait for the upgrade before this feature is available.
                        You can tell what verion of Orion you are running from the bottom of any Orion web page.

                        From your Orion web site, build a new View named "Internet" and place the Network Wide charts you would like on it. Then apply a "View Limitation" to the "Internet" View. (Applying a View limitation is new in version 7.6). Limit the view to the list of Interfaces you would like to see combined on a single chart. Whenever you select this view, the charts will now show the aggregated data for the Interfaces you selected.




                        • Re: How to make single chart for multiple interfaces?
                          I renew the "Yahoo chart" script and it can caculate multiple interface with different bandwidth.
                          Don,could you tell me how to display the "SumBandwidth" as a footer in the chart?



                          SELECT
                          datetime,
                          sum(avginbps) as InBandwidth,
                          sum(avgoutbps) as OutBandwidth
                          from
                          (SELECT Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) As DateTime,
                          avg([IN_Maxbps])/1000000 as avginbps,
                          avg([OUT_Maxbps])/1000000 as avgoutbps,
                          interfaces.interfaceid as interfaceid,
                          interfaces.outbandwidth as bandwidth
                          FROM InterfaceTraffic INNER JOIN Interfaces ON InterfaceTraffic.InterfaceID = Interfaces.InterfaceID
                          WHERE interfaces.interface_service_type in( 'leaseline_p_edge','leaseline_bgp')
                          and interfaces.adminstatus * interfaces.OperStatus = 1
                          and interfaces.operational = 1

                          And DateTime >= ${PeriodBegin} And DateTime <= ${PeriodEnd}
                          GROUP BY Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0),interfaces.interfaceid,
                          interfaces.outbandwidth
                          ) as avg_table inner join interfaces on interfaces.interfaceid = avg_table.interfaceid

                          group by datetime
                          • Re: How to make single chart for multiple interfaces?
                            here is an new one that I can caculate a group of interfaces with diffenrent bandwidth.
                            Plz give me advice for any advance


                             <TEST1-PercentUtilization>
                             <ID>TRAFFICUtil1</ID>
                             <Poller>Summary</Poller>
                             <Name>Traffic Utilization</Name>
                             <SQL>
                             SELECT
                             Datetime,
                             SUM(avginbps) as InPercentUtil,
                             SUM(avgoutbps) as OutPercentUtil
                             FROM
                             (
                             SELECT
                             Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0) As DateTime,
                             avg([IN_Maxbps])/1000000000 as avginbps,
                             avg([OUT_Maxbps])/1000000000 as avgoutbps,
                             interfaces.interfaceid as interfaceid,
                             interfaces.outbandwidth as bandwidth
                             FROM
                             InterfaceTraffic INNER JOIN Interfaces ON InterfaceTraffic.InterfaceID = Interfaces.InterfaceID
                             WHERE
                             Interfaces.Interface_service_type2='from_backbone_to_bj'
                             And interfaces.adminstatus * interfaces.OperStatus = 1
                             And interfaces.operational = 1
                             And DateTime >= ${PeriodBegin} And DateTime <= ${PeriodEnd}
                             GROUP BY
                             Convert(DateTime,Floor(Cast(DateTime as Float)/${SampleSize}*1440)*${SampleSize}/1440,0),
                             interfaces.interfaceid,
                             interfaces.outbandwidth
                             )
                             as avg_table INNER JOIN Interfaces ON Interfaces.Interfaceid = avg_table.interfaceid /*temp table*/
                             GROUP BY
                             Datetime
                            </SQL>
                             <Where>[your sql query WHERE option]</Where> /*add SQL query option here,same as the WHERE section,same as the SQL section above*/
                             <Title>Backbone Traffic Inbound Utilization</Title>
                             <SubTitle>Total Bandwidth 4Gb+3*155Mb</SubTitle> /*add the total bandwidth manually*/
                             <SubTitle2>${Period}</SubTitle2>
                             <PlotStyle>Bar</PlotStyle>
                             <Units>%</Units>
                             <ComparisonSubsets>0</ComparisonSubsets>
                             <RAxisSubsets>0</RAxisSubsets>
                             <DataTable>InterfaceTraffic</DataTable>
                             <Rescaleable>No</Rescaleable>
                             <Icon>Step</Icon>
                             <Axises>
                             <XAxis>
                             <Label/>
                             </XAxis>
                             <RYAxis>
                             <Label>% packet loss</Label>
                             <ManualScale>Both</ManualScale>
                             <ScaleMin>0</ScaleMin>
                             <ScaleMax>102</ScaleMax>
                             <AxisColor>&H000000FF&</AxisColor>
                             <Format>||%</Format>
                             </RYAxis>
                             <YAxis>
                             <Label/>
                             <ManualScale>Both</ManualScale>
                             <ScaleMin>0</ScaleMin>
                             <ScaleMax>2</ScaleMax> /*add the total bandwidth manually*/
                             <AxisColor/>
                             <Format>| ,|| G</Format> /*add the bandwidth data format manually*/
                             </YAxis>
                             </Axises>
                             <PlotStyles>
                             <Line/>
                             <Bar/>
                             <Spline/>
                             <Step/>
                             <Ribbon/>
                             <Points/>
                             <PointsPlusLine/>
                             <PointsPlusSpine/>
                             <BestFitCurve/>
                             <BestFitLine/>
                             <Area/>
                             </PlotStyles>
                             <Subsets>
                             <InPercentUtil>
                             <Name>Receive Utilization</Name>
                             <Field>InPercentUtil</Field>
                             <Color>&H00FF8080&</Color>
                             <PointStyle>2</PointStyle>
                             <LineStyle>Medium</LineStyle>
                             <SubsetType>Avg</SubsetType>
                             <Direction>Receive</Direction>
                             </InPercentUtil>
                             <OutPercentUtil>
                             <Name>Transmit Utilization</Name>
                             <Field>OutPercentUtil</Field>
                             <Color>&H00008000&</Color>
                             <PointStyle>7</PointStyle>
                             <LineStyle>Medium</LineStyle>
                             <SubsetType>Avg</SubsetType>
                             <Direction>Transmit</Direction>
                             </OutPercentUtil>
                             </Subsets>
                             </TEST1-PercentUtilization>