How to count users?

[_slv_]

Hi

I have interesting problem to make a report of users activity. I'd like to make a report that will show how many students uses WiFi network in every hour (quoter of hour). I tryed to find option that let me do that - but I didn't find one. So I need Your help.

Probalby I should interest in API and Excell.

Is it possible to connect MS Excell directly to PAN? or do I need to first save a file on disk and next using PivotTable make my report?

I'm waiting for You sugesstions and examples

Regards

Slawek

[bj_fox1]

I can't comment on how to automatically pull the data directly into excel because we've never tried/bothered. The two options we use for reporting are:

1.) Export the CSV and manually manipulate the data in excel.

2.) Setup the free (500Mb/day limited) version of Splunk with the "Splunk for PaloAlto Networks" app from Splunkbase. That gives you a lot of useful built-in reports and almost unlimited options for creating custom reports from any of the log data.

Hope that helps!