Query number of rooted android devices using the app-CodePudding

I've noticed Firebase Crashlytics has knowledge whether device is rooted or no:

Is it possible to get this data via query - minimum for devices that crashed, maximum for any device using Google Analytics?

CodePudding user response：

You can export the Crashlytics data into BigQuery. However, as this information is only collected by Crashlytics, you will be able to obtain the number of rooted devices that have reported a crash but this won't tell you the percentage of rooted devices out of all the devices using the app as there could be rooted devices that haven't reported crashes.

This is an example on how to query this information from the Crashlytics dataset:

SELECT COUNT(installation_uuid) as rooted_crashed_devices from (
  SELECT installation_uuid FROM `<Crashlytics table>` 
  WHERE operating_system.modification_state = 'MODIFIED'
  GROUP BY installation_uuid
);

This is the result from the query:

rooted_crashed_devices
500

A possible workaround could be sending this information as an Analytics event, and then use BigQuery to get this information.