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.  

1. From the sidebar, be sure the Load managed devices from tab is selected.
2. By default, Admin console is selected as the load method.
3. 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.
4. 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.
5. If you want to include telemetry data in the import, set the Include device telemetry data toggle to ON.
6. 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.

7. At the prompt, click Continue.
8. 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
   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
   Reported Activity
     Last Sync
     Last Known IP
     Last Known WAN IP
     Last Enrollment Time
   Hardware State
     Status
     Major Chrome Version
     Boot Mode
   Device Telemetry
     Battery Health
     Storage Used
     Total Storage (GB)
     Available Storage (GB)

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