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.

Circuit bandwidth exceeded

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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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.

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

  • 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?

  • 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%'

  • 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