Forum Discussion

ashafran's avatar
9 months ago

95th Percentile Billing - Aggregate Interfaces

Hi, I need to pull a report on 95th percentile usage of internet transit for my organization. Our way of documenting this is by putting a description on each interface of our routers/switches/firewalls where the format is [SID#XXXXX] where XXXX is replaced with a 5 digit number of the client’s subscription ID. We need to pull a report for all interfaces with that same code and add them together to find the aggregate internet transit for each of our customers. Would someone be able to assist us? Thanks, Adam

  • Anonymous's avatar
    Anonymous

    The closest you’ll be able to get within the product is to run an “Interface Bandwidth” report. You’ll be able to filter by interface alias and description. Set the output to CSV then use some spreadsheet magic to group and add the interface pairs.