cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Circuit bandwidth exceeded

Jump to solution

How could I use Report Writer to determine how many times in a given month that a circuit's bandwidth exceeded X percentage of utilization (i.e. 60%, 70%, 80%, 90%)?

For example, the report would tell me that circuit bandwidth exceeded 80% of utilization 20 times last month.

 

Thanks,

Daniele

Tags (1)
0 Kudos
1 Solution
Level 17

Hello,

see the LINK HERE for a report that gets my WAN links count when it goes > 45% for 5 minutes (for the last 7 days.

you'll have to tweak for the nodes you are looking for and the percentages (sounds like you'll want to create a few reports).

hope that helps

View solution in original post

0 Kudos
10 Replies
Level 17

Hello,

see the LINK HERE for a report that gets my WAN links count when it goes > 45% for 5 minutes (for the last 7 days.

you'll have to tweak for the nodes you are looking for and the percentages (sounds like you'll want to create a few reports).

hope that helps

View solution in original post

0 Kudos

I am still learning how to work with SQL reporting.  I used the reprot that you created and modifed your custom Nodes.Hostname with Nodes.Caption which I beleive is the field I have.

Below is a copy of my code.  When I execute the query I get an error: Item cannot be found in the collection corresponding to the requested name or ordinal. 

Any suggestions on how to troubleshoot this / proceed?

SELECT
Nodes.NodeID,
Nodes.Caption,
Interfaces.InterfaceID,
Interfaces.Caption,
Interfaces.OutBandwidth,
Interfaces.InBandwidth,
COUNT(*)

FROM
(InterfaceTraffic_Detail INNER JOIN Interfaces ON (Interfaces.InterfaceID = InterfaceTraffic_Detail.InterfaceID) )
INNER JOIN Nodes ON (Nodes.NodeID = Interfaces.NodeID)

WHERE
Nodes.Caption LIKE 'R-XRT-[Aa-Dd]%' AND
(   (InterfaceName LIKE 'Ser%.%') AND (InterfaceName NOT LIKE 'Ser%.16')  )     AND
(
    (((InterfaceTraffic_Detail.In_Averagebps/Interfaces.InBandwidth)*100) > 45)
         OR
    (((InterfaceTraffic_Detail.Out_Averagebps/Interfaces.OutBandwidth)*100) > 45)
)

 

GROUP BY
Nodes.Caption, Nodes.NodeID, Interfaces.InterfaceID, Interfaces.OutBandwidth,
Interfaces.InBandwidth, Interfaces.Caption

ORDER BY Nodes.Caption

0 Kudos

This code was written for my environment so you will have to tweak for your environment...

so, basically, the WHERE clause is how you filter your results.  in my code, I am pulling back devices where
     Nodes.Caption start with R-XRT-A through D
          --i.e. these would match - R-XRT-Arouter, R-XRT-charlie
          --    these would NOT - R-XRT-epsilon, R-XRT-1neattrick, R-XRT-Zebra    
THE NEXT LINE
     InterfaceName basically matches "Serial" and has a "." but is not Serial*.16
          -- i.e. this removes the DLCI 16 subinterface used for mgmt traffic
          -- and catches all other serial subinterfaces
THE NEXT TWO LINES
     basically grab rows where In/OutBandwidth >45%

SO, you would need to at a minimum, remove or change the first line to match names of your devices, and change the last 2 lines of the WHERE clause to be 70,80,90%, depending on what report it is...hope that helps

0 Kudos

If my core switches are named "HASW0010.net.domain.com" and HASW0020.net.domain.com"

How would I modify to capture results from both?

If I am trying to get GE X.X and port-channel results, how would I modify to capture results?

0 Kudos

Where the code reads 

WHERE 

Nodes.Caption LIKE 'R-XRT-[Aa-Dd]%' 

just change to include your name

Like this

nodes.caption like 'HASW0010%'

Same for the interfacename like 'port-channel%'

0 Kudos

Does this look right:

SELECT
Nodes.NodeID,
Interfaces.InterfaceID,
Interfaces.Caption,

COUNT(*)

FROM
(InterfaceTraffic_Detail INNER JOIN Interfaces ON (Interfaces.InterfaceID = InterfaceTraffic_Detail.InterfaceID) )
INNER JOIN Nodes ON (Nodes.NodeID = Interfaces.NodeID)

WHERE
(Nodes.Caption LIKE 'HASW0010%') AND
(InterfaceName LIKE 'port-channel%')  AND
(
    (((InterfaceTraffic_Detail.In_Averagebps/Interfaces.InBandwidth)*100) > 45)
         OR
    (((InterfaceTraffic_Detail.Out_Averagebps/Interfaces.OutBandwidth)*100) > 45)
)

GROUP BY
Nodes.NodeID, Interfaces.InterfaceID, Interfaces.OutBandwidth,
Interfaces.InBandwidth, Interfaces.Caption

ORDER BY Nodes.NodeID

0 Kudos

Well this code gives you how many times the threshold was exceeded. What about the duration or how long the threshold was exceeded.

I am looking for a Report that shows when the bandwidth has exceeded 65% and How long.

So, Ideally a report for bandwidth exceeding 65%, duration, and peak per interface.

0 Kudos

Also some reference to time, like last month, last 7 days, etc could prove useful

0 Kudos

I clicked on the LINK HERE and reviewed your post however I am not understanding how to accomplish this task.  Are you doing this via Report Writer or are you doign this in SQL?  If you are doing it in SQL are you simply running a querty against the database?  Please clarify how you are doing this? 

BTW, your help is much appreciated.

Dsniele

0 Kudos
Level 7

Hello,

 

I am Arik Smith. Today I use this forum first time. I like all part of the forum and I learn very much from your forum. Please give me the proper guidance about circuit. I m very happy after using this forum and I appreciate your guidance.

 

Thank You.

 

 

 

_______________________________________

Want to get-on Google's first page and loads of traffic to your website?
Hire a SEO Specialist from Ocean Groups [url=http://oceangroups.org/]seo pecialist

0 Kudos