Difference between revisions of "Datamining"

Line 10: Line 10:
 
Usage:
 
Usage:
 
  /opt/open-xchange/sbin datamining
 
  /opt/open-xchange/sbin datamining
 +
 +
Available Parameters:
 +
 +
-?, -h, --help                          Print this helpfile                   
 +
-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?

Revision as of 12:17, 11 January 2012

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 this helpfile -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?