Analytics Data - 10.x

SQL for Confluence captures analytics data and stores this in a private analytics database hosted by Amazon Web Services in the United States of America. The app collects a limited amount of information in order to help us make decisions on where to invest for future releases.  To improve the customer support experience, we do include the Support Entitlement Number (SEN).

You can opt out at any point by toggling the Send statistics and help us improve option to off within the app's Global configuration page.

Install 

This data is collected each time the app is installed. 

{
  "event": {
    "timestamp": "2019-06-05T06:00:02.300Z",
    "created_at": "2019-06-05T06:00:03.311Z",
    "id": "5cf75a630bbd190001487cfc"
  },
  "eventInfo": {
    "type": "install"
  },
  "hostInfo": {
    "hostVersion": "6.10.0",
    "hostEdition": 100,
    "hostIsEvaluation": false,
    "hostIsDataCenter": false,
    "hostSEN": "SEN-L12345678",
    "hostServerId": "CONF-X-XXXX-XXXX",
    "hostMaxUsers": "100",
    "hostLicenseType": "DEVELOPER"
  },
  "pluginInfo": {
    "pluginKey": "org.swift.confluence.sql",
    "isUnlimitedUsers": true,
    "pluginVersion": "10.0.0-SNAPSHOT",
    "pluginLicenseError": "NONE",
    "isDataCenter": false,
    "isEvaluation": false,
    "isSubscription": false,
    "pluginLicenseType": "COMMERCIAL",
    "isMaintenanceExpired": false,
    "pluginLicenseSEN": "SEN-12345678"
  }
}


License Added

This data is collected when the user adds a new license to the app.

{
  "event": {
    "timestamp": "2019-05-27T10:41:44.639Z",
    "created_at": "2019-05-27T10:41:44.900Z",
    "id": "5cebbee84a2be100011b785d"
  },
  "eventInfo": {
    "type": "license-added"
  },
  "hostInfo": {
    "hostVersion": "6.0.7",
    "hostEdition": 100,
    "hostIsEvaluation": false,
    "hostIsDataCenter": false,
    "hostSEN": "SEN-L12345678",
    "hostServerId": "CONF-123X-XXXX-XXXX",
    "hostMaxUsers": "100",
    "hostLicenseType": "DEVELOPER"
  },
  "pluginInfo": {
    "pluginKey": "org.swift.confluence.sqlexpress",
    "isUnlimitedUsers": true,
    "pluginVersion": "10.0.0-SNAPSHOT",
    "pluginLicenseError": "NONE",
    "isDataCenter": false,
    "isEvaluation": false,
    "isSubscription": false,
    "pluginLicenseType": "COMMERCIAL",
    "isMaintenanceExpired": false,
    "pluginLicenseSEN": "SEN-12345678"
  }
}

Profile

This data is collected when the administrator creates a new Profile on the Global Configuration page. 

{
  "event": {
    "timestamp": "2019-06-06T06:12:39.189Z",
    "created_at": "2019-06-06T06:12:39.500Z",
    "id": "5cf8aed7134aaa00017197b4"
  },
  "eventInfo": {
    "type": "ADDED",
    "settings": {
      "dbuser": "true",
      "showsqloptions": null,
      "datasourcename": null,
      "profilename": "true",
      "limitquerytime": 0,
      "rootds": null,
      "initialsqls": null,
      "dbdriverclass": "org.postgresql.Driver",
      "aftersql": null,
      "limitrowsprocessed": 0,
      "beforesql": null,
      "referreddatasourceglobal": false,
      "dbjarlocation": "lib/postgresql-42.2.2.jar",
      "limitmaxactive": -1,
      "dbpassword": "true",
      "dburl": "true",
      "connectionproperties": null,
      "id": 0
    }
  },
  "hostInfo": {
    "hostVersion": "6.12.0",
    "hostEdition": 100,
    "hostIsEvaluation": false,
    "hostIsDataCenter": false,
    "hostSEN": "SEN-L13252798",
    "hostServerId": "CONF-591X-XXXX-XXXX",
    "hostMaxUsers": "100",
    "hostLicenseType": "DEVELOPER"
  },
  "pluginInfo": {
    "pluginKey": "org.swift.confluence.sql",
    "isUnlimitedUsers": true,
    "pluginVersion": "10.0.0-SNAPSHOT",
    "pluginLicenseError": "NONE",
    "isDataCenter": false,
    "isEvaluation": false,
    "isSubscription": false,
    "pluginLicenseType": "COMMERCIAL",
    "isMaintenanceExpired": false,
    "pluginLicenseSEN": "SEN-12345678"
  }
}

Migration

This data is collected each time the app is upgraded to version 9 and above. 

{
  "event": {
    "timestamp": "2019-05-31T05:59:03.396Z",
    "created_at": "2019-05-31T05:58:57.155Z",
    "id": "5cf0c2a1077bf3000101c5f5"
  },
  "eventInfo": {
    "type": "profile",
    "settings": {
      "dbuser": null,
      "showsqloptions": null,
      "datasourcename": "true",
      "profilename": "true",
      "limitquerytime": 0,
      "rootds": "true",
      "initialsqls": null,
      "dbdriverclass": null,
      "aftersql": null,
      "limitrowsprocessed": 0,
      "beforesql": null,
      "referreddatasourceglobal": true,
      "dbjarlocation": null,
      "limitmaxactive": -1,
      "dbpassword": null,
      "dburl": null,
      "connectionproperties": null,
      "id": 0
    }
  },
  "hostInfo": {
    "hostVersion": "6.10.0",
    "hostEdition": 25,
    "hostIsEvaluation": false,
    "hostIsDataCenter": false,
    "hostSEN": "SEN-L6807636",
    "hostServerId": "ABC1-DEF2-3GHI-4JKL",
    "hostMaxUsers": "25",
    "hostLicenseType": "DEVELOPER"
  },
  "pluginInfo": {
    "pluginKey": "org.swift.confluence.sql",
    "isUnlimitedUsers": true,
    "pluginVersion": "10.0.0-SNAPSHOT",
    "pluginLicenseError": "NONE",
    "isDataCenter": false,
    "isEvaluation": false,
    "isSubscription": false,
    "pluginLicenseType": "COMMERCIAL",
    "isMaintenanceExpired": false,
    "pluginLicenseSEN": "SEN-12345678"
  }
}

