Recently our billing team has asked me if its possible to use NTA for creating usage report on each active sub-interfaces.
The report should include the following tables:
Date, Source IP, Destination IP, Port, Bytes
We have 180 Cisco 3800/3900 series with an average of 50 sub-interface per router.
NTA Database is set to 240 mins uncompressed as we use this option often when a location is near 100% WAN utilization.
Is there some reporting tool or 3rd party application that I can use to grab NTA data from the SQL database before compression is applied after 240 mins and aggregate all data every day, creating a report for our billing team?