Load Devices From the Admin Console

Loading from the Admin console offers very basic queries based on Org Unit Path and Enrollment Date or device status. Once a device import has been run, a Devices Spreadsheet tab will fill with all available data on all devices that match your query. More advanced filters now become possible via the native Sheets filter functionality by choosing the filter functionality. You can toggle filters on and off using the funnel icon in the Sheets toolbar.  

From the sidebar, be sure the Load managed devices from tab is selected. By default, Admin console is selected as the load method. Select query parameters using the Where and And drop-downs: Where: This filter lets you select a specific status of devices to load. Options include is Active, is Disabled, is Deprovisioned, is Pre-provisioned, and is any status. And: Lets you narrow devices to load from specific OUs. And: Lets you narrow devices to load based on enrollment date. If you are using Gopher Buddy and want to include that data in Gopher for Chrome, set the Include data collected from the Gopher Buddy extension toggle to ON. If you want to include telemetry data in the import, set the Include device telemetry data toggle to ON. Click Load to Sheet. Caution: If you have not visited the Reports tab and authorized reports, Load to Sheet will not be available. In its place, the Authorize button appears. Click Authorize, then Load to Sheet appears. At the prompt, click Continue. At the finished prompt click Dismiss. Data loads to the Device tab in the following sections/columns:

Hardware Details (required)
  Device ID
  Serial Number
Editable Device Properties
  Org Unit Path
  Annotated User
  Annotated Location
  Annotated Asset ID
  Notes
Hardware Details
  Model
  Auto Update Expiration
  Mac Address
  Ethernet Mac Address
  Mobile Equipment Identifier
  Order Number
Device Telemetry
  Battery Health
  Storage Used
  Total Storage (GB)
  Available Storage (GB)
Calculated Values (read only-derived from Admin console & lookup tables
  Number of major Chrome versions behind
  Latest stable Chrome version for model
  Most Recent User is Annotated User
  Most Recent User
  Active Dates in Last 15 Days
  Active Minutes in Last 15 Days
Reported Activity
  Last Sync
  Last Known IP
  Last Known WAN IP
  Last Enrollment Time
  Recent Users
  Recent Sessions
Hardware State
  Status
  Major Chrome Version
  Chrome Version
  Platform Version
  Firmware Version
  Boot Mode
  eTag
  Support End Date
  Support Auto Renew
Trusted Platform Module
  Family
  TPM Firmware Version
  Manufacturer
  Specification Level
  TPM Model
  Vendor-Specific Information

Best practices: Once your import is complete, click More Filters to learn about using the power of Google Sheets filters to drill down on and make updates to subsets of devices. Whoa! Too many columns to take in? Click (hamburger icon) in the sidebar to quickly hide columns you don’t need.

Once you load devices you can make changes in the sheets you can use bulk actions to make changes to the devices.

See also:

Load devices from a list of Asset IDs or Serial Number

Load devices from device cache

Load devices from CSV file

Document Version	Date	Description of Change
1.0	3/12/2024	Updated link to open in same tab
1.1	5/6/2024	Added animated GIF
1.2	7/12/2024	Updated columns list, reverified