Datamining - Revision history

Karsten.will: /* What questions are answered? */

2013-05-15T06:33:36Z

What questions are answered?

← Older revision		Revision as of 06:33, 15 May 2013
Line 46:		Line 46:
	*MaximumNumberOfCreatedDocumentsForOneUser		*MaximumNumberOfCreatedDocumentsForOneUser
	*AverageNumberOfDocumentsPerUserWhoHasDocumentsAtAll		*AverageNumberOfDocumentsPerUserWhoHasDocumentsAtAll
	~~reportAverageNumberOfInfostoreObjectsPerContext~~		*AverageNumberOfInfostoreObjectsPerContext
	~~reportAverageNumberOfInfostoreObjectsPerSchema~~		*AverageNumberOfInfostoreObjectsPerSchema
	*NumberOfNewInfostoreObjectsInTheLast30Days		*NumberOfNewInfostoreObjectsInTheLast30Days
	*NumberOfChangedInfostoreObjectsInTheLast30Days		*NumberOfChangedInfostoreObjectsInTheLast30Days

Karsten.will: /* What questions are answered? */

2013-05-15T06:33:10Z

What questions are answered?

← Older revision		Revision as of 06:33, 15 May 2013
Line 33:		Line 33:
	=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~~		reportAverageNumberOfInfostoreObjectsPerContext
	*~~numberOfDocumentsBetween10KBAnd30KB~~		reportAverageNumberOfInfostoreObjectsPerSchema
	*~~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

WolfgangRosenauer: /* Available Parameters */

2012-11-28T11:41:05Z

Available Parameters

← Older revision		Revision as of 11:41, 28 November 2012
Line 15:		Line 15:
	=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?=

WolfgangRosenauer at 11:39, 28 November 2012

2012-11-28T11:39:24Z

← Older revision		Revision as of 11:39, 28 November 2012
Line 11:		Line 11:

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

	=Available Parameters=		=Available Parameters=

Karsten.will: /* What questions are answered? */

2012-01-11T12:27:28Z

What questions are answered?

← Older revision		Revision as of 12:27, 11 January 2012
Line 32:		Line 32:

	=What questions are answered?=		=What questions are answered?=
			*numberOfSchemata
			*averageFilestoreSize
			*numberOfContexts
			*numberOfUsers
			*numberOfUsersWithEventsInPrivateCalendar
			*numberOfUsersWithEventsInPrivateCalendarThatAreInTheFutureAndAreNotYearlySeries
			*numberOfUsersWhoChangedTheirCalendarInTheLast30Days
			*numberOfInfostoreObjects
			*averageNumberOfInfostoreObjectsPerContext
			*averageNumberOfInfostoreObjectsPerSchema
			*numberOfNewInfostoreObjectsInTheLast30Days
			*numberOfChangedInfostoreObjectsInTheLast30Days
			*numberOfUsersWithNewInfostoreObjectsInTheLast30Days
			*numberOfDocumentsBetween1ByteAnd3KB
			*numberOfDocumentsBetween3KBAnd10KB
			*numberOfDocumentsBetween10KBAnd30KB
			*numberOfDocumentsBetween30KBAnd100KB
			*numberOfDocumentsBetween100KBAnd300KB
			*numberOfDocumentsBetween300KBAnd1MB
			*numberOfDocumentsBetween1MBAnd3MB
			*numberOfDocumentsBetween3MBAnd10MB
			*numberOfDocumentsBetween10MBAnd30MB
			*numberOfDocumentsBetween30MBAnd100MB
			*numberOfDocumentsBetween100MBAnd300MB
			*numberOfDocumentsBetween300MBAnd1GB
			*numberOfDocumentsBetween1GBAndINFINITE
			*numberOfContacts
			*numberOfUsersWhoCreatedContacts
			*numberOfUsersWhoChangedTheirContactsInTheLast30Days
			*averageNumberOfContactsPerUserWhoHasContactsAtAll
			*numberOfUsersWithLinkedSocialNetworkingAccounts
			*numberOfUsersWhoSelectedTeamViewAsCalendarDefault
			*numberOfUsersWhoSelectedCalendarViewAsCalendarDefault
			*numberOfUsersWhoSelectedListViewAsCalendarDefault
			*numberOfUsersWhoSelectedCardsViewAsContactsDefault
			*numberOfUsersWhoSelectedListViewAsContactsDefault
			*numberOfUsersWhoSelectedListViewAsTasksDefault
			*numberOfUsersWhoSelectedHSplitViewAsContactsDefault
			*numberOfUsersWhoSelectedListViewAsInfostoreDefault
			*numberOfUsersWhoSelectedListViewAsContactsDefault
			*numberOfUsersWhoActivatedMiniCalendar

Karsten.will at 12:25, 11 January 2012

2012-01-11T12:25:14Z

← Older revision		Revision as of 12:25, 11 January 2012
Line 1:		Line 1:
	What is this?		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		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		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		/opt/open-xchange/etc/groupware/configdb.properties. It is also possible to specify all parameters explicitly. Output is a single

Karsten.will at 12:24, 11 January 2012

2012-01-11T12:24:28Z

← Older revision		Revision as of 12:24, 11 January 2012
Line 8:		Line 8:
	easy.		easy.

	{{InstallPlugin\|pluginname=open-xchange-~~oauth-msn open-xchange-subscribe-msn~~\|sopath=stable}}		{{InstallPlugin\|pluginname=open-xchange-datamining\|sopath=stable}}

	=Usage=		=Usage=

Karsten.will at 12:24, 11 January 2012

2012-01-11T12:24:04Z

← Older revision		Revision as of 12:24, 11 January 2012
Line 7:		Line 7:
	is camelCased-Parameters, unique and one per line. This should make using these files as input, for example for a visualization, pretty		is camelCased-Parameters, unique and one per line. This should make using these files as input, for example for a visualization, pretty
	easy.		easy.

			{{InstallPlugin\|pluginname=open-xchange-oauth-msn open-xchange-subscribe-msn\|sopath=stable}}

	=Usage=		=Usage=

Karsten.will: /* Available Parameters */

2012-01-11T12:22:22Z

Available Parameters

← Older revision		Revision as of 12:22, 11 January 2012
Line 13:		Line 13:
	=Available Parameters=		=Available Parameters=

	-?, -h, --help Print ~~this helpfile~~		-?, -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
	* -p, --dbPassword <dbpassword> Password for the user specified with "-dbUser"		-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: )		--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?=

Karsten.will at 12:21, 11 January 2012

2012-01-11T12:21:14Z

← Older revision		Revision as of 12:21, 11 January 2012
Line 8:		Line 8:
	easy.		easy.

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

	==Available Parameters==:		=Available Parameters=

	-?, -h, --help Print this helpfile		-?, -h, --help Print this helpfile
Line 22:		Line 22:
	-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?=