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

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.

Find more posts tagged with

chart

graph

summarize_bandwidth_data

analyze_outbound_traffic

Accepted answers

All comments

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

Jemini

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

DonYonce

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.solarwinds.net/.../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.

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

errlew

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

Jemini

Thank Don ,the new resource works great!

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.solarwinds.net/.../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

Jemini

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.solarwinds.net/.../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.

Jemini

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

Jemini

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>

swack

The Yahoo zip file is not available at the link specified, and without it I'm not sure how to apply the code shown in the previous couple of posts. I'm looking for a way to summarize link bandwidth data into one chart for multiple interfaces, so I think this would be ideal for me.

Thanks!

MathieuJM

Hi, Same thing. I'm very interesting in having a graph that summarize 2 or more load balanced interfaces.