[RELEASE] TS3logAnalyser - Analyse your teamspeak server logs

[ToFran]

Greetings,
I'm (re)-announcing ts3logAnalyser!
It allows you to analyze your TeamSpeak server logs and generate relevant statistics with it:

• Who has the most cumulative connection time on the server / Time spent by each user on server
• Longest connection time for each user
• First and last seen
• Most used nicknames
• Total number of connections
• No bot required, only ts3 logfiles.
• And much more!

A full description of ts3logAnalyser can be found on github.

Here's the stats page from my server with data generated with this tool:

It works quite well in my tests: Scanned logs from 2014-02-22 until today (2017-05-01).

If you found this useful leave your opinion

Original post from 2015 @ pastebin: eNgLFGMS
Hey,

I'm developing a Java program to analyse TeamSpeak server logs.
I have seen some people requesting this and I was really interested in seeing how many time I have spent on my server.

What it does:

• Reads multiple log files or an entire folder loaded with them;
• Stores info about all clients, such as:
  
  • Most used nickname;
  • cumulative connection time;
  • maximum connection time;
  • number of connections;
  • number of time outs;
• Outputs a file to easily Analyse in Excel;

How:
Just run TS3logAnalyser.jar with java and start using it.
I have included a run.bat for windows users.
The output file data is separated by tabs, just save it as .txt and open with excel for analysing the data;

Example output (Google spreadsheets): here


This is NOT a finished project, expect bugs
Known bugs:

• During the daylight savings hour (yes, exactly when the hour changes) connections get a null time;
• Sometimes maximum connection time may bug, I'm working on that (check the Example output and you will see the 3 top maximums)
• Some usernames/channel names may interfere the indexing, check PLEASE REPORT them;

To-do:

• Add the number of:
  
  • bans;
  • kicks;
  • permissions assigned;
  • channels created;
• Option to enable debugging.

-Removed-

Source available on GitHub

[madtec]

Nice program keep on working :-)

[ToFran]

@madtec

Thank you, that means a lot to me

[ToFran]

Updated
1.22-beta

ChangeLog:
Improved User Interface;
No double slashing now;
Added a Readme to download file;
Proper versioning;
Updated post screenshots.


*and a shameful English syntax error removed

[chickenputty]

I keep receiving the following error:

Exception in thread "main" java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(String.java:1955)
at FileReader.getId(FileReader.java:110)
at FileReader.getTime(FileReader.java:133)
at FileReader.readFile(FileReader.java:101)
at FileReader.execute(FileReader.java:48)
at Main.readFile(Main.java:78)
at Main.main(Main.java:36)

This happens when it tries to read a log with invalid characters that are created, when I assume, the TS server had crashed.

[ToFran]

@chickenputty

thanks for the feedback,
those characters are really weird, I never got those,
I will try to fix that, in the meanwhile you can simply remove that line before analysing.

EDIT:
That happens because the program presumes that every line has basic info like the time.

ToFran

[chickenputty]

@chickenputty

thanks for the feedback,
those characters are really weird, I never got those,
I will try to fix that, in the meanwhile you can simply remove that line before analysing.

EDIT:
That happens because the program presumes that every line has basic info like the time.

ToFran

Understood.

When saving the file I also receive this error:

Exception in thread "main" java.util.UnknownFormatConversionException: Conversion = 'k'
at java.util.Formatter$FormatSpecifier.conversion(For matter.java:2691)
at java.util.Formatter$FormatSpecifier.<init>(Formatt er.java:2720)
at java.util.Formatter.parse(Formatter.java:2560)
at java.util.Formatter.format(Formatter.java:2501)
at java.util.Formatter.format(Formatter.java:2455)
at FileWriter.saveToFile(FileWriter.java:43)
at FileWriter.<init>(FileWriter.java:19)
at Main.saveToFile(Main.java:93)
at Main.main(Main.java:32)

I am running this through bash on Ubuntu, if that helps.

[ToFran]

@chickenputty

I found it: IllegalFormatException
But that will not help, I can only catch the error.

Does that crash with every log, or just one?
Is there any "%" in you log?

+To-do: add an option to the compiled version to enable debug mode.

ToFran

[ToFran]

Hello guys,
After all I did not went missing forever
I have re-built this program from scratch, more information in the original, now edited post.
Regards