Analytics Data

SQL for Confluence captures analytics events from installs and stores this in a private analytics database hosted by Amazon Web Services in the United States of America.

To improve the customer support experience, we do include the Support Entitlement Number (SEN).

An example of the analytics data we receive:

SEN	Action	Event Data	Timestamp
SEN-XXXXXXX	Error	"eventInfo": { "UPDATE": "Error while editing profile sdfsdf. Check logs for details." }, "hostInfo": { "hostVersion": "6.10.0", "hostIsEvaluation": false, "hostLicenseLevel": "25", "hostIsDataCenter": false, "hostEdition": 25, "hostServerId": "BAM3-Y5GJ-6EDS-4A8R", "hostLicenseType": "DEVELOPER" }, "pluginInfo": { "pluginVersion": "9.1.0", "pluginLicense": "COMMERCIAL", "pluginLicenseSEN": "SEN-L13051025", "pluginKey": "org.swift.confluence.sqlexpress" }	2018-03-09 12:51:31.488+00
SEN-XXXXXXX	GlobalConfig	"eventInfo": { "type": "globalconfig", "settings": { "disableAntiXSS": false, "configCreated": "2019-03-01T08:22:07.608+0000", "limitRowsProcessed": 2147483647, "limitQueryTime": 0, "express": false, "isolationLevel": "READ_COMMITTED", "schemaVersion": "1", "type": null, "sendStatistics": true, "configUpdated": "2019-03-01T08:22:53.733+0000" } }, "hostInfo": { "hostVersion": "6.10.0", "hostEdition": 25, "hostIsEvaluation": false, "hostIsDataCenter": false, "hostSEN": "SEN-L6807636", "hostServerId": "BAM3-Y5GJ-6EDS-4A8R", "hostMaxUsers": "25", "hostLicenseType": "DEVELOPER" }, "pluginInfo": { "pluginKey": "org.swift.confluence.sql", "isUnlimitedUsers": true, "pluginVersion": "9.2", "pluginLicenseError": "NONE", "isDataCenter": false, "isEvaluation": false, "isSubscription": false, "pluginLicenseType": "COMMERCIAL", "isMaintenanceExpired": false, "pluginLicenseSEN": "SEN-10324172" }	2018-01-19 22:41:31.188+00
SEN-XXXXXXX	Install	"eventInfo": { "type": "install" }, "hostInfo": { "hostVersion": "6.10.0", "hostEdition": 25, "hostIsEvaluation": false, "hostIsDataCenter": false, "hostSEN": "SEN-L6807636", "hostServerId": "BAM3-Y5GJ-6EDS-4A8R", "hostMaxUsers": "25", "hostLicenseType": "DEVELOPER" }, "pluginInfo": { "pluginKey": "org.swift.confluence.sql", "isUnlimitedUsers": true, "pluginVersion": "9.2", "pluginLicenseError": "NONE", "isDataCenter": false, "isEvaluation": false, "isSubscription": false, "pluginLicenseType": "COMMERCIAL", "isMaintenanceExpired": false, "pluginLicenseSEN": "SEN-10324172" }	2017-06-08 23:00:31.244+00
SEN-XXXXXXX	Migration	"eventInfo": { "globalconfig": { "disableAntiXSS": false, "configCreated": "2019-03-11T17:02:08.141+0000", "limitRowsProcessed": 2147483647, "limitQueryTime": 0, "express": false, "isolationLevel": "READ_COMMITTED", "schemaVersion": "1", "type": "migration", "sendStatistics": true, "configUpdated": null } }, "hostInfo": { "hostVersion": "6.14.0", "hostIsEvaluation": false, "hostLicenseLevel": "2000", "hostIsDataCenter": false, "hostEdition": 2000, "hostServerId": "B14V-DWB6-CGDD-C1J4", "hostLicenseType": "DEVELOPER" }, "pluginInfo": { "pluginVersion": "9.1.0", "pluginLicense": "COMMERCIAL", "pluginLicenseSEN": "SEN-3601558", "pluginKey": "org.swift.confluence.sql" }	2017-07-30 02:02:02.222+00
SEN-XXXXXXX	Profile	"eventInfo": { "type": "profile", "settings": { "limitRowsProcessed": -1, "showSqlOptions": null, "dataSourceName": "testDS", "limitQueryTime": 0, "profileCreated": null, "initialSQLs": null, "dbdriverClass": "org.postgresql.Driver", "afterSQL": null, "profileUpdatedDate": null, "beforeSQL": null, "referredDataSourceGlobal": true, "dbjarLocation": null, "rootDS": "testDS", "profileUpdated": null, "profileCreatedDate": 1551428634766, "limitMaxActive": -1, "profileName": "profile2", "connectionProperties": null, "type": null, "id": 0 } }, "hostInfo": { "hostVersion": "6.10.0", "hostEdition": 25, "hostIsEvaluation": false, "hostIsDataCenter": false, "hostSEN": "SEN-L6807636", "hostServerId": "BAM3-Y5GJ-6EDS-4A8R", "hostMaxUsers": "25", "hostLicenseType": "DEVELOPER" }, "pluginInfo": { "pluginKey": "org.swift.confluence.sql", "isUnlimitedUsers": true, "pluginVersion": "9.2", "pluginLicenseError": "NONE", "isDataCenter": false, "isEvaluation": false, "isSubscription": false, "pluginLicenseType": "COMMERCIAL", "isMaintenanceExpired": false, "pluginLicenseSEN": "SEN-10324172" }	2017-11-09 12:55:04.108+00
SEN-XXXXXXX	Uninstall	"eventInfo": { "type": "uninstall" }, "hostInfo": { "hostVersion": "6.10.0", "hostEdition": 25, "hostIsEvaluation": false, "hostIsDataCenter": false, "hostSEN": "SEN-L6807636", "hostServerId": "BAM3-Y5GJ-6EDS-4A8R", "hostMaxUsers": "25", "hostLicenseType": "DEVELOPER" }, "pluginInfo": { "pluginKey": "org.swift.confluence.sql", "isUnlimitedUsers": true, "pluginVersion": "9.2", "pluginLicenseError": "NONE", "isDataCenter": false, "isEvaluation": false, "isSubscription": false, "pluginLicenseType": "COMMERCIAL", "isMaintenanceExpired": false, "pluginLicenseSEN": "SEN-10324172" }	2017-03-09 12:51:31.488+00
SEN-XXXXXXX	License Updated	"eventInfo": { "type": "license-updated" }, "hostInfo": { "hostVersion": "6.14.0", "hostEdition": 25, "hostIsEvaluation": false, "hostIsDataCenter": false, "hostSEN": "SEN-L6807636", "hostServerId": "CONF-591X-XXXX-XXXX", "hostMaxUsers": "25", "hostLicenseType": "DEVELOPER" }, "pluginInfo": { "pluginKey": "org.swift.confluence.sql", "isUnlimitedUsers": true, "pluginVersion": "9.2", "pluginLicenseError": "NONE", "isDataCenter": false, "isEvaluation": false, "isSubscription": false, "pluginLicenseType": "COMMERCIAL", "isMaintenanceExpired": false, "pluginLicenseSEN": "SEN-10324172" }
SEN-XXXXXXX	License Added	"eventInfo": { "type": "license-added" }, "hostInfo": { "hostVersion": "6.10.0", "hostEdition": 25, "hostIsEvaluation": false, "hostIsDataCenter": false, "hostSEN": "SEN-L6807636", "hostServerId": "BAM3-Y5GJ-6EDS-4A8R", "hostMaxUsers": "25", "hostLicenseType": "DEVELOPER" }, "pluginInfo": { "pluginKey": "org.swift.confluence.sql", "isUnlimitedUsers": true, "pluginVersion": "9.1.1-SNAPSHOT", "pluginLicenseError": "NONE", "isDataCenter": false, "isEvaluation": false, "isSubscription": false, "pluginLicenseType": "COMMERCIAL", "isMaintenanceExpired": false, "pluginLicenseSEN": "SEN-10324172" }
SEN-XXXXXXX	New Macro - SQL	"eventInfo": { "type": "new-macro", "macroName": "sql", "macroParms": { "table": "false", "datasource": "testDS", "noDataError": "true" } }, "hostInfo": { "hostVersion": "6.11.0", "hostEdition": 25, "hostIsEvaluation": false, "hostIsDataCenter": false, "hostSEN": "SEN-L6807636", "hostServerId": "CONF-591X-XXXX-XXXX", "hostMaxUsers": "25", "hostLicenseType": "DEVELOPER" }, "pluginInfo": { "pluginKey": "org.swift.confluence.sql", "isUnlimitedUsers": true, "pluginVersion": "9.1.1-SNAPSHOT", "pluginLicenseError": "NONE", "isDataCenter": false, "isEvaluation": false, "isSubscription": false, "pluginLicenseType": "COMMERCIAL", "isMaintenanceExpired": false, "pluginLicenseSEN": "SEN-10324172" }

You can opt out at any point by toggling the analytics option to "off" within the product configuration screen.