Version 1

    we report a fairly big MPLS WAN worldwide with CAR on subinterfaces ranging 256kbits to 10Gbits. Average utilizations need to be calculated over different summarization time framed from 30min on high bandwidth links to 2hrs for the lower bandwidth links.

    Customized advanced SQL reports allow for this distinction. We use a couple of custom properties to identify Wan Interfaces and subinterfaces. The challenge was actually to get the last month times frames implemented. But see for yourself.

    Last Month - Interface Utilization - Transmit
            VRFClient Access RateOccurenceTransmit Utilization
    1.) Utilization/120min >= 80% for Bandwidth <=2Mbit/s
     APAC
      0000003922.000001
       cn-vwa-shang-ce-01
            PFN 1.98 Mbps 17-Nov-08 12:00 87.86 %      
            PFN 1.98 Mbps 18-Nov-08 14:00 92.08 %      
    2.) Utilization/60min >= 80% for 2Mbit/s < Bandwidth <=34Mbit/s   
      0000002688.000002 
       jp-vwa-tokyo-ce-03
            CBB internat 2.05 Mbps 14-Nov-08 08:00 93.66 %      
            CBB internat 2.05 Mbps 14-Nov-08 09:00 85.79 %      
     EMEA  
      0000003521.000001 
       cz-vwa-pragu-ce-01
            CBB internat 18 Mbps 10-Nov-08 13:00 82.31 %      
            CBB internat 18 Mbps 10-Nov-08 14:00 89.65 %      
            CBB internat 18 Mbps 18-Nov-08 17:00 88.16 %      
     Germany  
      0000003079.000006 
       de-vwa-frech-ce-01
            CBB national 3.84 Mbps 02-Nov-08 22:00 93.96 %      
            CBB national 3.84 Mbps 06-Nov-08 21:00 82.53 %      
      0000003079.000009 
       de-vwa-potsd-ce-01
            CBB national 20 Mbps 05-Nov-08 01:00 82.30 %      
            CBB national 20 Mbps 06-Nov-08 22:00 83.47 %      
            CBB national 20 Mbps 09-Nov-08 22:00 83.47 %      
    3.) Utilization/30min >= 60% for 34Mbit/s < Bandwidth <=155Mbit/s   
      RPRoff-09120-chem01 
       de-vwa-chem02-ce-01
            Marke 50 Mbps 30-Nov-08 01:00 72.03 %      
      RPRon-85057-ingo02 
       de-vwa-ingo01-ce-02
            CBB Gyoer 60 Mbps 11-Nov-08 14:00 60.90 %      
            CBB Gyoer 60 Mbps 12-Nov-08 14:00 63.62 %