Hi,
we have an installation of Wingate 6.2 where users have a limit of X Mb of traffic per month (after that, they can buy extra credit for a small fee).
Sometimes users complain that their account is finished, but that they feel it's not real - they didn't download anything significant, didn't spend that much time online, etc.
I would like to be able to analyze a user's account to help him understand where the megabytes are going... for example, tell him he spent 38 MB on Window Update, 56 on Youtube, etc.
My problem is that Wingate's traffic logs tend to be huge and lines don't seem to be coherently structured (or perhaps they are, but I'm not seeing it). Can I load these logs into Excel and get the information I need?
One of the problems seems to be that a single network request produces more than one line on the log: the server name comes in one line, and the amount of traffic comes in another line... not very easy to analyze automatically.
Can anyone help with some advice?
Thanks in advance.