cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to Export Individual Client Usage That Only Lets You View

Highlighted
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
Highlighted
Kind of a big deal

Re: How to Export Individual Client Usage That Only Lets You View

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

Highlighted
Comes here often

Re: How to Export Individual Client Usage That Only Lets You View

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

Highlighted
Kind of a big deal

Re: How to Export Individual Client Usage That Only Lets You View

Those instructions are specific to the collector.

Highlighted
Comes here often

Re: How to Export Individual Client Usage That Only Lets You View

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

Building a reputation

Re: How to Export Individual Client Usage That Only Lets You View

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

Re: How to Export Individual Client Usage That Only Lets You View

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.

Highlighted
Here to help

Re: How to Export Individual Client Usage That Only Lets You View

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.

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.