10 Replies Latest reply on Nov 28, 2011 11:22 AM by bob.jones

    Circuit bandwidth exceeded

    bartman

      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

        • Re: Circuit bandwidth exceeded

               

          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

          • Re: Circuit bandwidth exceeded
            njoylif

            Hello,

            see the utilization greater than 45% count - sql 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

              • Re: Circuit bandwidth exceeded
                bartman

                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

                • Re: Circuit bandwidth exceeded
                  bartman

                  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

                    • Re: Circuit bandwidth exceeded
                      njoylif

                      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

                        • Re: Circuit bandwidth exceeded
                          mgibson

                          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.

                          • Re: Circuit bandwidth exceeded
                            bob.jones

                            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?

                              • Re: Circuit bandwidth exceeded
                                mgibson

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

                                  • Re: Circuit bandwidth exceeded
                                    bob.jones

                                    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