Datamining: Difference between revisions

From Open-Xchange
 
(3 intermediate revisions by 2 users not shown)
Line 11: Line 11:


=Usage=
=Usage=
  /opt/open-xchange/sbin datamining
  /opt/open-xchange/sbin/datamining


=Available Parameters=
=Available Parameters=


-?, -h, --help                         Print the available parameters
-?, -h, --help                         Print the available parameters
                  
                  
-d, --dbName <dbname>                   Name of the MySQL-database that contains the Open-Xchange configDB  (default: configdb)                         
-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)                       
--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                   
-n, --hostname <hostname>             Host where the Open-Xchange MySQL-database is running                   
 
-p, --dbPassword <dbpassword>         Password for the user specified with "-dbUser"                               
-p, --dbPassword <dbpassword>         Password for the user specified with "-dbUser"                               
 
--reportfilePath <path>                 Path where the report-file is saved (default: )                           
--reportfilePath <path>               Path where the report-file is saved (default: )                           
 
-u, --dbUser <dbuser>                 Name of the MySQL-User for configdb     
-u, --dbUser <dbuser>                 Name of the MySQL-User for configdb     
 
-v, --verbose                           With this the tool prints what it is doing live
-v, --verbose                         With this the tool prints what it is doing live


=What questions are answered?=
=What questions are answered?=
*numberOfSchemata
*numberOfSchemata
*averageFilestoreSize
*AverageFilestoreSize
*numberOfContexts
*NumberOfContexts
*numberOfUsers
*NumberOfUsers
*numberOfUsersWithEventsInPrivateCalendar
*NumberOfAppointments
*numberOfUsersWithEventsInPrivateCalendarThatAreInTheFutureAndAreNotYearlySeries
*NumberOfUsersWhoCreatedAppointments
*numberOfUsersWhoChangedTheirCalendarInTheLast30Days
*MaximumNumberOfCreatedAppointmentsForOneUser
*numberOfInfostoreObjects
*AverageNumberOfAppointmentsPerUserWhoHasAppointmentsAtAll
*averageNumberOfInfostoreObjectsPerContext
*NumberOfUsersWithEventsInPrivateCalendarThatAreInTheFutureAndAreNotYearlySeries
*averageNumberOfInfostoreObjectsPerSchema
*NumberOfUsersWhoChangedTheirCalendarInTheLast30Days
*numberOfNewInfostoreObjectsInTheLast30Days
*NumberOfDocuments
*numberOfChangedInfostoreObjectsInTheLast30Days
*NumberOfUsersWhoCreatedDocuments
*numberOfUsersWithNewInfostoreObjectsInTheLast30Days
*MaximumNumberOfCreatedDocumentsForOneUser
*numberOfDocumentsBetween1ByteAnd3KB
*AverageNumberOfDocumentsPerUserWhoHasDocumentsAtAll
*numberOfDocumentsBetween3KBAnd10KB
*AverageNumberOfInfostoreObjectsPerContext
*numberOfDocumentsBetween10KBAnd30KB
*AverageNumberOfInfostoreObjectsPerSchema
*numberOfDocumentsBetween30KBAnd100KB
*NumberOfNewInfostoreObjectsInTheLast30Days
*numberOfDocumentsBetween100KBAnd300KB
*NumberOfChangedInfostoreObjectsInTheLast30Days
*numberOfDocumentsBetween300KBAnd1MB
*NumberOfUsersWithNewInfostoreObjectsInTheLast30Days
*numberOfDocumentsBetween1MBAnd3MB
*SliceAndDiceOnDocumentSize
*numberOfDocumentsBetween3MBAnd10MB
*AverageDocumentSize
*numberOfDocumentsBetween10MBAnd30MB
*NumberOfContacts
*numberOfDocumentsBetween30MBAnd100MB
*NumberOfUserCreatedContacts
*numberOfDocumentsBetween100MBAnd300MB
*NumberOfUsersWhoHaveContacts
*numberOfDocumentsBetween300MBAnd1GB
*NumberOfUsersWhoCreatedContacts
*numberOfDocumentsBetween1GBAndINFINITE
*MaximumNumberOfContactsForOneUser
*numberOfContacts
*MaximumNumberOfCreatedContactsForOneUser
*numberOfUsersWhoCreatedContacts
*AverageNumberOfContactsPerUserWhoHasContactsAtAll
*numberOfUsersWhoChangedTheirContactsInTheLast30Days
*AverageNumberOfContactsPerUserWhoHasCreatedContacts
*averageNumberOfContactsPerUserWhoHasContactsAtAll
*NumberOfUsersWhoChangedTheirContactsInTheLast30Days
*numberOfUsersWithLinkedSocialNetworkingAccounts
*NumberOfUsersWithLinkedSocialNetworkingAccounts
*numberOfUsersWhoSelectedTeamViewAsCalendarDefault
*NumberOfUsersConnectedToFacebook
*numberOfUsersWhoSelectedCalendarViewAsCalendarDefault
*NumberOfUsersConnectedToLinkedIn
*numberOfUsersWhoSelectedListViewAsCalendarDefault
*NumberOfUsersConnectedToTwitter
*numberOfUsersWhoSelectedCardsViewAsContactsDefault
*NumberOfUsersConnectedToGoogle
*numberOfUsersWhoSelectedListViewAsContactsDefault
*NumberOfUsersConnectedToMSN
*numberOfUsersWhoSelectedListViewAsTasksDefault
*NumberOfUsersConnectedToYahoo
*numberOfUsersWhoSelectedHSplitViewAsContactsDefault
*NumberOfUsersConnectedToXing
*numberOfUsersWhoSelectedListViewAsInfostoreDefault
*NumberOfUsersConnectedToTOnline
*numberOfUsersWhoSelectedListViewAsContactsDefault
*NumberOfUsersConnectedToGMX
*numberOfUsersWhoActivatedMiniCalendar
*NumberOfUsersConnectedToWebDe
*NumberOfTasks
*NumberOfUsersWhoCreatedTasks
*MaximumNumberOfCreatedTasksForOneUser
*AverageNumberOfTasksPerUserWhoHasTasksAtAll
*NumberOfUsersWhoChangedTheirTasksInTheLast30Days
*NumberOfUsersWhoSelectedTeamViewAsCalendarDefault
*NumberOfUsersWhoSelectedCalendarViewAsCalendarDefault
*NumberOfUsersWhoSelectedListViewAsCalendarDefault
*NumberOfUsersWhoSelectedCardsViewAsContactsDefault
*NumberOfUsersWhoSelectedListViewAsContactsDefault
*NumberOfUsersWhoSelectedListViewAsTasksDefault
*NumberOfUsersWhoSelectedHSplitViewAsTasksDefault
*NumberOfUsersWhoSelectedListViewAsInfostoreDefault
*NumberOfUsersWhoSelectedHSplitViewAsInfostoreDefault
*NumberOfUsersWhoActivatedMiniCalendar
*NumberOfUsersWhoLoggedInWithClientOX6UIInTheLast30Days
*NumberOfUsersWhoLoggedInWithClientAppSuiteUIInTheLast30Days
*NumberOfUsersWhoLoggedInWithClientMobileUIInTheLast30Days
*NumberOfUsersWhoLoggedInWithClientEASInTheLast30Days
*NumberOfUsersWhoLoggedInWithClientCalDAVInTheLast30Days
*NumberOfUsersWhoLoggedInWithClientCardDAVInTheLast30Days

