Produce WIFI stats on an excel spreadsheet from .txt file
£20-250 GBP
Abgeschlossen
Veröffentlicht vor mehr als 11 Jahren
£20-250 GBP
Bezahlt bei Lieferung
We have log files from a WIFI system which output in .txt file- see attached sample
We want to do the following:
1. Method to take .txt file and compile the below in excel
2. Count the number of times “GET /[login to view URL]” is displayed each day and display in a table for each day of the month- this is the number of unique users who accessed the WIFI
3. Count the number of times “GET /[login to view URL]” is displayed each hour and display in a table for each hour of the day (total this over the month)- this is the number of unique users per hour to show the busiest hours
4. Take each “GET/************.html” listing and count the numbers each page was accessed and display in a table
5. When a mac address (78:ca:39:86:9e:69) is first seen, take its time and when last seen, take its time, then subtract the two to display the minutes and seconds. Count each of these and put into a table for 0-30secs, 31-60secs,61-120secs,121-240secs,241secs+- this will show the length of time people were on the site
6. There will be further modifications in the future