If you haven’t tried the feature recently, you’ll soon see that Sheets column filters provide raw data-exploring horsepower on your Chrome device data. This means a big boost to your device management intelligence, efficiency, and decision-making.
Row 1 filters are turned on / off in Sheets via the beer funnel icon.
Better yet, because Chrome Gopher’s bulk update feature also respects Sheets filters, you can quickly make metadata and org unit updates on a filtered subset of devices.
Some examples of questions and filter combinations you might apply on your device data:
Which devices were enrolled before a specific date?
Filter the Sheet to limit your view by Last Enrollment Date column using the and use the “Date is before” -> “exact date…” filter.
Perhaps you enrolled a set of devices for a specific location within a certain date range. Once you identify the devices, you want to mass-populate Annotated Location and move them into a sub organization by editing their Org Unit Path.
Which devices haven’t been synced in a while?
Filter by Last Sync Date and use the “Date is before” -> “exact date…” filter.
This is useful because it tells you where devices are under-utilized, which is helpful for making smart training and resource allocation decisions.
What devices in the “Junior High School” haven’t been synced in a while?
Take the filtered result set from above, and add another column filter to the Annotated Location or Org Unit Path column to select for the school where those devices live.
Perhaps specific teacher(s) need more support to be successful integrating their Chromebooks?
Which of my devices is missing an annotated asset ID?
Filter by Annotated Asset ID and select only blanks.
This may be useful to identify inconsistent asset tagging practices during enrollment and get up to snuff with barcoding and inventory.