Load Devices From a List of Asset Ids or Serial Numbers

Importing devices from your clipboard or a USB barcode scanner can be a very efficient way of performing bulk updates, deprovisioning, or enabling/disabling operations on a set of devices. This method works well with devices whose Asset IDs or SNs live in a document or Sheet, as well as for 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 import and make updates to one or more devices by Serial Number or by asset ID.

  1. From the sidebar, be sure the Load managed devices from tab is selected.
  2. In the Load managed devices from… field, select List of IDs.
  3. Place your cursor in the text area and scan a barcode with either device serial number or asset ID, followed by a newline or Enter.

    Note: Most scanners ship with a set of configuration barcodes that can be used to make them auto-insert newlines after each scan.

  4. If you want to include telemetry data in the import, set the Include device telemetry data toggle to ON.
  5. 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.
  6. Click Load to Sheet. Data loads to the Devices 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
    Hardware Details
      Auto Update Expiration
      Mac Address
      Ethernet Mac Address
    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
    Reported Activity
      Last Sync
      Last Known IP
      Last Known WAN IP
      Last Enrollment Time
    Hardware State
      Major Chrome Version
      Boot Mode


Resolving Duplicate Asset Ids

During manual entry of device id/serial numbers, you may enter the same device id more than once. When there are duplicate IDs, a warning message appears showing how many duplicates there are and a box showing the first 10 duplicates. Load to Sheet is not available while there are duplicates.

To manually resolve duplicate asset IDs:

  1. Use the list box of the first 10 duplicates to help locate the duplicate in the Serial number box.
  2. Delete or revise the id as necessary.
  3. Continue until there are no duplicates. 
  4. Click Load to Sheet.


To remove the duplicates:

  1. Click Fix it
  2. Click Load to Sheet.


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 the Admin console

Load devices from device cache

Load devices from CSV file


Document Version Date Description of Change


Articles in this section