When you launch Chrome Gopher in a blank Google Sheet, you will see the Load devices sidebar tab, which allows you to import managed devices to the "Devices" tab via one of three sources:
- Admin panel
- CSV file
Loading devices from the Admin panel
Loading from the admin panel offers very basic queries based on Org Unit Path and Enrollment Date. 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!
Some additional Spreadsheet tabs will be generated (only) on a full device import:
- OU Activity -- counts of devices in each org unit, and provides averages of active device usage metrics within each OU.
- OS Version -- counts of devices by OS version.
- OS Version by OU -- counts of devices by major version within each org unit.
Importing devices from a CSV file
Importing devices from a CSV file is ideal for working with exports from a 3rd party asset management system. A valid CSV file for import must contain device Serial Number and may additionally contain Annotated User, Annotated Asset ID, Annotated Location, and Notes data. Column headers in the CSV file must match those shown here in bold. Importing from CSV file is a multi-step process, in which you will be prompted to preview your import before performing an update.
Once the devices in your CSV file have been successfully "looked up" on the domain, you can review and modify their settings before updating them.
Loading devices from Scanned IDs
Importing devices from a scanner can be a very efficient way of performing bulk updates to a set of physically co-located devices, such as a group of machines in a single laptop cart, or as devices are enrolled during unboxing. You can use this feature to scan by serial number, or by asset id.
|Place your cursor in the text area and scan a bar code with either device serial number or asset ID, followed by a newline (or Enter). Most scanners ship with a set of configuration barcodes that can be used to make them auto-insert newlines after each scan. Once the devices have been imported to the Devices tab, perform your updates in the Sheet and click the Update button.||