Latest revision as of 06:33, 15 May 2013

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 for now 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.

Install on OX AppSuite

Debian GNU/Linux 11.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present: 

deb https://software.open-xchange.com/products/stable/DebianBullseye/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/stable/updates/DebianBullseye/ /

and run 

$ apt-get update
$ apt-get install open-xchange-datamining

Debian GNU/Linux 12.0

Add the following entry to /etc/apt/sources.list.d/open-xchange.list if not already present: 

deb https://software.open-xchange.com/products/stable/DebianBookworm/ /
# if you have a valid maintenance subscription, please uncomment the 
# following and add the ldb account data to the url so that the most recent
# packages get installed
# deb https://[CUSTOMERID:PASSWORD]@software.open-xchange.com/products/stable/updates/DebianBookworm/ /

and run 

$ apt-get update
$ apt-get install open-xchange-datamining


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?

  • numberOfSchemata
  • AverageFilestoreSize
  • NumberOfContexts
  • NumberOfUsers
  • NumberOfAppointments
  • NumberOfUsersWhoCreatedAppointments
  • MaximumNumberOfCreatedAppointmentsForOneUser
  • AverageNumberOfAppointmentsPerUserWhoHasAppointmentsAtAll
  • NumberOfUsersWithEventsInPrivateCalendarThatAreInTheFutureAndAreNotYearlySeries
  • NumberOfUsersWhoChangedTheirCalendarInTheLast30Days
  • NumberOfDocuments
  • NumberOfUsersWhoCreatedDocuments
  • MaximumNumberOfCreatedDocumentsForOneUser
  • AverageNumberOfDocumentsPerUserWhoHasDocumentsAtAll
  • AverageNumberOfInfostoreObjectsPerContext
  • AverageNumberOfInfostoreObjectsPerSchema
  • NumberOfNewInfostoreObjectsInTheLast30Days
  • NumberOfChangedInfostoreObjectsInTheLast30Days
  • NumberOfUsersWithNewInfostoreObjectsInTheLast30Days
  • SliceAndDiceOnDocumentSize
  • AverageDocumentSize
  • NumberOfContacts
  • NumberOfUserCreatedContacts
  • NumberOfUsersWhoHaveContacts
  • NumberOfUsersWhoCreatedContacts
  • MaximumNumberOfContactsForOneUser
  • MaximumNumberOfCreatedContactsForOneUser
  • AverageNumberOfContactsPerUserWhoHasContactsAtAll
  • AverageNumberOfContactsPerUserWhoHasCreatedContacts
  • NumberOfUsersWhoChangedTheirContactsInTheLast30Days
  • NumberOfUsersWithLinkedSocialNetworkingAccounts
  • NumberOfUsersConnectedToFacebook
  • NumberOfUsersConnectedToLinkedIn
  • NumberOfUsersConnectedToTwitter
  • NumberOfUsersConnectedToGoogle
  • NumberOfUsersConnectedToMSN
  • NumberOfUsersConnectedToYahoo
  • NumberOfUsersConnectedToXing
  • NumberOfUsersConnectedToTOnline
  • NumberOfUsersConnectedToGMX
  • NumberOfUsersConnectedToWebDe
  • NumberOfTasks
  • NumberOfUsersWhoCreatedTasks
  • MaximumNumberOfCreatedTasksForOneUser
  • AverageNumberOfTasksPerUserWhoHasTasksAtAll
  • NumberOfUsersWhoChangedTheirTasksInTheLast30Days
  • NumberOfUsersWhoSelectedTeamViewAsCalendarDefault
  • NumberOfUsersWhoSelectedCalendarViewAsCalendarDefault
  • NumberOfUsersWhoSelectedListViewAsCalendarDefault
  • NumberOfUsersWhoSelectedCardsViewAsContactsDefault
  • NumberOfUsersWhoSelectedListViewAsContactsDefault
  • NumberOfUsersWhoSelectedListViewAsTasksDefault
  • NumberOfUsersWhoSelectedHSplitViewAsTasksDefault
  • NumberOfUsersWhoSelectedListViewAsInfostoreDefault
  • NumberOfUsersWhoSelectedHSplitViewAsInfostoreDefault
  • NumberOfUsersWhoActivatedMiniCalendar
  • NumberOfUsersWhoLoggedInWithClientOX6UIInTheLast30Days
  • NumberOfUsersWhoLoggedInWithClientAppSuiteUIInTheLast30Days
  • NumberOfUsersWhoLoggedInWithClientMobileUIInTheLast30Days
  • NumberOfUsersWhoLoggedInWithClientEASInTheLast30Days
  • NumberOfUsersWhoLoggedInWithClientCalDAVInTheLast30Days
  • NumberOfUsersWhoLoggedInWithClientCardDAVInTheLast30Days
Retrieved from "https://wiki.open-xchange.com/wiki/index.php?title=Datamining&oldid=14553"