Export LAN port activity

[torstensson]

Hi there,

I've been looking into getting some statistics regarding the usage of LAN ports on a large site. The wireless is easy to find and export, same goes for VPN users but measuring the usage of LAN ports with users authenticated with .1x seems to be a bit harder to find and .

Is there any way to present this data in a visual way?

Br

Lars-Ove

[balaji.bandi]

NMS is the good tool per port basis, or you can use netflow if you looking application based.

You can use Elastic Search / Grafana  for the Vidual representation if your NMS not providing that informatio.

[torstensson]

Hi, 

I've used NMS before and I remember it being quite good. But what about Cisco, do they have any application that can provide this function? The customer don't really want to hear that they bought an advanced tool and still need to use yet another application to do a quite simple task XD

Br

Lars

[balaji.bandi]

Sure if you have budget, PRIME can do some functions, if they are new switches, like Cat 9K, DNAC does the Assurance and telemetry. (is this what you looking ?)

[torstensson]

I think so yeah, the whole network should be 9300 devices as well. Where in Assurance can I do this, I can only locate statistics for WLAN data =_=

[teja.vemula]

Not sure which option you are referring to so I am providing two answers.

Ports utilization on the switch

If you go to Provision-->Inventory-->Select the switch-->On the left hand side you have interfaces Ethernet ports which has the list of connected, not connected ports on the switch.

interface TX RX utilization on the switchport interface.

Device 360 of that particular switch--> Scroll down on that page and you will find Device Information--> Select interfaces tab and select the interface you want to see the utilization for--> scroll more down and it will show you Tx Rx utilization.

[rasmus.elmholt]

Hi,

I agree here, all the data on individual port usage is collected by the DNA Center, It should be possible to export this data historically from the DNAC on each individual port.

The graph is available under Device 360 for a switch and at the bottom of the page.

[rasmus.elmholt · Accepted solution]

If you want the interface up down statistics you can find it using:

https://dnac-ip/api/assurance/v1/network-device/assurance-metric?page=1&pageSize=4000&order=ASC

{"entity":{"_id":"4b89244a-dc2b-4cb8-8e23-55d726605625"},
"dimensions":[{"name":"o_interfaceName","value":"FiveGigabitEthernet1/0/15"}],"name":"derivedInterfaceAvailability","timeRange":{"start":"2021-09-26T12:03:02.902Z","end":"2021-09-27T12:03:02.902Z"}}

This will return a paginated records list:

{"modificationtime":"1632657900000","availability":"0"},

The same can be done to get avgInputUtil:

{"entity":{"_id":"10.240.234.66-FiveGigabitEthernet1/0/15"},"name":"deviceInterfaceStatsAggregation","fields":["avgInputUtil","avgOutputUtil"],"timeRange":{"start":"2021-09-26T12:03:02.902Z","end":"2021-09-27T12:03:02.902Z"},"window":"5 min"}

All of this has been taken from the Chrome developer tool using the GUI requests.