I need to know the max usage of a set of interfaces. Portchannel 3 on nexus-a and nexus-b.
Please check both the port channels and the separate interfaces. Eth1/3-Eth1/6.
I need to know the absolute max bps for this connection, the other side is the 4500x and the ports on that side should be labeled properly. Let me know if you have any questions.
I have already created a query, but the issue is the date & time does not pull work and only show today date for the report
SELECT TOP 1000 n.Caption AS NodeName, n.IPAddress AS IPAddress, ncp.County AS County, ncp.CountyID AS CountyID, ncp.LocationID AS LocationID, ncp.Site_Name AS SiteName, i.Caption AS InterfaceName, (i.MaxInBpsToday / 1000000) AS MaxInMbpsToday, (i.MaxOutBpsToday / 1000000) AS MaxOutMbpsToday, (it.InMaxbps / 1000000) AS AbsoluteMaxInMbps, (it.OutMaxbps / 1000000) AS AbsoluteMaxOutMbps, GETDATE() AS [DateTime] FROM Orion.NodesCustomProperties AS ncp INNER JOIN Orion.Nodes AS n ON ncp.NodeID = n.NodeID INNER JOIN Orion.NPM.Interfaces AS i ON n.NodeID = i.NodeID INNER JOIN Orion.NPM.InterfaceTraffic AS it ON i.InterfaceID = it.InterfaceID WHERE (i.Caption = 'Port-Channel3' OR i.Caption IN ('Ethernet1/3 · Trunk to 4500-X', 'Ethernet1/4 · Trunk to 4500-X', 'Ethernet1/5 · Trunk to 4500-X', 'Ethernet1/6 · Trunk to 4500-X')) AND n.Caption IN ('AOC-NEXUS-A', 'AOC-NEXUS-B')
SELECT TOP 1000 n.Caption AS NodeName, n.IPAddress AS IPAddress, ncp.County AS County, ncp.CountyID AS CountyID, ncp.LocationID AS LocationID, ncp.Site_Name AS SiteName, i.Caption AS InterfaceName, (i.MaxInBpsToday / 1000000) AS MaxInMbpsToday, (i.MaxOutBpsToday / 1000000) AS MaxOutMbpsToday, (it.InMaxbps / 1000000) AS AbsoluteMaxInMbps, (it.OutMaxbps / 1000000) AS AbsoluteMaxOutMbps, GETDATE() AS [DateTime] FROM Orion.NodesCustomProperties AS ncp INNER JOIN Orion.Nodes AS n ON ncp.NodeID = n.NodeID INNER JOIN Orion.NPM.Interfaces AS i ON n.NodeID = i.NodeID INNER JOIN Orion.NPM.InterfaceTraffic AS it ON i.InterfaceID = it.InterfaceID WHERE (i.Caption = 'Port-Channel3' OR i.Caption IN ('Ethernet1/3 · Trunk to 4500-X', 'Ethernet1/4 · Trunk to 4500-X', 'Ethernet1/5 · Trunk to 4500-X', 'Ethernet1/6 · Trunk to 4500-X')) AND n.Caption IN ('AOC-NEXUS-A', 'AOC-NEXUS-B')
