Aggregate domain reports

Aggregate domain reports can be created or refreshed from the Chrome Gopher sidebar.  All domain reports can be set to refresh automatically once every 24 hours via the toggle.  The exact time of the refresh will be determined randomly based on the last auto-refresh time of your device cache, however it will be timestamped in cell A1 of the relevant report tab.  

Setting up auto-refreshing reports on a Sheet and sharing the doc can be a great way to provide dashboards to non-IT-admin stakeholders like principals, superintendents, and technology integrators to gain insight into how devices are being used throughout the domain. 

Screen_Shot_2017-05-03_at_1.07.53_PM.png Screen_Shot_2017-05-03_at_1.08.51_PM.png

The OU 15-day Activity report displays a snapshot of device utilization and policy sync activity in the last 15 calendar days across org units.

Screen_Shot_2017-05-03_at_1.10.37_PM.png

The OS version report shows totals for each major and minor OS version running across the entire domain.

OS Version by OU provides the same information, but broken out by org unit

The Model / EOL report shows totals for each model, along with end-of-life date, for all active and deprovisioned devices on the domain.

Model / EOL by OU shows the same information, but broken out by org unit.

Daily Activity by OU provides a day-by-day accounting of available devices, device utilization (in avg. minutes per device and % of fleet utilized) as well as a count of devices not synced.  This report will contain the most recent 15 calendar days when it is first run.  When refreshed daily (via the "Refresh domain reports daily" option) data for new calendar days will continue to be appended to the report so that it always contains the 30 most recent calendar days.  Note that to avoid overloading the Sheet, this report will purge any data older than 30 days when refreshed.

Screen_Shot_2017-05-03_at_1.12.03_PM.png