Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Quarterly output

Is it possible in NTA to get a quarterly report showing how much data has passed through an enterprise MPLS network per VRF? Assume there are at least 80 VRFs.

We want to be able to see how many gigabytes a specific VRF (customer) has used, and then generate output/reporting from that. So the requirement is simply: how much data (per quarter) has gone through each VRF.

thank you in advanced.

kind regards,

Michel

Find more posts tagged with

Accepted answers

All comments

Lofstrand

Can this query work for you?

It is not using NTA as you only want to know the amount of traffic, not the type. It's looking at the interfaces connected to each VRF.

SELECT

I.node.Caption as [NodeName]

,i.Caption  AS [IntName]

,VRF.Name

, RouteDistinguisher

,T.Mbytes

FROM Orion.Routing.VRF AS VRF

INNER JOIN Orion.NPM.Interfaces AS I ON VRF.Interfaces.IfIndex=I.InterfaceIndex AND VRF.NodeID=I.NodeID

INNER JOIN

(

SELECT

IT.NodeID

,IT.InterfaceID

--InTotalBytes,  OutTotalBytes

,SUM(IT.TotalBytes)/1024/1024 AS MBytes

FROM Orion.NPM.InterfaceTraffic AS IT

WHERE

IT.DateTime BETWEEN '2024-09-30' AND '2026-01-01'

GROUP BY

IT.NodeID,IT.InterfaceID

) AS T ON I.NodeID=T.Nodeid AND I.InterfaceID=T.InterfaceID

MichelLprive

I've no idea, because we are not using NTA.

Now we have ntopng but we are not happy with this tool.

Lofstrand

Sending you a PM