trcanal

TrueConf log analyzer

This utility extracts some basic statistics from TrueConf log file, enriching them from Active Directory. It extracts conferences start timestamp, topic for conferences, list of participatiing users and total time in minutes. Any username is assumed to be a SAMAccountName and is checked against Active Directory. If found, the username is replaced with displayName attribute from AD record. Usernames with and without hostname attached with @ are considered to be the same. Usernames with '#' as the first symbol are ignored. Conferences that were less than 5 minutes long are skipped, because in 99% they are irrelevant.

install

This utility saves extracted data into a MS SQL database, so you'll have to created two tables to store the data. Create tables as follows:

CREATE TABLE [dbo].[VKSSESSIONS](
	[id] [nchar](16) NOT NULL,
	[topic] [nchar](256) NOT NULL,
	[start_time] [datetime] NOT NULL,
	[end_time] [datetime] NOT NULL
)

CREATE TABLE [dbo].[VKSUSERS](
	[id] [nchar](16) NOT NULL,
	[name] [nchar](128) NOT NULL
) 

config

Connection credentials and other information is stored in .config file along with the executable. The meaning of keys is described below:

Server

MS SQL Server host name

UserID

MS SQL login name

Password

MS SQL user password

Database

MS SQL database name

ldapUserID

Domain login

ldapPassword

Domain password

ldapServerv

Domain Controller hostname

UserStore

Organisation Unit where to look up users

usage

trcanal.exe -file=P:\ath\to\stdout.log

license

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, version 3 of the License.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see https://www.gnu.org/licenses/.