Datamining

From Open-Xchange
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

What is this?

This is a simple Tool to get an idea how a specific installation of Open-Xchange is used. Operating on the MySQL-database exclusively it is quite fast and uses few resources. Off-hours are still recommended for its usage to limit any performance-impact, though. It will find its required parameters automatically in the file /opt/open-xchange/etc/groupware/configdb.properties. It is also possible to specify all parameters explicitly. Output is a single text-file. The filename starts with "open-xchange_datamining" and includes the current date in YYYY-MM-DD format. The content of the file is camelCased-Parameters, unique and one per line. This should make using these files as input, for example for a visualization, pretty easy.

Usage

/opt/open-xchange/sbin datamining

Available Parameters

-?, -h, --help Print the available parameters

-d, --dbName <dbname> Name of the MySQL-database that contains the Open-Xchange configDB (default: configdb)

--dbPort <port> Port where MySQL is running on the host specified with "-hostname" (default: 3306)

-n, --hostname <hostname> Host where the Open-Xchange MySQL-database is running

-p, --dbPassword <dbpassword> Password for the user specified with "-dbUser"

--reportfilePath <path> Path where the report-file is saved (default: )

-u, --dbUser <dbuser> Name of the MySQL-User for configdb

-v, --verbose With this the tool prints what it is doing live

What questions are answered?