Global Configuration 

This data is collected when the administrator changes the app's global configuration.  

{
  "event": {
    "timestamp": "2019-06-04T10:04:18.644Z",
    "created_at": "2019-06-04T10:04:18.944Z",
    "id": "5cf6422258171600010698af"
  },
  "eventInfo": {
    "type": "globalconfig",
    "settings": {
      "disableAntiXSS": true,
      "configCreated": "2019-06-04T09:44:41.205+0000",
      "limitRowsProcessed": 1000,
      "limitQueryTime": 10,
      "express": false,
      "isolationLevel": "REPEATABLE_READ",
      "schemaVersion": "1",
      "type": null,
      "sendStatistics": true,
      "configUpdated": "2019-06-04T10:04:18.639+0000"
    }
  },
  "hostInfo": {
    "hostVersion": "6.13.0",
    "hostEdition": 100,
    "hostIsEvaluation": false,
    "hostIsDataCenter": false,
    "hostSEN": "SEN-L12345678",
    "hostServerId": "CONF-123X-XXXX-XXXX",
    "hostMaxUsers": "100",
    "hostLicenseType": "DEVELOPER"
  },
  "pluginInfo": {
    "pluginKey": "org.swift.confluence.sql",
    "isUnlimitedUsers": true,
    "pluginVersion": "10.0.0-SNAPSHOT",
    "pluginLicenseError": "NONE",
    "isDataCenter": false,
    "isEvaluation": false,
    "isSubscription": false,
    "pluginLicenseType": "COMMERCIAL",
    "isMaintenanceExpired": false,
    "pluginLicenseSEN": "SEN-12345678"
  }
}


Macro

This data is collected on the when a user creates a new page and inserts the macro.

{
  "event": {
    "timestamp": "2019-06-06T06:47:18.691Z",
    "created_at": "2019-06-06T06:47:18.882Z",
    "id": "5cf8b6f6919ad50001c88292"
  },
  "eventInfo": {
    "type": "new-macro",
    "macroName": "sql",
    "macroParms": {
      "parameterscount": 3,
      "datasource": "true",
      "table": "false",
      "output": "wiki",
      "heading": "0",
      "atlassian-macro-output-type": "INLINE"
    }
  },
  "hostInfo": {
    "hostVersion": "6.12.0",
    "hostEdition": 100,
    "hostIsEvaluation": false,
    "hostIsDataCenter": false,
    "hostSEN": "SEN-L1234567",
    "hostServerId": "CONF-591X-XXXX-XXXX",
    "hostMaxUsers": "100",
    "hostLicenseType": "DEVELOPER"
  },
  "pluginInfo": {
    "pluginKey": "org.swift.confluence.sql",
    "isUnlimitedUsers": true,
    "pluginVersion": "10.0.0-SNAPSHOT",
    "pluginLicenseError": "NONE",
    "isDataCenter": false,
    "isEvaluation": false,
    "isSubscription": false,
    "pluginLicenseType": "COMMERCIAL",
    "isMaintenanceExpired": false,
    "pluginLicenseSEN": "SEN-1234567"
  }
}

Error

This data is collected for all error instances encountered by the user while using the macro.

{
  "event": {
    "timestamp": "2019-02-28T16:47:21.938Z",
    "created_at": "2019-02-28T16:47:02.849Z",
    "id": "5c781086f73e1d00013a68f4"
  },
  "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": "ABC1-D2EF-3GHI-4JKL",
    "hostLicenseType": "DEVELOPER"
  },
  "pluginInfo": {
    "pluginVersion": "9.1.0",
    "pluginLicense": "COMMERCIAL",
    "pluginLicenseSEN": "SEN-L12345678",
    "pluginKey": "org.swift.confluence.sqlexpress"
  }
}
Uninstall 

This data is collected each time the app is uninstalled. 

{
  "event": {
    "timestamp": "2019-06-05T06:18:57.019Z",
    "created_at": "2019-06-05T06:18:54.840Z",
    "id": "5cf75ecec8072b0001f2133d"
  },
  "eventInfo": {
    "type": "uninstall"
  },
  "hostInfo": {
    "hostVersion": "6.10.0",
    "hostEdition": 25,
    "hostIsEvaluation": false,
    "hostIsDataCenter": false,
    "hostSEN": "SEN-123475678",
    "hostServerId": "ABC1-DEFG-2HIJ-3K4L",
    "hostMaxUsers": "25",
    "hostLicenseType": "DEVELOPER"
  },
  "pluginInfo": {
    "pluginKey": "org.swift.confluence.sql",
    "isUnlimitedUsers": true,
    "pluginVersion": "10.0.0-SNAPSHOT",
    "pluginLicenseError": "NONE",
    "isDataCenter": false,
    "isEvaluation": false,
    "isSubscription": false,
    "pluginLicenseType": "COMMERCIAL",
    "isMaintenanceExpired": false,
    "pluginLicenseSEN": "SEN-12345678"
  }
}