How to Export Individual Client Usage That Only Lets You View

jchang
Comes here often

How to Export Individual Client Usage That Only Lets You View

The individual client usage page lets you view the usage graph, but how do you export to excel? Because the time interval choices on that usage graph is very limited, and it only has a)for last 2 hours, b)for last day, c)for last week, d)for last month.The  individual client page is the one where you click on Firewall on dashboard >> Networkwide >> Monitor column >> Clients >> then click on any client. On that per client page is the graph, so how do you export to excel or show more time intervals?

 

Jchang

Hawaii

7 REPLIES 7
PhilipDAth
Kind of a big deal
Kind of a big deal

The data is already aggregated by that point.  You can't export in that view, or show anything other than the pre-defined time periods.

 

If you need to do more complex anaylsis you'll need to consider using Syslog or Netflow, and use a third party tool to do the analysis that you require.

https://documentation.meraki.com/zGeneral_Administration/Monitoring_and_Reporting/Syslog_Server_Over...

https://documentation.meraki.com/MX/Monitoring_and_Reporting/NetFlow_Overview

Thanks so much for your very clear response. That means I will either use Syslog or Netflow. Do you have instructions on how to setup a netlflow collector?

 

jchang

PhilipDAth
Kind of a big deal
Kind of a big deal

Those instructions are specific to the collector.

I did a search and there is some netflow analyzer and collectors for windows.

https://www.comparitech.com/net-admin/best-netflow-analyzers-collectors/

 

Which one do you is free and easy to use?

 

jchang

Cmiller
Building a reputation

Time to run down a youtube rabbit hole, this is a good one to start on: https://www.youtube.com/watch?v=4paFvgJ9pds
Todd_Z
Here to help

I've had the same issues you are explaining. From time to time management will ask about a users browsing history and the situation you are talking about is a good example of some of the limits the GUI offers. Like it was mentioned above you can SysLog all the data, this is what I do. But please beware if you've never done SysLog it's a lot of data, very techie but very cool and will provide you a ton of information. You can take the syslog data and put it all into excel too.

Todd_Z
Here to help

We had the same problem with our management wanting to know which website specifically a person has been visiting. Like it was mentioned above SysLog was a great answer. Beware if you haven't done syslog before it's a lot of data, very techie, but very cool. You can take it all and put it into excel, or whatever you prefer.

Get notified when there are additional replies to this discussion.
Welcome to the Meraki Community!
To start contributing, simply sign in with your Cisco account. If you don't yet have a Cisco account, you can sign up.
Labels