Load Devices From a List of Asset Ids or Serial Numbers

Importing devices from your clipboard or a USB barcode scanner can be an efficient way to perform bulk updates, deprovisioning, or turn operations on or off 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 with physically co-located devices, such as a group of machines in a single laptop cart, or devices enrolled during unboxing.

You can use this feature to import and update one or more devices by Serial Number or 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 the device serial number or the asset ID, followed by a newline or Enter.
   Note: Most scanners ship with a set of configuration barcodes that can be used to automatically 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
  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

Resolving Duplicate Asset Ids

When manually entering device ID/serial numbers, you may enter the same device ID multiple times. 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 unavailable when 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 and use bulk actions to update devices.

See also:

Load devices from the Admin console

Load devices from device cache

Load devices from CSV file