What data does Chrome Gopher make available on loaded devices?

By default, to improve readability, Chrome Gopher hides certain columns of device data.  To make all columns visible, you can manually unhide them in Sheets, or use the handy Set visible columns tab in the sidebar (see right). Screen_Shot_2017-09-14_at_5.11.08_PM.png

 

Data columns are grouped by type into the following three colors (categories):

 Editable device properties These can be modified in the sheet and applied to the Admin Console via the Bulk Update action
 Calculated values (read only) NEW!! These are derived from values in the G Suite admin console and various lookup tables on last load to Sheet.
Last reported admin console values (read only) 

These are values as reported directly from the G Suite admin console on last load to Sheet.

 

Editable device properties
 Org Unit Path The branch in the domain org unit tree in which this device resides.  Org units can be used to manage device policy settings.
Annotated User The user assigned to the device during enrollment, from the admin console, or upon most recent update via API.
 Annotated Location The location assigned from the admin console, or upon most recent update via API.
 Annotated Asset ID The Asset ID assigned to the device during enrollment, from the admin console, or upon most recent update via API.  This can be quite useful within Chrome Gopher if it is also associated with a scannable barcode on the device.
 Notes The notes assigned from the admin console, or upon most recent update via API.  Often used as a catchall for other metadata.

 

Calculated values (read only) NEW!
 Number of major Chrome versions behind Each Chrome device model may have a different stable release available (as the official recovery OS).  This number lets you know how many major versions this device is behind the latest.  May be negative if your devices  are ahead of most recent recovery OS image.
 Latest stable Chrome version for model Each Chrome device model may have a different stable release available.  This number is looked up against Google's official tables using the model and firmware as reported in the admin console.  May be "Unknown" if the lookup fails based on this information.
 Auto Update Expiration The end date of Google's official support for Chrome version auto-updates. See this article.
 Most recent user is annotated user TRUE if they match,  FALSE if not, blank if not applicable.  Useful in environments with assigned users for devices.
 Most recent user The most recent user as recorded in the list of recent users available via the admin console.  Requires device settings be set to allow collection of this info.
 Active dates in last 15 days A count of the number of dates of usage activity for this device as reported in the admin console within the last 15 calendar days.
 Active minutes in last 15 days

A count of the number of minutes of usage activity for this device as reported in the admin console within the last 15 calendar days.

 

 

For admin console value field meanings, see this API resource definition.  Some of these fields are flattened or formatted to Sheets formats upon import.  They are all READ ONLY.

Last reported admin console values (read only) 
Serial Number serialNumber
Mac Address macAddress
Ethernet Mac Address ethernetMacAddress
Device ID deviceId
Status status
Major Chrome Version Calculated from osVersion
Chrome Version osVersion
Model model
Platform Version platformVersion
Firmware Version firmwareVersion
Last Sync lastSync
Last Enrollment Time lastEnrollmentTime
Boot Mode bootMode
eTag eTag
Support End Date supportEndDate
Support Auto Renew willAutoRenew
Order Number orderNumber
Mobile Equipment Identifier meid
Recent Users recentUsers (list)
Recent Sessions activeTimeRanges (list)