The Web Filter logs contain powerful data - we need better methods to search it
I'd like to see a way to export the entire log, as well as subsets of the log, determined by search criteria in the user interface.
We recently had a night shift custodian surfing the web when he was supposed to be cleaning. We knew which computer (IP Address) he was using, but needed to gather data on when he was using it, over the last few weeks.
I had to search the Web Filter logs, 2 hours at a time, 200 hits at a time, for each day, and write down when activity started and stopped.
There NEEDS to be an easier way.
The export button seems to only export what's being shown. With a maximum of 200 records shown at a time, that's not very helpful.
Also, the exported file is tab delimited, but exports as a CSV file, which indicates commas as a delimiter.
Also, the time is some kind of serial number that Excel nor anything else I tried seems to be able to decode.
Jay Duff commented
Thanks for the info. Is there a function in Excel and/or GoogleSheets to convert it to human-readable format?